We may earn an affiliate commission when you visit our partners.
Take this course
Dominic Tripodi

Up to date and compatible with the latest versions of C# and .NET 

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

Read more

Up to date and compatible with the latest versions of C# and .NET 

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 9 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."

- 浩太郎 阿知波

"I enrolled in this course as part of a professional transition from traditional WinForms application development to modern web applications, as required by my workplace. I found the course immensely helpful. Dominic's thorough and clear explanations exceeded my expectations, providing deep insights into each topic. I anticipate returning to these videos frequently to continue my learning. Thank you, Dominic, for such a valuable resource. " - Rabin

Enroll now

What's inside

Learning objectives

  • 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

Syllabus

Start The Course
Introduction
Install List
.NET 9
Read more

Solidify your understanding of Data Structures

Describe Conditional Statements, Loops and Methods

Describe Basic SQL concepts

Easier method of defining model defaults

Describe intermediate SQL concepts

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Uses Visual Studio Code, which helps learners understand concepts they may have taken for granted using Visual Studio, and strengthens their understanding of the fundamentals
Covers C# basics, .NET Core API development, and MS SQL Server, providing a comprehensive foundation for full-stack development and allowing learners to specialize in their preferred area
Includes instructions for installing MS SQL Server on Linux and Mac, making it accessible to learners regardless of their operating system and broadening its appeal
Allows experienced C# developers to skip the basics section and focus on building REST APIs with .NET Core, saving them time and catering to their existing knowledge
Teaches Dapper and Entity Framework, which are valuable skills for interacting with databases and building data-driven applications, and are widely used in the industry
Focuses on .NET Core 9 API development, which may require learners to ensure they have the correct version installed and configured for optimal compatibility and learning

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

C# .net & sql: beginner to master

According to learners, this course on C# .NET and MS SQL is highly recommended, praised for the instructor's engaging style and excellent support. Students found explanations very clear and concise, making topics easy to understand. The content is comprehensive and up-to-date, covering C#, .NET API, and SQL. The modular design works for beginners to experienced developers. Practical exercises build confidence for real-world application, even aiding career transitions. Many feel it is well worth the time.
Works across Windows, Linux, and MacOS with special instructions.
"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)"
Course content is current and well-maintained.
"Up to date and compatible with the latest versions of C# and .NET"
"...outdated lectures or assignments that haven't been kept up with. There is none of that here and I greatly appreciate it."
Helps learners gain confidence for real-world projects.
"Definitely have the confidence to start expanding out of my comfort zone and experiment with some new projects."
"You made it so much easier."
"I learned how to use practical tools and strategies that I could apply immediately to my work."
"I anticipate returning to these videos frequently to continue my learning."
Suitable for beginners to experienced developers.
"I could have been a complete beginner and still understood."
"As a seasoned programmer looking to refresh my knowledge in C#, this walkthrough was very clear and concise."
"Tried many courses... This is one of the best courses. Will recommend this course for anyone learning .NET API development."
"If you are new to programming, or just new to C#, you can get an in depth understanding..."
"...can be mixed and matched to fit your learning needs, depending on what you already know and what you want to learn."
Wide-ranging content covering C#, .NET API, SQL, and tools.
"You will learn a lot from C# fundamentals, MVC design schemes, MS SQL servers, SQL Query Language, Azure."
"Also love the fact that you had C# and SQL sections. It was useful for me."
"This is a very in depth course..."
"It is extensive with many exercises."
"understand basic programming concepts... build powerful REST APIs... query databases... test REST APIS..."
Course material is presented with great clarity and pacing.
"As a seasoned programmer looking to refresh my knowledge in C#, this walkthrough was very clear and concise."
"The pacing is great and the explanations are very clear."
"It's been an amazing journey so far, well thought off, clear, simple, and on point."
"Dominic's thorough and clear explanations exceeded my expectations..."
"I have gone through about 10 courses on Udemy before this one and I found Dominics course... to be the best I have gone through yet."
Instructor provides exceptional guidance and support.
"Dominic is a very good teacher who explains this subject in a fun and engaging manner."
"the most important thing about this course is the instructor - he has such good energy, keeping you engaged."
"Dominic's support in answering questions and offering solutions to problems throughout the entirety of this course was amazing."
"Even if there was something I didn't understand, when I asked a question, the instructor gave me an answer immediately."
"Dominic's thorough and clear explanations exceeded my expectations, providing deep insights into each topic."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in C# .NET with MS SQL Complete Beginner to Master 2025 with these activities:
Review C# Basics
Reviewing C# basics will ensure a solid foundation for understanding the more advanced concepts covered in the course.
Show steps
  • Review basic syntax and data types.
  • Practice writing simple console applications.
  • Review object-oriented programming principles.
