Master C# And SQL By Building Applications

现在是时候将您从 C# 和 SQL 中学到的所有知识整合到多个应用程序中了。本课程的唯一目的是挑战您在解决现实生活问题的同时将多种技术组合在一起。

本课程中编写的所有应用程序都可以在现实世界中使用一些增强功能。

我们不只是要编写简单的控制台应用程序。我们将从一个控制台应用程序开始，然后我们将在此基础上构建并使用 XAML 转到 WPF 表单。我们将了解 MVVM 最佳实践。

同时，每个应用程序都将是 SQL 和 C# 的组合。我们将构建 SQL 表、SQL 视图、SQL 存储过程、SQL 用户定义的数据类型等等。然后我们将使用 SQL 资源管理器从 Visual Studio 连接到 SQL Server。

我们将把 SQL 数据放在 Excel 工作表和工作簿上，并通过 C# 将它们作为附件通过电子邮件发送。我们将构建使用来自数据库的数据的 WPF 表单，并使用 Dapper 使我们的 C# 代码和 SQL Server 之间的通信无缝。

还有更多内容，因此您必须参加课程并亲自查看。

现在是您掌握 C# 和 SQL 的时候了，将它们放在一起并推动自己构建现实生活中的应用程序。通过这种方式，您将成为一名经验丰富的软件开发人员，并能够每年制作 100k 到 120k。这是成为全栈工程师的途径。没有捷径或魔法药水可以让你变得更好。您只需要参加课程，投入时间并学习所有信息。

最棒的是我花时间让这门课程变得有趣和流畅，这样你就不必忍受它了。你会喜欢它，甚至更想重新匹配它。

确保您已经参加了先决条件部分中提到的课程。这样，您就可以准备好深入学习课程并跟上步伐。

如果您能够完成本课程，理解它并对概念感到满意，那么您就已准备好进入软件开发的真实世界。当然，挑战总是存在，但您将具备足够的技能来处理复杂性并找到最佳解决方案。

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 57 lectures (6 hour, 5 mins) | Size: 2.02 GB
Become a high-earning software developer by learning how to build real world applications using C# and SQL.

What you’ll learn

Students will learn how to use SQL and C# together to build a full stack application
Students will learn how to use Dapper in .NET to make SQL database access even easier
Students will learn how to build forms using WPF and XAML
Students will learn how to use MVVM in order to create forms that are intuitive and easily manageable
Students will learn how to create and manipulate Excel worksheets and workbooks via Open XML and C#
Students will learn how to send emails programmatically using SmtpClient in C#
Students will learn how about the SQL Merge statement
Students will learn how and when to use SQL views, SQL stored procedures and SQL user defined data type

Requirements

Learn C# By Building Applications

Description

It is now time for you to put all that you have learned from C# and SQL together in multiple applications. The sole purpose of this course is to challenge you to put multiple technologies together while solving real life problems.

All of the applications written in this course could be used in the real world with a bit of enhancement.

We are not just going to write simple console applications. We will start with a console application, but then we will build up on top of that and move on to WPF forms using XAML. We will learn about MVVM best practices.

At the same time each application is going to be a combination of SQL and C# together. We will be building SQL tables, SQL views, SQL stored procedures, SQL user defined data types and much more. Then we will be using SQL explorer to connect to SQL Server from Visual Studio.

We will be putting SQL data onto Excel worksheets and workbooks and emailing them over as an attachment all through C#. We will be building WPF forms which use data coming from the database and using Dapper we will make the communication between our C# code and SQL Server seamless.

There is so much more so you will have to take the course and see it for yourself.

It is time for you to master C# and SQL by putting them together and pushing yourself to build real life applications. This is the way in which you will become an experienced software developer and be able to make 100k to 120k per year. This is the way towards becoming a full stack engineer. There are no shortcuts or magic potions that will make you good. You will just have to take the course, dedicate your time and learn all of the information.

The great thing is that I took the time to make this course interesting and flowing so you don’t have to suffer through it. You will enjoy it and even more so will want to rematch it again.

Make sure that you have already taken the courses mentioned in the prerequisites section. This way you will be ready to dive into the course and be able to keep up with the pace.

If you are able to get through this course, understand it and feel comfortable with the concepts then you are ready to enter the real world of software development. Of course there are always going to be challenges but you will be equipped with enough skill to be able to handle the complexities and find an optimal solution.

I will see you on the other side!

Who this course is for:

Target students for this course are already familiar with the basics of C# or other programming languages
Target students for this course are already familiar with the basics of SQL Server and T-SQL or any SQL