Master C# and SQL by Building Applications / Ghukasyan, Avetis
- Ghukasyan, Avetis
- Packt Publishing, 2020.
- 1st edition.
- Physical Description:
- 1 online resource (1 video file, approximately 6 hr., 2 min.)
- Take your software development skills to the next level by leveraging the collective power of C# and SQL to build real-world applications About This Video Delve into the advanced concepts of SQL and C# Identify the optimal situation when SQL views, SQL stored procedures, and SQL user-defined data types can be used Enable smooth communication between C# code and SQL Server In Detail C# forms the backbone of many popular video games and web, mobile, and desktop applications, while SQL is essential for database creation and management. So much 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 real-world applications. The course begins with an overview of the course objectives, explaining the process of installing Visual Studio 2019, SQL Server 2019, and SSMS 18. Next, you'll create a customer order viewer application in C# to understand SQL commands, tables, the database, and the server in detail. Moving on, you'll use SQL Alter, user-defined data types, stored procedures, and Dapper to enhance the application you've created. This course also lets you test the application to ensure it is working smoothly as per the requirement. Toward the end, you'll create a course report emailer application in C# to email worksheets with SQL data and build Windows Presentation Foundation (WPF) forms, and use Dapper to make communication between C# code and SQL Server seamless. By the end of this course, you'll have developed the essential C# and SQL skills needed to build real-world applications.
View MARC record | catkey: 37457229