About This Course

The sole purpose of this course is to challenge you to put multiple technologies together while solving real life problems. All of the applications written in this course could be used in the real world with a bit of enhancement.

It is time for you to master C# and SQL by putting them together and pushing yourself to build real life applications. There are no shortcuts or magic potions that will make you good. You will just have to take the course, dedicate your time and learn all of the information.

We are not just going to write simple console applications. We will start with a console application, but then we will build up on top of that and move on to WPF forms using XAML. We will learn about MVVM best practices.

At the same time, each application is going to be a combination of SQL and C# together. We will be building SQL tables, SQL views, SQL stored procedures, SQL user defined data types and much more. Then, we will be using SQL explorer to connect to SQL Server from Visual Studio.

We will be putting SQL data into Excel worksheets and workbooks and emailing them over as an attachment all through C#. We will be building WPF forms which use data coming from the database and using Dapper, we will make the communication between our C# code and SQL Server seamless.

There is so much more so you will have to take the course and see it for yourself. The great thing is that I took the time to make this course interesting and flowing so you don’t have to suffer through it. You will enjoy it and even more so will want to watch it again.

If you are able to get through this course, understand it and feel comfortable with the concepts, then you are ready to enter the real world of software development. Of course there are always going to be challenges but you will be equipped with enough skill to be able to handle the complexities and find an optimal solution.

Who this course is for:

  • Target students for this course are already familiar with the basics of C# or other programming languages
  • Target students for this course are already familiar with the basics of SQL Server and T-SQL or any SQL

Our Promise to You

By the end of this course, you will have learned building applications using C# and SQL.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about programming in C#.

Course Curriculum

Section 1 - Welcome And Setup
What To Expect 00:00:00
Self-Troubleshooting 00:00:00
Download And Install Visual Studio 2019 Community 00:00:00
Download And Install SQL Server 2019 00:00:00
Download And Install SSMS 18 00:00:00
Section 2 - Customer Order Viewer
Customer Requirements 00:00:00
SQL Server Database Objects 00:00:00
Create Application Database And Tables 00:00:00
Give Values To Our Tables 00:00:00
Quick Side Note 00:00:00
SQL Views 00:00:00
Create Application View 00:00:00
Explore Server Explorer 00:00:00
What Is SQL Connection? 00:00:00
What Is SQL Command? 00:00:00
What Is SQL DataReader? 00:00:00
Create Application Models 00:00:00
Create Application Commands 00:00:00
Put All Together And Test 00:00:00
Section 3 - Customer Order Viewer 2.0
Customer Requirements 00:00:00
SQL Alter 00:00:00
Alter Our Table 00:00:00
SQL UDDT And SPROCs 00:00:00
Create Application UDDT And SPROCs 00:00:00
Create More SPROCs 00:00:00
What Is Dapper? 00:00:00
Create Application Models 00:00:00
Create Application Commands 00:00:00
Put All Together And Test 00:00:00
Section 4 - Course Report Emailer
Customer Requirements 00:00:00
Create Application Database And Tables 00:00:00
Give Values To Our Tables 00:00:00
Create Application View 00:00:00
Create Application SPROC 00:00:00
Create Application Models 00:00:00
Create Application Commands 00:00:00
What Is JSON? 00:00:00
What Is DataTable? 00:00:00
What Is Open XML SDK? 00:00:00
Create WorkSheet Creator – Part 1 00:00:00
Create WorkSheet Creator – Part 2 00:00:00
Create Emailer 00:00:00
Put All Together And Test 00:00:00
Section 5 - Course Manager
Customer Requirements 00:00:00
Alter Needed Table 00:00:00
Create Application SPROCs 00:00:00
What Is WPF And XAML? 00:00:00
What Is MVVM? 00:00:00
Cleanup And Create Startup 00:00:00
Create Application Models 00:00:00
Create Application Commands 00:00:00
Use Mockup To Create View 00:00:00
Enhance Our ViewModel – Part 1 00:00:00
Enhance Our ViewModel – Part 2 00:00:00
Put All Together And Test 00:00:00
Section 6 - Application Code
Download Application Code Here 00:00:00
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel