TOIT Training

Master C# and SQL by Building Applications

Master C# and SQL by Building Applications
  • Overview
  • Curriculum
  • Reviews

Overview

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.

  • 5 Sections
  • 54 Lessons
  • 0 Quizzes
  • 0m Duration
Expand All

Setup

4 Lessons 0 Quizzes
  • 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

Customer Order Viewer

14 Lessons 0 Quizzes
  • 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

Customer Order Viewer 2.0

10 Lessons 0 Quizzes
  • 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

Course Report Emailer

14 Lessons 0 Quizzes
  • 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

Course Manager

12 Lessons 0 Quizzes
  • 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

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • 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

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

Master C# and SQL by Building Applications
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)