Desarrolla Sistemas en Visual Basic Net, 4 capas, SQL Server

Develop a robust desktop information management system with Visual Basic .NET and the latest .NET Framework. This comprehensive course guides you through building a powerful application using SQL Server for database management, leveraging stored procedures for efficient data communication.

Key Technologies:

• Visual Basic .NET: Master the core programming language for creating Windows applications.
• .NET Framework: Utilize the latest version for optimal performance and features.
• SQL Server: Implement a reliable database solution with stored procedures.
• Windows Forms: Design intuitive and user-friendly graphical interfaces.
• Microsoft Visual Studio 2019/2022: Learn to effectively use the IDE for development.
• Layered Architecture: Build a scalable, maintainable, and robust application architecture.

Project: Complete Purchase and Sales Desktop System

This course culminates in the creation of a fully functional desktop system for managing purchases and sales, built from the ground up. Gain practical experience with:

• CRUD Operations: Implement Create, Read, Update, and Delete functionalities for independent and relational tables.
• Data Management: Efficiently manage data through well-structured database design.
• Access Control: Secure your application with robust user roles and permissions.
• Reporting & Queries: Generate insightful reports and perform data analysis.

Project Features:

• Warehouse Management (Módulo AlmacénArtículos):
  • Comprehensive management of warehouse items, including category, barcode, name, stock levels, selling price, description, and image.
  • Category management for organized item classification.
• Purchase Management (Módulo ComprasProveedores):
  • Manage suppliers with details like name, type, document number, address, email, and phone.
  • Record purchase/warehouse receipt entries, specifying supplier, date, document type (Invoice, Ticket), document number, and tax information.
  • Detailed entries linking to specific items, allowing quantity selection, purchase price, and proposed selling price.
  • PDF Export: Generate purchase documents and purchase reports in PDF format.
• Sales Management (Módulo VentasClientes):
  • Manage customers with details like name, type, document number, address, email, and phone.
  • Manage sales transactions, including customer, date, document type (Invoice, Ticket), document number, tax information.
  • Detailed sales entries linking to specific items, allowing quantity selection, selling price, and discount application.
  • PDF Export: Generate sales documents and sales reports in PDF format.
• Access Control (Acceso al sistema):
  • Roles Management: Define and manage user roles (Administrator, Seller, Warehouse Staff).
  • User Management: Create and manage users, including name, type, document number, address, phone, email, job title, encrypted login, and assigned role.
• Reporting & Queries (Consultas y Reportes):
  • Sales Inquiry: Search for sales records within specified date ranges.
  • Report Generation: Export data in PDF, Word, and Excel formats for comprehensive analysis.

This course is ideal for developers looking to build practical, real-world desktop applications with Visual Basic .NET, SQL Server, and Windows Forms.