Read 'C# 9.0 in a Nutshell'
Referencing a comprehensive C# book will provide a deeper understanding of the language and its capabilities.
Show steps
  • Read the chapters relevant to the current course modules.
  • Use the book as a reference for specific C# features.
Practice SQL Queries
Practicing SQL queries will reinforce your understanding of database interactions and data manipulation.
Show steps
  • Set up a local MS SQL Server instance.
  • Create sample databases and tables.
  • Write and execute various SQL queries (SELECT, INSERT, UPDATE, DELETE).
Four other activities
Expand to see all activities and additional details
Show all seven activities
Write a Blog Post on .NET Core
Writing a blog post will help you consolidate your knowledge and share it with others.
Show steps
  • Choose a specific topic related to .NET Core API development.
  • Research the topic and gather relevant information.
  • Write a clear and concise blog post explaining the topic.
  • Publish the blog post on a personal blog or platform like Medium.
Build a Simple REST API
Building a REST API will solidify your understanding of .NET Core API development and database interactions.
Show steps
  • Design the API endpoints and data models.
  • Implement the API using .NET Core and Dapper/Entity Framework.
  • Test the API endpoints using Postman.
  • Deploy the API to a local server.
Read 'Pro C# 7'
Reading a comprehensive C# book will provide a deeper understanding of the language and its capabilities.
View Pro C# 7 on Amazon
Show steps
  • Read the chapters relevant to the current course modules.
  • Use the book as a reference for specific C# features.
Contribute to a .NET Open Source Project
Contributing to open source will provide valuable real-world experience and improve your coding skills.
Show steps
  • Find a .NET open source project on GitHub.
  • Identify a bug or feature to work on.
  • Submit a pull request with your changes.
  • Respond to feedback and iterate on your code.

Career center

