C# is the backbone of many popular video games, web, mobile, and desktop applications. And without SQL, the creation and management of the database will be handicapped. Imagine what can be achieved in the world of technology if both C# and SQL are merged! This video course will teach you how to bring C# and SQL together to build robust, powerful, real-world applications. The course begins with an overview of the course objectives and explains the process of installing Visual Studio 2019, SQL Server 2019, and SSMS 18. Next, you will create a customer order viewer application in C# to understand the SQL commands, tables, database, and server in detail. Moving ahead, you will use SQL Alter, user-defined data types, stored procedures, and Dapper, to enhance the application that you created. You will also test the application to ensure that it is working smoothly as per the requirement. Toward the end, you will create a course report emailer application in C# to email worksheets with SQL data and build WPF forms and use Dapper to make the communication between C# code and SQL server seamless. By the end of this course, you will have developed essential C# and SQL skills needed to build real world applications.
Overview
COURSE DIFFICULTY
Skills Learned
After completing this online training course, students will be able to:
Build a full-stack application with C# and SQL
Use Dapper in .NET to make SQL database access even easier
Create forms using WPF and XAML
Create and manipulate Excel workbooks through Open XML and C#
Send emails programmatically using SmtpClient in C#
Find out how to use the SQL Merge statement
01. Setup
- Downloading and Installing the Visual Studio 2022 Community
- Downloading and Installing the SQL Server 2019
- Downloading and Installing SSMS 18
- Few Words about the Recent Updates
02. Customer Order Viewer
- Customer Requirements
- SQL Server Database Objects
- Creating an Application Database and Tables
- Giving Values to Tables
- Quick Side Note
- SQL Views
- Creating an Application View
- Exploring the Server Explorer
- What Is SqlConnection?
- What Is SqlCommand?
- What Is SqlDataReader?
- Creating the Application Models
- Creating the Application Commands
- Putting Everything Together and Testing
03. Customer Order Viewer 2.0
- Customer Requirements
- SQL Alter
- Altering a Table
- SQL UDDT and SPROCs
- Creating the Application UDDT and SPROCs
- Creating More SPROCs
- What Is Dapper?
- Creating the Application Models
- Creating the Application Commands
- Putting Everything Together and Testing
04. Course Report Emailer
- Customer Requirements
- Creating an Application Database and Tables
- Giving Values to Tables
- Creating an Application View
- Creating the Application SPROC
- Creating the Application Models
- Creating the Application Commands
- What Is JSON?
- What Is DataTable?
- What Is Open XML SDK?
- Creating the Worksheet Creator – Part I
- Creating the Worksheet Creator – Part II
- Creating the Emailer
- Putting Everything Together and Testing
05. Course Manager
- Customer Requirements
- Altering the Needed Table
- Creating the Application SPROCs
- What Is WPF and XAML?
- What Is MVVM?
- Cleanup and Creating the Start-up
- Creating the Application Models
- Creating the Application Commands
- Using Mockup to Create View
- Enhancing the ViewModel – Part I
- Enhancing the ViewModel – Part II
- Putting Everything Together and Testing
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build a full-stack application with C# and SQL
Use Dapper in .NET to make SQL database access even easier
Create forms using WPF and XAML
Create and manipulate Excel workbooks through Open XML and C#
Send emails programmatically using SmtpClient in C#
Find out how to use the SQL Merge statement
COURSE OUTLINE
01. Setup
- Downloading and Installing the Visual Studio 2022 Community
- Downloading and Installing the SQL Server 2019
- Downloading and Installing SSMS 18
- Few Words about the Recent Updates
02. Customer Order Viewer
- Customer Requirements
- SQL Server Database Objects
- Creating an Application Database and Tables
- Giving Values to Tables
- Quick Side Note
- SQL Views
- Creating an Application View
- Exploring the Server Explorer
- What Is SqlConnection?
- What Is SqlCommand?
- What Is SqlDataReader?
- Creating the Application Models
- Creating the Application Commands
- Putting Everything Together and Testing
03. Customer Order Viewer 2.0
- Customer Requirements
- SQL Alter
- Altering a Table
- SQL UDDT and SPROCs
- Creating the Application UDDT and SPROCs
- Creating More SPROCs
- What Is Dapper?
- Creating the Application Models
- Creating the Application Commands
- Putting Everything Together and Testing
04. Course Report Emailer
- Customer Requirements
- Creating an Application Database and Tables
- Giving Values to Tables
- Creating an Application View
- Creating the Application SPROC
- Creating the Application Models
- Creating the Application Commands
- What Is JSON?
- What Is DataTable?
- What Is Open XML SDK?
- Creating the Worksheet Creator – Part I
- Creating the Worksheet Creator – Part II
- Creating the Emailer
- Putting Everything Together and Testing
05. Course Manager
- Customer Requirements
- Altering the Needed Table
- Creating the Application SPROCs
- What Is WPF and XAML?
- What Is MVVM?
- Cleanup and Creating the Start-up
- Creating the Application Models
- Creating the Application Commands
- Using Mockup to Create View
- Enhancing the ViewModel – Part I
- Enhancing the ViewModel – Part II
- Putting Everything Together and Testing
