Master C# and SQL by Building Applications

Master C# and SQL by Building Applications

by Avetis Ghukasyan
Released October 2022
Publisher(s): Packt Publishing
ISBN: 9781800560093

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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.

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

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.

About The Author

Avetis Ghukasyan: Avetis Ghukasyan is a passionate web developer who believes that with hard work, dedication and consistency, anybody can learn and develop strong technical skills—even if that individual has no prior knowledge of it and feels like a complete beginner. He also believes that understanding concepts is much more important than memorizing them.

Table of contents

  1. Chapter 1 : Welcome
    1. Introduction to the Course
  2. Chapter 2 : Setup
    1. Downloading and Installing the Visual Studio 2022 Community
    2. Downloading and Installing the SQL Server 2019
    3. Downloading and Installing SSMS 18
    4. Few Words about the Recent Updates
  3. Chapter 3 : Customer Order Viewer
    1. Customer Requirements
    2. SQL Server Database Objects
    3. Creating an Application Database and Tables
    4. Giving Values to Tables
    5. Quick Side Note
    6. SQL Views
    7. Creating an Application View
    8. Exploring the Server Explorer
    9. What Is SqlConnection?
    10. What Is SqlCommand?
    11. What Is SqlDataReader?
    12. Creating the Application Models
    13. Creating the Application Commands
    14. Putting Everything Together and Testing
  4. Chapter 4 : Customer Order Viewer 2.0
    1. Customer Requirements
    2. SQL Alter
    3. Altering a Table
    4. SQL UDDT and SPROCs
    5. Creating the Application UDDT and SPROCs
    6. Creating More SPROCs
    7. What Is Dapper?
    8. Creating the Application Models
    9. Creating the Application Commands
    10. Putting Everything Together and Testing
  5. Chapter 5 : Course Report Emailer
    1. Customer Requirements
    2. Creating an Application Database and Tables
    3. Giving Values to Tables
    4. Creating an Application View
    5. Creating the Application SPROC
    6. Creating the Application Models
    7. Creating the Application Commands
    8. What Is JSON?
    9. What Is DataTable?
    10. What Is Open XML SDK?
    11. Creating the Worksheet Creator - Part I
    12. Creating the Worksheet Creator - Part II
    13. Creating the Emailer
    14. Putting Everything Together and Testing
  6. Chapter 6 : Course Manager
    1. Customer Requirements
    2. Altering the Needed Table
    3. Creating the Application SPROCs
    4. What Is WPF and XAML?
    5. What Is MVVM?
    6. Cleanup and Creating the Start-up
    7. Creating the Application Models
    8. Creating the Application Commands
    9. Using Mockup to Create View
    10. Enhancing the ViewModel - Part I
    11. Enhancing the ViewModel - Part II
    12. Putting Everything Together and Testing

Product information

  • Title: Master C# and SQL by Building Applications
  • Author(s): Avetis Ghukasyan
  • Release date: October 2022
  • Publisher(s): Packt Publishing
  • ISBN: 9781800560093