Learn SQL Server & VB Net by Creating an Advanced ERP System

Focused View

Sayed Rahmani

10:56:45

239 View

1. Introduction

1. Introduction.mp4

00:53

2. Take a Look at Final Version of The Software.mp4

05:39

3. Necessary Tools and Software.mp4

01:04

4.1 Working Files.zip

4. How to access working files.mp4

00:50

2. Create SQL Server Schemas

1. Creating Schemas.mp4

01:20

2. Creating Schemas 02.mp4

01:41

3. Setup Tables.mp4

09:33

4. Purchase and Sales Tables.mp4

08:25

5. Purchase and Sales Tables 02.mp4

03:22

6. Expenses Tables.mp4

02:19

3. Creating Front End UI with Visual Studio

1. Creating Main Section UI.mp4

12:28

2. Creating Main Section UI 02.mp4

05:48

4. Login and Control Panel Module

1. Adding Tab Functionality.mp4

04:51

2. Creating Users UI.mp4

10:46

3. Connecting the UI with SQL Server backend.mp4

06:48

4. CRUD Operations.mp4

09:31

5. CRUD Operations 02.mp4

02:53

6. CRUD Operations 03.mp4

09:29

7. CRUD Operations 04.mp4

15:18

5. Setup Module

1. Company Information.mp4

27:33

2. Vendors.mp4

14:45

3. Customers.mp4

00:59

4. Products.mp4

18:31

6. Purchase Module

1. Create Login Section.mp4

13:17

2. Purchase Invoice.mp4

11:30

3. Purchase Invoice 02.mp4

33:52

4. Purchase Invoice 03.mp4

07:18

5. Purchase Invoice 04.mp4

06:25

6. Purchase Invoice 05.mp4

29:30

7. Purchase Invoice 06.mp4

10:56

8. Purchase Invoice 07.mp4

18:09

9. Purchase Return.mp4

07:21

10. Updating Purchase Invoices.mp4

22:25

11. Updating Purchase Invoices 02.mp4

12:00

12. Updating Purchase Invoices 03.mp4

07:50

13. Completing Purchase Invoice.mp4

06:40

14. Completing Purchase Invoice 02.mp4

01:05

15. Purchase Reports.mp4

21:35

16. Purchase Reports 02.mp4

17:07

17. Purchase Reports 03.mp4

10:24

18. Sales Invoice.mp4

30:52

19. Sales Invoice 02.mp4

14:13

20. Sales Reports.mp4

10:16

21. Stock Adjustments.mp4

17:20

22. Stock Adjustments Reports.mp4

11:52

7. Accounting Module

1. Vendors Debit Credit.mp4

06:49

2. Customers Debit Credit.mp4

02:22

3. Cash Entry.mp4

09:29

4. Cash Entry Reports.mp4

13:26

5. Cash Entry Reports 02.mp4

01:24

6. Vendor Ledgers Reports.mp4

24:11

7. Vendor Ledgers Reports 02.mp4

12:04

8. Customer Ledgers Reports.mp4

05:20

9. Low Stock Products.mp4

05:15

10. Zero Stock Products.mp4

04:06

11. Low Credit Customers.mp4

03:51

12. Popup Alarm.mp4

02:56

13. Expense Head.mp4

02:01

14. Expenses.mp4

01:52

15. Deleting Expense Voucher.mp4

03:01

16. Updating Expense Voucher & Expenses Reports.mp4

04:24

17. Profit and Loss Report.mp4

14:54

18. Backup and Restore Database.mp4

12:03

19. Users Permissions.mp4

23:05

20. Users Permissions 02.mp4

07:29

Description

Learn how to create an advanced enterprise windows desktop ERP application

What You'll Learn?

Learn to write simple to advanced and complex queries using SQL Server
Learn to build beautiful and advanced windows forms using Visual Studio
Learn to connect front end forms with the back end SQL Server database
Learn modern technologies to create enterprise desktop applications
Learn to create invoices and print them
Learn to export invoices, grids, and other sections to excel, pdf, word, image and text file
Learn how to work with images in SQL Server and winforms
Learn how to use multi threading in winforms

Who is this for?

Desktop Developers

Visual Studio Developers

SQL Server Developers

C# Developers

Database Engineers

Software Engineers

Winform Developers

Full Stack Developers

What You Need to Know?

Basic knowledge of SQL Server and Visual Basic .Net is required

More details

Description
Requirements
Â· You need to know VB .NET and Microsoft SQL Server basic principles.

Description
Would you like to learn how to create an Advanced Inventory Management System and sell it to companies that want to manage their inventory and billing?
In this course you will learn how to create an Advanced Inventory Management System from scratch using Visual Basic .NET and MS SQL Server, combining several resources that will allow you to offer useful characteristics for any company that needs to open a store or manage their sales and stock.
This is a practical course where I will lead you to step by step in the learning process of creating complex systems VB .NET, when you finish it, you could sell it to your clients or it could be used as a basis to develop other complex systems.

Systemâ€™s characteristics:
Â· Inventory management
Â· Sales and Purchase Management Using Product Name or Barcode
Â· Invoice printing
Â· Dozens of Different Purchase and Sales Reports
Â· Advanced Alarming System
Â· Export all report in Excel, PDF, Text, Image, Word
Â· Stock product control
Â· Expenses Control
Â· Dozens of Other Features

HOWâ€™S THE COURSE?
The course is divided into several sections. In the first section, we will talk about the tools we are going to use for creating the system.
And the following sections we will build, step by step from scratch to advanced sections.

HOW LONG DOES IT TAKE TO COMPLETE THE COURSE?
It is up to you. I guess that it would take less than four weeks to complete it, but it depends on your availability and workflow.

WHAT ARE THE MINIMUM REQUIREMENTS?
Download the material where you can find the resources for the first lesson in each section.
You should have a piece of basic knowledge of VB .NET and SQL Server.

Who this course is for:
Â· This course is for freelancers or entrepreneurs that want to create complex systems with VB .NET and SQL Server and sell them to clients or companies at a business/professional level.

Who this course is for:
Desktop Developers
Visual Studio Developers
SQL Server Developers
C# Developers
Database Engineers
Software Engineers
Winform Developers
Full Stack Developers

User Reviews

Rating

average 0

Total votes0

Focused display

Having spent 10+ years working as a software engineer, full stack developer, windows form developer, database engineer, and UX designer, I believe that programmers can make the world a better place to live.After 5 years of teaching in real-world schools, I hope you have great moments with my courses and really after my classes you will be a real programmer!I am an expert on the following topics:- Easily use Databases: SQL Server, MySQL, MongoDB, Postgres- Web Development: HTML, CSS, JavaScript, React JS, Node JS, Express JS, jQuery, ASP Net Core, Blazor, Django- Windows Applications Development: C#, Visual Basic Net, WPF- My Tutorials = Fun + proficiencyI am available for freelance projects as well.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.