Learners who complete C# .NET with MS SQL Complete Beginner to Master 2025 will develop knowledge and skills that may be useful to these careers:
API Developer
API developers specialize in creating and maintaining application programming interfaces, which allow different software systems to communicate. The C# .NET with MS SQL Complete Beginner to Master 2025 course focuses significantly on building REST APIs with .NET Core, so one who works as an API developer may find this course useful. API developers often work with databases, so the MS SQL Server and Azure SQL sections may be useful. You may find the lessons on using Postman, a tool for testing REST APIs, to be valuable.
Software Developer
As a software developer, you'll design, develop, and test software applications. Knowledge of C# and .NET is highly sought after in the industry, and this course helps build a foundation in these technologies. Specifically, the C# .NET with MS SQL Complete Beginner to Master 2025 course emphasizes building REST APIs with .NET Core. The course may be useful for learning how to interact with databases, model data, and parse JSON in C#, which are all skills needed by a software developer. The course may be useful for learning how to use powerful cross-platform tools, such as VS Code, Azure Data Studio, and Postman.
Back-End Developer
A back end developer focuses on the server-side logic and databases that power web applications. The C# .NET with MS SQL Complete Beginner to Master 2025 course provides detailed coverage of building REST APIs with .NET Core, a crucial skill for back-end development. Much of the logic of a back end developer involves interacting with databases, and the MS SQL Server and Azure SQL sections of the course may be useful. This course builds a foundation in C# as well as SQL.
Software Engineer
Software engineers apply engineering principles to software development. The C# .NET with MS SQL Complete Beginner to Master 2025 course helps build skills in software development using C# and .NET. In particular, the course goes into detail about building REST APIs with .NET Core. Software engineers are often involved in database interactions, and the course may be useful for writing SQL queries with T-SQL. Software engineers may find this course useful to build a foundation in coding.
Full-Stack Developer
Full stack developers work on both the front-end and back-end of web applications. Knowledge of both C# and SQL can be useful, as the C# .NET with MS SQL Complete Beginner to Master 2025 course covers both technologies. This course stresses building REST APIs with .NET Core. The course may be useful for learning how to interact with databases, model data, and parse JSON in C#, all of which are skills needed by a full stack developer. This course can lead to a strong foundation in the basics of software development.
Web Developer
Web developers specialize in building websites and web applications. The C# .NET with MS SQL Complete Beginner to Master 2025 course stresses building REST APIs with .NET Core, which is a key skill for back-end web development. The course helps build a foundation in core concepts of C#, that extend beyond one language. A web developer must know how to interact with databases, model data, and parse JSON. This is an area that the course will help with. This course may be useful to a web developer as it offers different modular pieces that can be mixed and matched to fit learning needs.
Database Administrator
Database administrators are responsible for the performance, integrity, and security of databases. The C# .NET with MS SQL Complete Beginner to Master 2025 course has a modular piece on MS SQL Server and Azure SQL. With this training, you can build a foundation in reading and writing SQL queries with T-SQL. This course may be useful for learning how to interact with databases, a necessary skill for a database administrator. You may find particular value in the intermediate SQL section, as well as the section on writing architectural statements in SQL.
Data Engineer
Data engineers build and maintain the infrastructure for data storage and processing. The C# .NET with MS SQL Complete Beginner to Master 2025 course covers SQL, which is used for database management. Data engineers must know how to read and write SQL queries. This course may be useful for building practical skills in database technologies. You may find the MS SQL Server and Azure SQL to be particularly useful in this role. This course helps gain a deep understanding of basic programming concepts.
Business Intelligence Developer
Business intelligence developers design and develop systems for analyzing business data. The C# .NET with MS SQL Complete Beginner to Master 2025 course covers building and querying databases using MS SQL Server and Azure SQL. A business intelligence developer may find this course useful for learning how to read and write SQL queries with T-SQL. You may find the advanced SQL section to be particularly useful. This course helps gain a deep understanding of basic programming concepts.
Data Analyst
Data analysts interpret data to identify trends and insights. The C# .NET with MS SQL Complete Beginner to Master 2025 course includes a section on SQL. This course helps build a foundation in reading and writing SQL queries. Additionally, knowledge of C# can be useful for building custom data analysis tools. Data analysts may find this course useful for understanding the intersection of programming and data, and will have a better foundation to prepare for the role. You can learn how to interact with databases, model data, and parse JSON in C#.
ETL Developer
ETL stands for extract, transform, and load, and ETL developers create processes for moving data between systems. The C# .NET with MS SQL Complete Beginner to Master 2025 course may be useful for working with the data loading process because it covers SQL. An ETL developer may find this course useful for learning how to read and write SQL queries with T-SQL. You may find the advanced SQL section to be particularly useful. This course helps gain a deep understanding of basic programming concepts.
DevOps Engineer
DevOps engineers automate and streamline the software development lifecycle. The C# .NET with MS SQL Complete Beginner to Master 2025 course goes over provisioning Azure resources for C# .NET Core applications and Azure SQL databases. You may find this course useful for gaining skills in deploying and managing applications in the cloud. These skills may be useful for a DevOps engineer. This course helps gain a deep understanding of basic programming concepts.
IT Manager
IT managers oversee an organization's information technology infrastructure. They may benefit from the C# .NET with MS SQL Complete Beginner to Master 2025 course, as it covers technologies such as .NET Core and MS SQL Server that are commonly used in enterprise environments. The course may be especially relevant if the IT manager oversees teams that develop software using these technologies, as it will allow them to better understand the challenges and opportunities involved. The course will ensure that an IT manager has a better foundation to lead effectively.
Technical Project Manager
A technical project manager leads software development projects. A foundation in the technologies used in such projects can be useful when communicating with team members and stakeholders. The C# .NET with MS SQL Complete Beginner to Master 2025 course covers core concepts and may be useful for building a foundation in C# and .NET development. Knowledge of MS SQL can also be an advantage. The course helps gain a deep understanding of basic programming concepts, and an understanding of software development in general.
Technical Sales Engineer
Technical sales engineers apply technical knowledge to the sales process. The C# .NET with MS SQL Complete Beginner to Master 2025 course may be useful for learning about the capabilities of .NET and SQL Server. A technical sales engineer may find that the course provides valuable background for discussing these technologies with clients. You may find the modular pieces of this course to be useful based on what you already know and what you want to learn. The course helps gain a deep understanding of basic programming concepts.

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in C# .NET with MS SQL Complete Beginner to Master 2025.
Provides a comprehensive reference to the C# language and .NET platform. It's a valuable resource for understanding the intricacies of C# syntax, features, and best practices. It serves as both a learning tool and a reference guide for experienced developers. This book adds depth to the course by providing detailed explanations and examples that complement the course material.
Comprehensive guide to C# 7 and .NET Core. It covers a wide range of topics, from basic syntax to advanced concepts like asynchronous programming and LINQ. While slightly older, it provides a solid foundation for understanding the evolution of C# and .NET. This book is more valuable as additional reading to broaden your understanding of the C# ecosystem.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Similar courses are unavailable at this time. Please try again later.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser