Overview

Class Central Tips

This course is designed to immerse you in the world of C# and SQL, guiding you step by step through the process of creating robust applications. You will start by setting up your development environment with tools like Visual Studio 2022 and SQL Server 2019. From there, you'll delve into the core concepts of SQL Server database objects, mastering the creation of tables, views, and stored procedures while learning to manage data effectively. As you progress, you'll apply your knowledge by developing a Customer Order Viewer application. This involves hands-on experience with SQL commands, application modeling, and understanding the intricacies of database connections using SqlConnection, SqlCommand, and SqlDataReader. The course also introduces you to advanced features like Dapper, JSON handling, and the Open XML SDK, enhancing your application’s functionality and user experience. By the end of the course, you'll have built multiple applications, each progressively more complex, solidifying your understanding of C# and SQL. You'll gain the confidence to create, test, and deploy professional-grade applications, making this course an invaluable resource for anyone aspiring to excel in software development and database management. This course is ideal for aspiring software developers, database administrators, and IT professionals looking to deepen their understanding of C# and SQL. A basic familiarity with programming concepts is recommended but not required.

Syllabus

Welcome

In this module, we will introduce you to the course, outlining its objectives and providing an overview of what you can expect to learn. This foundational introduction will set the stage for your journey through the material.

Setup

In this module, we will guide you through the essential setup process, including downloading and installing the necessary software tools. By the end of this section, you'll have your development environment ready and be informed about recent updates relevant to the course.

Customer Order Viewer

In this module, we will dive into the development of a Customer Order Viewer application. You'll start by understanding customer requirements and progress through creating and managing database objects, building the application's data access components, and finally integrating and testing the complete solution. This hands-on module is designed to solidify your skills in working with SQL Server and C#.

Customer Order Viewer 2.0

In this module, we will expand the Customer Order Viewer to version 2.0, focusing on advanced database modifications, including altering tables and implementing UDDTs and SPROCs. You'll also learn to use Dapper for efficient data access and integrate these enhancements into the application before thoroughly testing the final product.

Course Report Emailer

In this module, we will build a Course Report Emailer application from the ground up. You'll begin by creating the foundational database and progress to implementing advanced features such as JSON handling, document generation with Open XML SDK, and automated email distribution. The module culminates in the integration and testing of all components to ensure a fully functional application.

Course Manager

In this module, we will develop the Course Manager application, focusing on advanced UI design with WPF and XAML, and the MVVM pattern. You'll learn to alter necessary database tables, create SPROCs, and build and enhance ViewModels and Views, culminating in a comprehensive application that meets customer specifications. The module concludes with the integration and thorough testing of all components.