Master C# And SQL By Building Applications

Course

Online

£ 10 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

It is time for you to master C# and SQL by putting them together and pushing yourself to build real life applications. 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 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.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

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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 to use the SQL Merge statement
Students will learn how and when to use SQL views, SQL stored procedures and SQL user defined data type

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • Visual Studio
  • Server
  • Database
  • SQL
  • Database training
  • Install
  • SQL Database
  • IT
  • IT Management
  • Information Systems

Course programme

Setup 4 lectures 10:26 Download & Install Visual Studio 2019 Community Download & Install SQL Server 2019 Download & Install SSMS 18 Self-Troubleshooting Setup 4 lectures 10:26 Download & Install Visual Studio 2019 Community Download & Install SQL Server 2019 Download & Install SSMS 18 Self-Troubleshooting Download & Install Visual Studio 2019 Community Download & Install Visual Studio 2019 Community Download & Install Visual Studio 2019 Community Download & Install Visual Studio 2019 Community Download & Install SQL Server 2019 Download & Install SQL Server 2019 Download & Install SQL Server 2019 Download & Install SQL Server 2019 Download & Install SSMS 18 Download & Install SSMS 18 Download & Install SSMS 18 Download & Install SSMS 18 Self-Troubleshooting Self-Troubleshooting Self-Troubleshooting Self-Troubleshooting Customer Order Viewer 14 lectures 01:25:43 Customer Order Viewer - Customer Requirements SQL Server Database Objects Create Application Database & Tables Get Values To Our Tables Quick Side Note SQL Views Create Application View Explore Server Explorer What Is SQL Connection What Is SQL Command What Is SQLDataReader Create Application Models Create Application Command Customer Order Viewer - Put All Together & Test Customer Order Viewer 14 lectures 01:25:43 Customer Order Viewer - Customer Requirements SQL Server Database Objects Create Application Database & Tables Get Values To Our Tables Quick Side Note SQL Views Create Application View Explore Server Explorer What Is SQL Connection What Is SQL Command What Is SQLDataReader Create Application Models Create Application Command Customer Order Viewer - Put All Together & Test Customer Order Viewer - Customer Requirements Customer Order Viewer - Customer Requirements Customer Order Viewer - Customer Requirements Customer Order Viewer - Customer Requirements SQL Server Database Objects SQL Server Database Objects SQL Server Database Objects SQL Server Database Objects Create Application Database & Tables Create Application Database & Tables Create Application Database & Tables Create Application Database & Tables Get Values To Our Tables Get Values To Our Tables Get Values To Our Tables Get Values To Our Tables Quick Side Note Quick Side Note Quick Side Note Quick Side Note SQL Views SQL Views SQL Views SQL Views Create Application View Create Application View Create Application View Create Application View Explore Server Explorer Explore Server Explorer Explore Server Explorer Explore Server Explorer What Is SQL Connection What Is SQL Connection What Is SQL Connection What Is SQL Connection What Is SQL Command What Is SQL Command What Is SQL Command What Is SQL Command What Is SQLDataReader What Is SQLDataReader What Is SQLDataReader What Is SQLDataReader Create Application Models Create Application Models Create Application Models Create Application Models Create Application Command Create Application Command Create Application Command Create Application Command Customer Order Viewer - Put All Together & Test Customer Order Viewer - Put All Together & Test Customer Order Viewer - Put All Together & Test Customer Order Viewer - Put All Together & Test Customer Order Viewer 2.0 10 lectures 01:17:23 Customer Order Viewer 2.0 - Customer Requirements SQL Alter Alter Our Table SQL UDDT and SPROCs Create UDDT and SPROCs Create More SPROCs What Is Dapper Creating Application Models Creating Application Commands Customer Order Viewer 2.0 - Put All Together & Test Customer Order Viewer 2.0. 10 lectures 01:17:23 Customer Order Viewer 2.0 - Customer Requirements SQL Alter Alter Our Table SQL UDDT and SPROCs Create UDDT and SPROCs Create More SPROCs What Is Dapper Creating Application Models Creating Application Commands Customer Order Viewer 2.0 - Put All Together & Test Customer Order Viewer 2.0 - Customer Requirements Customer Order Viewer 2.0 - Customer Requirements Customer Order Viewer 2.0 - Customer Requirements Customer Order Viewer 2 ong Create Application SPROCs What Is WPF and XAML What Is MVVM Cleanup And Create Startup Create Course Manager Application Models Create Course Manager Application Commands Use Mockup To Create View Enhance Our ViewModel - Part 1 Enhance Our ViewModel - Part 2 Course Manager - Put All Together & Test Course Manager 12 lectures 01:45:28 Course Manager - Customer Requirements Alter Needed Table Create Application SPROCs What Is WPF and XAML What Is MVVM Cleanup And Create Startup Create Course Manager Application Models Create Course Manager Application...

Additional information

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

Master C# And SQL By Building Applications

£ 10 VAT inc.