Mô tả

Up to date and compatible with the latest .NET Core 8 (.NET 8)

All resources are available to all operating systems - follow along from Windows, Linux or MacOS. - (Includes special install instructions for MS SQL Server for Linux and Mac**)


"The course was a great match! Dominic is a very good teacher who explains this subject in a fun and engaging manner." - Risto

"As a seasoned programmer looking to refresh my knowledge in C#, this walkthrough was very clear and concise. I could have been a complete beginner and still understood." - Max

"The knowledge gained from this course is very valuable. The pacing is great and the explanations are very clear. I think the most important thing about this course is the instructor - he has such good energy, keeping you engaged." - Chris


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.


  1. C# Basics (and general programming basics)

  2. .NET Core 8 API Development

  3. 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 Core.


If you already build REST APIs with .NET Core 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!



"Tried many courses, but I used to get bored/stuck or just had partial understanding. This is one of the best courses. Will recommend this course for anyone learning .NET API development. Using Visual Studio Code, instead of visual studio helped me understand some thing I took for granted and never learned in VS. Also love the fact that you had C# and SQL sections. It was useful for me."
- Abishek

"I have gone through about 10 courses on Udemy before this one and I found Dominics course on C# .NET Core to be the best I have gone through yet. It is extensive with many exercises. Dominic while never really holding your hand follows you through the course and explain his design choices and methods so you can understand what you are doing. You will learn a lot from C# fundamentals, MVC design schemes, MS SQL servers, SQL Query Language, Azure. Take your time. It will be well worth it. I recommend this course highly."
- Peter

"This is a very in depth course which presented me with many challenges. I have about 1/3rd left to go at this point and usually I like to wait until I've completed things before leaving a review. That said, I decided to just do it now. Dominic's support in answering questions and offering solutions to problems throughout the entirety of this course was amazing. I can't tell you how many courses I've bought to find out there is a dead community, no one to go to with problems, and outdated lectures or assignments that haven't been kept up with. There is none of that here and I greatly appreciate it!"
- Emily

"My Udemy library is a lot like my Steam library. I've got a lot of courses in there but not many that I've completed. This is one of the few that I've actually finished, and genuinely enjoyed. I knew a little C# going in, and I've done a fair amount of work with SQL in terms of data analysis, but the application layer and dotnet was something of a mystery to me so I wanted to learn more about that. The pace is really good, the delivery is really good and I've really learned a lot. Definitely have the confidence to start expanding out of my comfort zone and experiment with some new projects."
- Lisa

"It's been an amazing journey so far, well thought off, clear, simple, and on point. I've been struggling to understand this whole backend concept for about a year now, on and off with different courses until I started your course. You made it so much easier. you are awesome Dominic Tripodi. I will definitely purchase more courses from you"
- Holliday

"I am Japanese. I took a lecture using the translation function. The video was very easy to understand. Even if there was something I didn't understand, when I asked a question, the instructor gave me an answer immediately. If you are lost in the .net lecture, I recommend it."

- 浩太郎 阿知波

Bạn sẽ học được gì

Understand core concepts of software development in C# that extend beyond any one language

Understand how to read and write code that runs powerful software tools and REST APIs with C# and .NET Core

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 C# .NET Core 7 Applications and Azure SQL Databases

Use .NET Core to build powerful Data Driven applications and APIs

Yêu cầu

  • Must have basic computer skills, and a desire to become a great developer
  • Must have a computer to follow the course on
  • May be easier with some Powershell or Bash shell experience, but we will cover the necessities

Nội dung khoá học

11 sections

Introduction

7 lectures
Introduction
02:06
Install List
00:29
.NET 8
00:14
Install
14:33
Mac/Linux Install MS SQL Server - Notes
00:38
Mac/Linux Install MS SQL Server
14:06
Hotkeys and Macros
00:31

C# Crash Course - Basics

