Master C# and SQL by Building Applications

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.

All the code and supporting files for this course are available on GitHub at: https://github.com/PacktPublishing/Master-C-Sharp-And-SQL-By-Building-A…

Type
video
Category
Web Development
publication date
2020-10-19
what you will learn

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

duration
364
key features
Delve into the advanced concepts of SQL and C# * Identify the best situation to use SQL views, SQL stored procedures, and SQL user-defined data type * Enable smooth communication between C# code and SQL server
approach
This course takes you through the essential concepts with the help of practical, engaging examples and activities that will teach you how to mix C# and SQL skills and create robust real-world applications.
audience
If you are a software developer who is looking to use C# and SQL together to build powerful applications, then this video course is for you. To get started with this course, it is recommended to have a basic understanding of C# and SQL server.
meta description
Take your software development skills to the next level by leveraging the collective power of C# and SQL together to build real-world applications
short description
This video course will help you build applications using the power of C# and SQL. You will not only learn to write flawless console applications in C# but also learn how to build SQL tables and views, work with stored procedures and SQL user-defined data types, and a lot more. You will also become comfortable in handling communication between the C# code and SQL database.
subtitle
Become a better software developer by learning how to build real world applications using C# and SQL
keywords
C#, SQL, SQL Server, WPF, XAML, SmtpClient
Product ISBN
9781800560093