C# .NET Core 7 with MS SQL Complete Beginner to Master

Focused View

Dominic Tripodi

21:43:28

234 View

1. Introduction

1. Introduction.mp4

02:06

2. Install List.html

3. Install.mp4

14:33

4. Hotkeys and Macros.html

2. C# Crash Course - Basics

1. Basics Theory Pt 1.mp4

06:06

2. Console App Theory.mp4

04:10

3. Creating a Console App.mp4

05:17

4. Basic Theory Pt 2.mp4

04:16

5. Console.WriteLine.mp4

07:45

6. Console App Template.mp4

06:44

7. Variables.mp4

18:47

8. Data Structures.mp4

28:28

9. Operators and Conditionals.mp4

24:25

10. Variables, Operators and Conditionals.html

11. Basic Theory Pt 3.mp4

03:50

12. Conditional Statements.mp4

12:50

13. Loops.mp4

28:29

14. Methods.mp4

10:09

15. Scope.mp4

11:56

16. Conditional Statements, Loops and Methods.html

3. C# Crash Course - Intermediate

1. Intermediate Theory.mp4

03:53

2. Models.mp4

15:59

3. Namespaces.mp4

04:43

4. Database Connections.mp4

18:36

5. Dapper Pt 1.mp4

17:45

6. Dapper Pt 2.mp4

20:20

7. Entity Framework.mp4

28:02

8. Config.mp4

18:09

9. Intermediate Theory Pt 2.mp4

02:45

10. File Read and Write.mp4

14:21

11. JSON.mp4

30:12

12. Model Mapping.mp4

28:30

4. SQL Seed

1. SQL Seed.mp4

03:17

5. Sql

1. SQL - Basics.mp4

27:50

2. SQL Basics.html

3. SQL - Intermediate.mp4

01:00:48

4. SQL Intermediate.html

6. API - Basics

1. API Basics Theory.mp4

02:21

2. Getting Started.mp4

20:18

3. Startup.cs.mp4

15:20

4. First Custom Controller.mp4

10:48

5. API Setup.mp4

12:02

6. Database Connection.mp4

16:15

7. Http Launch.mp4

02:29

8. User Models.mp4

17:28

9. Users Controller.mp4

17:50

10. Put & Post.mp4

35:58

11. DTOs.mp4

04:17

12. Namespaces.mp4

04:09

13. User Delete.mp4

10:26

14. EF Setup.mp4

18:32

15. EF User Controller.mp4

19:17

16. AutoMapper.mp4

02:56

17. Beginner Assignment.mp4

02:08

18. Beginner Assignment Solution.mp4

19:20

7. API - Intermediate

1. API Intermediate Theory.mp4

02:20

2. UserRepository.mp4

12:37

3. IUserRepository.mp4

10:28

4. Repository Peripherals.mp4

14:54

5. Auth Table SQL.mp4

05:50

6. Auth Settings and Models.mp4

09:11

7. Password Managment.mp4

37:42

8. Login.mp4

14:09

9. Registration With Details.mp4

10:24

10. JWT Token Creation.mp4

23:29

11. JWT Token Validation.mp4

21:51

12. Helpers.mp4

06:53

13. Posts Model.mp4

13:58

14. Posts Controller.mp4

43:50

15. Posts Search.mp4

10:18

8. Stored Procedures

1. Stored Procedure Creation.mp4

11:25

2. Parameters.mp4

07:09

3. Nullable Parameters.mp4

04:54

4. Join and Outer Apply.mp4

11:18

5. Temp Table.mp4

16:15

6. User Upsert.mp4

16:53

7. User Upsert Peripherals.mp4

08:53

8. User Delete.mp4

02:25

9. Posts Get.mp4

11:38

10. Post Upsert.mp4

08:19

11. Post Delete.mp4

02:52

12. Auth.mp4

08:02

9. API - Advanced

1. API Advanced Theory.mp4

01:51

2. Stored Procedures Script.html

3. UserComplete Setup and Get.mp4

24:31

4. UserComplete Upsert.mp4

06:43

5. User Delete.mp4

03:16

6. Posts Get.mp4

11:13

7. My Posts.mp4

09:04

8. Post Upsert.mp4

14:04

9. Post Delete.mp4

05:23

10. Auth Register.mp4

21:23

11. Reset Password.mp4

09:41

12. Login.mp4

10:49

13. Cleanup.mp4

12:42

14. User Controller DynamicParameters.mp4

19:31

15. Advanced Assignment.mp4

01:06

16. Advanced Assignment Solution.mp4

04:58

17. Reusable SQL.mp4

15:16

10. Azure Deply

1. Azure App Service.mp4

16:50

2. Azure Database Creation.mp4

21:53

3. Azure SQL Seed.mp4

06:16

4. Azure Database Connection.mp4

05:23

5. Azure Deploy with Database Connection.mp4

06:28

6. Delete Azure Resources.mp4

08:31

11. Congratulations

1. Congratulations.mp4

01:44

Description

Learn API Development with C# .NET Core 7 and MS SQL Server from Mac, Linux or Windows!

What You'll Learn?

Understand core concepts of software development that extend beyond any one language and help you
Understand how to read and write code that runs powerful software tools and REST APIs with C# and .NET 7
Understand how to read and write SQL Queries with T SQL for MS SQL Server and Azure SQL
Learn how to use powerful cross-platform tools for writing code (VS Code), querying databases (Azure Data Studio), and testing REST APIS (Postman)
Provision Azure resources for production .NET Core 7 Applications and Azure SQL Databases

Who is this for?

People who want to start learning how to program

New Programmers who want to learn about API Development

Frontend developers looking to learn more about backend APIs and/or Databases

Backend/Full Stack developers who want to learn about .NET Core and/or C#

Backend/Full Stack developers who want to learn about SQL

More details

Description
This course is up to date with the latest .NETÂ Core 7 (.NET 7), and has examples of how to handle older version of .NET Core in case you wind up working with projects build on older versions.
The whole course also only uses resources that are available to all operating systems so that you can follow along from Windows, Linux or MacOS.
(Linux and Mac Users recently updated to include special install instructions for MSÂ SQLÂ Server)

Learning Paths:
There are 3 different Modular pieces of this course that can be mixed and matched to fit your learning needs, depending on what you already know and what you want to learn.

C#Â Basics (and general programming basics)
.NET 7 API Developement
MSÂ SQLÂ Server and Azure SQL

If you are new to programming, or just new to C#, you can get an in depth understanding of basic programming concepts like variable types, data structures, classes and methods in our C#Â Basics section.

If you already know C# that's great, you can skip over that basics section and start learning how to build powerful RESTÂ APIs with .NET 7.

If you already build RESTÂ APIs with .NET 7 and just want to write cleaner code, learn how to decouple logic, or consolidate endpoints with more dynamic logic, IÂ highly recommend starting with the SQLÂ section, brushing up on Dapper in the Crash course section if you need to, and then checking out the advanced section of the course.

(If that sounds complicated and confusing, it won't at all by the time you are done with the course)

This course is also set up so that the SQLÂ section is entirely optional, although I do think it is very useful and IÂ highly recommend it. As much as IÂ think you would benefit from learning SQLÂ along with C#, IÂ do understand that building RESTÂ APIs and writing SQL are two different skills.

If you just want to focus on the APIÂ development side of the course, IÂ am happy to be your personal SQLÂ Developer on the side by providing a few scripts you can just drop into Azure Data Studio to get things set up for you in the database, so that you can go through the entire .NETÂ Core part of the course without missing a beat.

If you are new to software development, congratulations on starting your journey to become a developer! IÂ look forward to seeing you inside!**

Who this course is for:
People who want to start learning how to program
New Programmers who want to learn about API Development
Frontend developers looking to learn more about backend APIs and/or Databases
Backend/Full Stack developers who want to learn about .NET Core and/or C#
Backend/Full Stack developers who want to learn about SQL

User Reviews

Rating

average 0

Total votes0

Focused display

Computers have been very important and interesting to me for my entire life, and I've always loved learning about the way that computers can be used to build tools for business and entertainment.The most interesting thing to me has always been what goes on behind the scenes.I work a lot with data, databases, and I build tools to manage and display data. APIs and Databases are the most important building blocks in modern application development. I build tools for storage, movement, management and transformation of data These types of tools fuel most modern applications.Most modern companies need or have software that uses these types of tools and the skills needed to build these tools are in high demand.Why I teachAs a self-taught developer, I spent a lot of time learning and deciding what to learn about and I wanted to create content and resources to simplify and streamline the process for new developers.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.