26 lectures
Basics Theory Pt 1
06:06
Variables Notes
01:32
Console App Theory
04:10
Creating a Console App
05:17
Basic Theory Pt 2
04:16
Console.WriteLine
07:45
Nuget package source and C# extensions in VS Code
00:34
Nuget package source and C# Extensions
07:41
Console App Template
06:44
Console.WriteLine
1 question
Variables
22:20
Variables
1 question
Data Structures
28:28
Data Structures
1 question
Operators and Conditionals
24:25
Operators and Conditionals
1 question
Variables, Operators and Conditionals
6 questions
Basic Theory Pt 3
03:50
Conditional Statements
12:50
Conditional Statements
1 question
Loops
28:29
Loops
1 question
Methods
10:09
Methods
1 question
Scope
11:56
Conditional Statements, Loops and Methods
4 questions

C# Crash Course - Intermediate

23 lectures
Intermediate Theory
05:01
Models
15:58
String Property Defaults
00:39
Namespaces
04:43
Computer SQL Script
00:30
MacOS and Linux Users
00:25
Windows Connection Troubleshooting
01:06
Database Connections
18:31
Error converting data type varchar to numeric
00:56
Dapper Definitions and Planning
03:35
Dapper Pt 1
17:45
Dapper Pt 2
20:20
Entity Framework Definitions and Planning
08:39
Entity Framework
28:02
Config
18:09
Intermediate Theory Pt 2
02:45
File Read and Write
14:21
JSON Definitions and Planning
04:41
JSON
31:03
Model Mapping
28:30
Async Await Theory
04:08
Tasks
11:32
Async Methods
10:01

SQL Seed

3 lectures
Skipping Crash Course
00:19
MacOS and Linux Users
00:25
SQL Seed
03:17

Sql

5 lectures
SQL - Basics Pt1
26:39
SQL - Basics Pt2
20:37
SQL Basics
2 questions
SQL - Intermediate
01:00:48
SQL Intermediate
3 questions

API - Basics

23 lectures
API Basics Theory
02:21
Getting Started
16:17
Running the API
19:37
Startup.cs
15:20
First Custom Controller
15:24
.NET 8 launchSettings.json
00:51
API Setup
12:02
MacOS and Linux Users
00:25
InvariantGlobalization Bug
00:47
Database Connection
16:00
Http Launch
02:29
User Models
17:28
Users Controller
17:50
Put & Post
35:58
DTOs
04:17
Namespaces
04:09
User Delete
10:26
EF Setup
19:50
EF User Controller
19:17
AutoMapper
02:56
Beginner Assignment
02:08
Beginner Assignment Solution Dapper
12:57
Beginner Assignment Solution Entity Framework
07:12

API - Intermediate

16 lectures
API Intermediate Theory
02:20
UserRepository
12:37
IUserRepository
10:28
Repository Peripherals
14:54
Auth Table SQL
05:50
Auth Settings and Models
09:11
Password Managment
37:42
Login
14:09
Registration With Details
10:24
.NET 8 Note - IConfiguration.GetSection()
01:21
JWT Token Creation
23:29
JWT Token Validation
33:50
Helpers
06:53
Posts Model
13:58
Posts Controller
43:50
Posts Search
10:18

Stored Procedures

12 lectures
Stored Procedure Creation
11:25
Parameters
07:09
Nullable Parameters
04:54
Join and Outer Apply
11:18
Temp Table
16:15
User Upsert
16:53
User Upsert Peripherals
08:53
User Delete
02:25
Posts Get
11:38
Post Upsert
08:19
Post Delete
02:52
Auth
08:02

API - Advanced

17 lectures
API Advanced Theory
01:51
Stored Procedures Script
00:06
UserComplete Setup and Get
24:31
UserComplete Upsert
06:43
User Delete
03:16
Posts Get
11:13
My Posts
09:04
Post Upsert
14:04
Post Delete
05:23
Auth Register
21:23
Reset Password
09:31
Login
10:49
Cleanup
12:42
User Controller DynamicParameters
19:31
Advanced Assignment
01:06
Advanced Assignment Solution
04:58
Reusable SQL
15:16

Azure Deploy

6 lectures
Azure App Service
16:50
Azure Database Creation
21:53
Azure SQL Seed
06:16
Azure Database Connection
05:23
Azure Deploy with Database Connection
06:28
Delete Azure Resources
08:31

Congratulations!

1 lectures
Congratulations!
01:44

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.