Ưu đãi trong tuần: Nhập mã UD50 giảm 50k cho đơn từ 300k!
Trang chủ
Menu

C# Restful API and WPF Core with MsSQL & EF Core

C# Restful API và WPF Core với MsSQL & EF Core

C# Restful API và WPF Core với MsSQL & EF Core

C# Restful API trên Web API .Net Core, HTTP, MsSQL, WPF Core cùng các dự án Rest API thực tế, dự án WPF Core, EF Core

4.5
(170 đánh giá)
1,661 học viên
Giảng viên
Oak Academy
Phụ đề Việt chất lượng cao Phụ đề tiếng Anh Bán chạy Đánh giá cao
50.000đ 349.000đ -86%
✓ Xem giỏ hàng và thanh toán
Bao gồm phụ đề tiếng Việt, tiếng Anh
12.0 giờ video
96 bài giảng
1 bài quiz
Truy cập vĩnh viễn
Học trên mọi thiết bị
Cập nhật: 30/05/2026

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

Áp dụng các khái niệm WPF bằng C#
Cách áp dụng từng chủ đề vào các dự án WPF Core thực tế bằng C#
Cách xây dựng dự án chuyên nghiệp với EF Core trên SQL
Cách xây dựng dự án chuyên nghiệp với Entity Framework Core trên SQL
Cách tạo thuật toán hệ thống Theo dõi Nhân sự
Cách sử dụng các mục trong Toolbox của WPF core
Không yêu cầu kinh nghiệm trước về Cơ sở dữ liệu HOẶC SQL.
Cách sử dụng các mục trong Toolbox của WPF core
Cách sử dụng các lệnh Xaml
Cách áp dụng từng chủ đề vào các dự án thực tế
Hiểu cách sử dụng phương pháp database-first với Entity Framework Core
Tạo các dự án thực tế bằng WPF Core và Entity Framework Core
Cách xử lý lỗi và ngoại lệ trong ứng dụng của bạn
Cách sử dụng kỹ thuật lập trình để phát triển hiệu quả
Kết thúc khóa học, bạn sẽ có khả năng xây dựng bất kỳ ứng dụng WPF Core chuyên nghiệp nào với đầy đủ chi tiết bằng .Net Core và Entity Framework Core
Lập trình hướng đối tượng (OOP) là một mô hình lập trình máy tính, trong đó ứng dụng phần mềm được phát triển bằng cách mô hình hóa các đối tượng thực tế vào phần mềm
ASP.NET là một framework ứng dụng web phía máy chủ, cho phép các nhà phát triển web tạo ra các trang web động và dịch vụ tương tác, nhanh chóng
Mặc dù C# là ngôn ngữ tương đối dễ học và bảo trì, nhưng nó không chỉ dành cho người mới bắt đầu.
C# là gì? C# (phát âm là "see-sharp") là ngôn ngữ lập trình hướng đối tượng, đa mục đích.
Ưu điểm của C# so với C++ là gì? Nhờ .NET framework, C# có nhiều ưu điểm hơn C++. C# là phiên bản được tinh chỉnh và hiện đại hóa của C++.
Tại sao sử dụng đóng gói (encapsulation) trong C#? Đóng gói có thể được sử dụng trong C# để ẩn dữ liệu và hành vi chương trình khỏi người dùng.
Web API, như tên gọi, là một API trên web có thể được truy cập bằng giao thức HTTP. Đây là một khái niệm chứ không phải một công nghệ.
REST API là một giao diện lập trình ứng dụng (API) tuân theo các ràng buộc của kiến trúc REST và cho phép tương tác với các dịch vụ RESTful

Yêu cầu

Mong muốn học C#, MS SQL, WPF Core
Mong muốn học WPF .Net Core
Máy tính Windows để cài đặt tất cả phần mềm và công cụ miễn phí cần thiết để thực hành
Kiến thức C# cơ bản
Visual Studio 2019 cho WPF core, C# WPF
SQL Server Management Studio
Không yêu cầu kinh nghiệm trước về Cơ sở dữ liệu HOẶC SQL.
Mong muốn học EF Core cho SQL
Mong muốn học cách Tạo Dự án Chuyên nghiệp
Mong muốn học WPF core, wpf c#, c# với ms sql
Không cần gì khác! Chỉ cần bạn, máy tính và quyết tâm bắt đầu ngay hôm nay

Đối tượng phù hợp

Những người muốn đọc và viết code C# wpf core
Bất kỳ ai muốn cải thiện kỹ năng lập trình C# OOP, MS SQL & WPF Core
Bất kỳ ai muốn học cách viết code bằng ngôn ngữ lập trình C#, bất kể trình độ hiện tại
Bất kỳ ai muốn bắt đầu học Cơ bản về SQL Server
Bất kỳ ai muốn hiểu rõ hơn về cách cơ sở dữ liệu hoạt động
Bất kỳ ai có kế hoạch theo đuổi sự nghiệp về cơ sở dữ liệu Microsoft SQL Server
Các chuyên viên tư vấn BI làm việc với các công nghệ khác ngoài SQL Server (Oracle, v.v...)
Những người sẵn sàng xây dựng sự nghiệp trong môi trường doanh nghiệp

Nội dung khóa học

14 phần • 96 bài giảng
1 Giới thiệu về C# RESTFUL API và WPF Core với MsSQL & EF Core
2 Câu hỏi thường gặp về Restful API và Web API
3 Tệp Dự án
1 Cách Cài Đặt Visual Studio 2019 Trên Windows?
2 Cách Cài Đặt Visual Studio Trên Mac?
3 Cách Cài Đặt Visual Studio 2022 Trên Windows?
1 Web API là gì
2 Các khái niệm Web API: Rest và SOAP
3 Phương pháp code first trong EF Core
4 Các thao tác CRUD trong EF Core
1 HTTP là gì
2 Mã trạng thái HTTP
3 Các phương thức HTTP
4 Sử dụng Postman
5 Phương thức Get trong C# Web API Core
6 Phương thức Get trong C# Web API Core - Phần 2
7 Phương thức Post trong C# Web API Core
8 Phương thức Put trong C# Web API Core
9 Phương thức Delete trong C# Web API Core
1 Tạo dự án MVC Core trong Asp Core
2 MVC Core: Lấy danh sách Phòng ban bằng cách tiêu thụ Web API Core - Phương thức Get
3 MVC Core: Lấy danh sách Nhân viên và Lương bằng cách tiêu thụ Web API Core - Phương thức Get
4 MVC Core: Thêm Phòng ban và Nhân viên bằng cách tiêu thụ Web API Core - Phương thức Post
5 MVC Core: Cập nhật Phòng ban bằng cách tiêu thụ Web API Core - Phương thức Put
6 MVC Core: Cập nhật Nhân viên bằng cách tiêu thụ Web API Core - Phương thức Put
7 MVC Core: Xóa Lương bằng cách tiêu thụ Web API Core - Phương thức Delete
8 MVC Core: Thao tác với Tệp bằng cách tiêu thụ Web API Core
9 C# Web API Core: Các khái niệm CORS và SOP
1 C# Web API Core: Đăng nhập bằng Facebook
2 C# Web API Core: Đăng nhập bằng Google
1 C# Web API Core: Lấy Tin tức Toàn cầu từ News API
1 WPF là gì
2 Dự án WPF Core đầu tiên
3 Thuộc tính Windows trong WPF Core
4 Nút bấm (Button) trong C# WPF Core
5 Nhãn (Label) trong C# WPF Core
6 Hộp văn bản (TextBox) trong C# WPF Core
7 Hộp kiểm (CheckBox) trong C# WPF Core
8 Nút chọn (RadioButton) trong C# WPF Core
9 Hộp kết hợp (Combobox) trong C# WPF Core
10 Hộp danh sách (ListBox) trong C# WPF Core
11 C# WPF Core: Ôn tập về Panel và Control
12 Canvas trong C# WPF Core
13 Wrap Panel trong C# WPF Core
14 Stack Panel trong C# WPF Core
15 Dock Panel trong C# WPF Core
16 Điều khiển Grid trong C# WPF Core
17 DatePicker trong C# WPF Core
18 Datagrid trong C# WPF Core
19 User Control trong C# WPF Core
1 Giới thiệu về SQL
2 Lệnh Insert
3 Lệnh Select
4 Lệnh Update
5 Lệnh Delete
1 Dự án C# WPF Core MVVM: Phiên bản cuối cùng của dự án
2 Dự án C# WPF Core MVVM: Tạo cơ sở dữ liệu trên SQL
3 Dự án C# WPF Core MVVM: Tạo dự án và Kết nối Cơ sở dữ liệu
4 Dự án C# WPF Core MVVM: Thiết kế cửa sổ chính (Main Window)
5 Dự án C# WPF Core MVVM: Liệt kê Phòng ban
6 Dự án C# WPF Core MVVM: Thêm Phòng ban
7 Dự án C# WPF Core MVVM: Cập nhật Phòng ban
8 Dự án C# WPF Core MVVM: Thêm, Cập nhật và Liệt kê Vị trí
9 Dự án C# WPF Core MVVM: Thiết kế cửa sổ Nhân viên
10 Dự án C# WPF Core MVVM: Thêm Nhân viên
11 Dự án C# WPF Core MVVM: Liệt kê Nhân viên
12 Dự án C# WPF Core MVVM: Cập nhật Nhân viên
13 Dự án C# WPF Core MVVM: Thiết kế cửa sổ Công việc
14 Dự án C# WPF Core MVVM: Thêm Công việc
15 Dự án C# WPF Core MVVM: Liệt kê Công việc
16 Dự án C# WPF Core MVVM: Cập nhật Công việc
17 Thiết kế cửa sổ Lương
18 Dự án C# WPF Core MVVM: Thêm Lương
19 Dự án C# WPF Core MVVM: Liệt kê Lương
20 Dự án C# WPF Core MVVM: Cập nhật Lương
21 Dự án C# WPF Core MVVM: Xóa Lương
22 Dự án C# WPF Core MVVM: Xóa Công việc
23 Dự án C# WPF Core MVVM: Cửa sổ Đăng nhập
24 Dự án C# WPF Core MVVM: Thiết kế cửa sổ Phân quyền
25 Dự án C# WPF Core MVVM: Thêm Phân quyền
26 Dự án C# WPF Core MVVM: Liệt kê Phân quyền
27 Dự án C# WPF Core MVVM: Cập nhật Phân quyền
28 Dự án C# WPF Core MVVM: Xóa Phân quyền
29 Dự án C# WPF Core MVVM: Xóa Nhân viên bằng Triggers
30 Dự án C# WPF Core MVVM: Xóa Vị trí bằng Triggers
31 Dự án C# WPF Core MVVM: Xóa Phòng ban bằng Triggers
32 Dự án C# WPF Core MVVM: Các thao tác Ủy quyền
1 C# WPF Core: Thiết kế Trang mới để tiêu thụ Web API Core
2 C# WPF Core: Lấy Phòng ban bằng cách tiêu thụ Web API Core
3 C# WPF Core: Thêm Phòng ban bằng cách tiêu thụ Web API Core
4 C# WPF Core: Cập nhật Phòng ban bằng cách tiêu thụ Web API Core
5 C# WPF Core: Xóa Phòng ban bằng cách tiêu thụ Web API Core
1 Những gì chúng ta đã học
1 Sử dụng Hộp thông báo (Message Box)
2 Sử dụng Điểm dừng (Break Point)
1 C# Restful API và WPF Core với MsSQL & EF Core

Giới thiệu khóa học

Wpf, wpf mvvm, xaml, c# wpf, mvvm, wpf application, mvvm wpf, Windows presentation foundation, c#, wpf xaml, wpf gui, uwp wpf, C# RestFul Web API on Net Core Web API with using Postman and in Real Project

Hello,

Welcome to C# RESTFUL API on Web API Net Core with MsSQL & EF Core

C# Restful API on Web API Net Core, HTTP, MsSQL, WPF Core with real world Rest API Projects, WPF Core Projects, EF Core

Finally, our Web API beginning course is ready for you A lot of students want an API course to Use API projects on Net Core Wpf, c#, c# wpf, wpf mvvm, wpf c#, entity framework, c# projects, entity framework core, c# Project, ef core, c sharp, WPF XAML, CSharp

Before starting, I want to explain that this course is a part of big training I can tell this part is the most important part that we will use in following training in an online ticket project, a web project, and in all mobile versions as well made in Xamarin, Flutter, Java Android, Angular, Node js, React Native, and Vue Native For developers who have no knowledge about the API, I preferred to explain the basics of the API in this section basically However, in the following sections, we will learn to use JSON web tokens and we will apply JSON Web Token in more complex projects

This course will give you everything that you will need to start Web API project’s on Net Core Before starting this course, you should know that you need to have basic C# knowledge With this course, you will learn API concepts with Net core and you will make more practice on C# programming And as you know with C# programming you may use Xamarin Forms to build cross-platform mobile apps or design a new video game in Unity

We will start our training with answers to what the Web API is Then we will examine the most useful concepts as Rest and SOAP We will learn the differences between SOAP and RESTFul

In Net core programming, EF core is very important to make crud SQL operations In this course, you will learn to use EF Core with code first approach on a project that you can use in any project

After EF core, you will meet HTTP concepts or you will get more information about HTTP Concepts For example, you will learn the meaning of HTTP status code that you may always see in any project like 404 status code as not found In this course, you can find all necessary information about the crud operation of API with HTTP methods as Get Post, Put, Delete, or Patch

Postman is one of the most popular software testing tools which is used for API testing With the help of this tool, developers can easily create, test, share, and document APIs And in my opinion, if you work on APIs, the postman is the best app for you This means in this course you can also learn using Postman

In most training trainers prefer to show API results only with the postman But in this course, you will also learn to consume an API This explanation may be too complicated for you Simply, in this course first, we will create an API project as Back-End After that, we will create another project in which we will consume our source as Front-End As you know net framework works only on windows platforms but net core is a cross-platform framework which means with Net core you may use the other platforms This means you can share your API with any projects on any platform

In this training, you can also learn to use any API to consume like news API to get global news to your project And in any project, you may see that login with Facebook or Google This means you can learn facebook or google authentication Also, we will learn to consume API projects in a WPF core project
ASP NET is a server-side web application framework that allows web developers to produce dynamic websites and services that are interactive and fast ASP NET code is compiled, making the resulting applications much more efficient compared to those built with scripting languages like PHP

Even though C# is a language that’s relatively easy to learn and maintain, it isn’t just for beginners Its scalability and large support community make C# the language of choice for Microsoft app developers and video game developers working with the Unity Engine Like C++ and Java, C# is a high-level object-oriented programming language It is generally more efficient than Java and has useful features such as operator overloading C# is based on C++ but has several advantages over this older language: it is type-safe, more comprehensively object-oriented, and the syntax has been simplified in several important ways Most importantly, C# interoperates exceptionally well with other languages on the NET platform For this reason, C# is a better choice for building applications for NET

What you will learn?

  • Apply the WPF concepts using C#

  • How to apply each subject to real C# WPF Core projects

  • How to make a professional project with EF Core on SQL

  • How to make a professional project with Entity Framework Core on SQL

  • How to Create Personnel Tracking systems algorithm

  • Using of Toolbox items in WPF core

  • Using of Toolbox items in WPF core

  • Using Xaml commands

  • How to apply each subject to real projects

  • Understand how to use the database first approach with using Entity Framework Core

  • Create real-world projects using WPF Core and Entity Framework Core

  • How to Handle errors and exceptions in your apps

  • How to use coding techniques to make efficient development

  • By the end of this course, you will be in a position to build any professional WPF Core application with all details using Net Core and Entity Framework Core

  • Using Object-oriented programming (OOP) is a computer programming paradigm where a software application is developed by modeling real-world objects into the software

  • WPF (windows presentation foundation)

  • WPF core

  • wpf c#

  • c# wpf

  • ms sql

  • mssql

  • c#

  • c# sql

  • sql

  • ms sql server

  • ms sql server

  • c# and sql

  • oak academy

  • sql with c#

  • c# sql server

  • microsoft sql

  • ssrs

  • Microsoft sql server

  • Tips and Tricks

  • How to install and set up these requirements

  • You will learn the basics of SQL such as data, database, DBMS or SSMS, SQL, tables, and so on

  • Database normalization,

  • Manipulating data,

  • Retrieving data from the database with different scenarios,

  • You will also learn SQL transactions and transaction commands,

  • Schema and schema objects and

  • User privileges, permission commands, and roles

  • What is the recovery model? What are the differences between the Full, Bulked Logged, and Simple recover model?

  • What is a full backup? Why does every backup have to start with a full backup?

  • What is a differential backup? what is it used for?

  • What is a transaction log backup? what does it do

  • How do we reinstall if the database is completely deleted?

  • How do we return the database to a specific time?

Why would you want to take this course?

Our answer is simple: The quality of teaching

OAK Academy based in London is an online education company OAK Academy gives education in the field of IT, Software, Design, development in English, Portuguese, Spanish, Turkish, and a lot of different languages on the Udemy platform where it has over 1500+ hours of video education lessons OAK Academy both increase its education series number by publishing new courses, and it makes students aware of all the innovations of already published courses by upgrading

When you enroll, you will feel the OAK Academy`s seasoned developers' expertise Questions sent by students to our instructors are answered by our instructors within 48 hours at the latest

What is C#?

C# (pronounced see-sharp) is a general-purpose, object-oriented programming language It was designed as a multi-paradigm programming language by Microsoft in around 2000 as part of its NET initiative The NET framework and NET applications are multi-platform applications that you can use with programming languages such as C++, C#, Visual Basic, and COBOL C# is open-source and was designed to be simple yet modern, flexible yet powerful, and versatile yet easy to learn and program with Many programming languages in the past were designed for specific purposes C# was developed with business and enterprise needs in mind By providing functionality to support modern-day software development such as web applications, mobile, and response app needs, C# supports many features of modern-day programming languages That includes generics, var types, dynamic programming, asynchronous programming, pattern matching, advanced debugging, and exception handling, to name a few

What are the advantages of C# over C++?

Thanks to the NET framework, C# has many advantages over C++ C# is a refined and modernized version of C++ C++ was developed to bring object-orientation to C, an older but widely used language, and C++ became the de-facto language for building applications for Windows as well as infrastructure and low-level applications Visual Basic was for business applications What C# does is combine the rapid development capabilities of VB with the power of C++ C# also has many new data types, type-safety, to ensure you do not unknowingly reuse initialized variables It uses a simplified syntax, a huge improvement over the complex coding often required in C++ C# also removes memory management issues thanks to NET’s garbage collection scheme You do not have to reference items for garbage collection; the system can reclaim that memory as required Finally, you can use C# to interoperate with other languages on the NET platform, a huge benefit in terms of system interoperability

Why use encapsulation in C#?

Encapsulation can be used in C# to hide data and program behavior from users With encapsulation, you can group properties, methods, and other members so that they are treated as a single object It is a means to prevent the user of a given class from manipulating program objects in ways that were not intended by the designer or developer Encapsulation hides how a program operates without affecting how it works while still allowing users to service requests for functionality and add or modify internal data or methods to meet changing needs For example, suppose you have an object called “Patient” that contains patient-related data In that case, you can use encapsulation to provision patient-specific data to those who need it without exposing all patient data In addition to information hiding, you can use encapsulation in C# to improve your code's reusability, and it also makes it easier to perform unit testing

What is C# used for?

C# is a general-purpose programming language that you can use to build a wide range of programs and applications, such as web applications, Windows applications and game development In web application development, you can build dynamic websites and apps using NET or another open-source platform of your choice Also, since Microsoft created C# for Microsoft, C# is a popular language for building Windows applications There are rich resources and a vibrant C# community that can support and documentation for applications and programs specific to Microsoft platform architectures, making it easier than ever to develop applications in this space Finally, C# is a popular language to use in game-building, especially with Unity, a game engine that runs on C++ and C#

What is a constructor? What is a destructor?

To understand constructors and destructors, we need to understand methods A method is a block of code that contains a series of statements Programs run by executing methods A constructor is a special method of a class that is automatically called whenever an instance of a given class is created A constructor contains the instructions that execute when an object is created Developers use it to assign specific initial values to the data members of the same class In C#, you will get a compile-time error if you try to read from an uninitialized variable You must first initialize your variables by giving them an initial value, which is what the constructor does On the other hand, destructors are methods used to destroy instances of a class when they are no longer needed Destructors are called implicitly by the garbage collector in NET, and as a developer, you have no control regarding when to call the destructor

How do I learn C#?

As is true for many skills, you can learn C# by taking Udemy courses, reading documentation, and practicing coding hands-on There are many resources available for all of the above, including real-time compiler applications that will show you the output of your code as you type it However, it is best to plan ahead, and you should have an outline of what you need to learn before beginning your journey The first thing to learn about is what C# is, how and where it is used, and why it was developed From there, you can learn about data types, variables, keywords, and functions Once you’ve grasped the basics, you can move on to learning about conditional tests and operators, functions, arguments, object orientation, arrays, strings, classes, methods, structs, debugging, and exception handling

What is SQL Server?

SQL Server is a relational database management system or RDBMS created and developed by Microsoft Designed to store and retrieve data for other software applications using the client-server model-- these applications connect to SQL Server through a network or the Internet with multiple applications using the same data One SQL Server instance can also manage one or more relational databases Relational databases store data in tables that can relate to each other For example, data for business customers get stored in one table relating to another table that stores orders Applications that connect to Microsoft SQL Server retrieve, store, and delete data using Structured Query Language (SQL) SQL Server is available for Windows and Linux

What is SQL Server Management Studio?

SQL Server Management Studio is desktop software designed to connect to Microsoft relational database management systems, including Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics SQL Server Management Studio is an integrated database development tool that database architects, database developers, and software engineers can use to access, configure, manage, administer, and develop databases on any one of these database systems It simplifies database management by providing graphical design tools and rich script editors that allow database developers to visualize an entire database or multiple databases from a single application SQL Server Management Studio only runs on the Microsoft Windows operating system but can connect to database instances running on either Windows or Linux

Why would you want to take this course?

Our answer is simple: The quality of teaching

When you enroll, you will feel our seasoned developers' expertise

No prior knowledge is needed!

It doesn't need any prior knowledge to learn it and it is easy to understand for beginners

This course starts with the very basics First, you will learn how to install the tools, some terminology Then the show will start and you will learn everything with hands-on practice I'll also teach you the best practices and shortcuts

Step-by-Step Way, Simple and Easy With Exercises

By the end of the course, you’ll have a firm understanding of the C# and SQL You will have valuable insights on how things work under the hood and you'll also be very confident in the basics of coding and game development, and hungry to learn more The good news is since the Free and popular tools are used you don’t need to buy any tool or application

Video and Audio Production Quality

All our videos are created/produced as high-quality video and audio to provide you the best learning experience

You will be,

  • Seeing clearly

  • Hearing clearly

  • Moving through the course without distractions

You'll also get:

Lifetime Access to The Course

Fast & Friendly Support in the Q&A section

Udemy Certificate of Completion Ready for Download

Dive in now

C# RESTFUL API and WPF Core with MsSQL & EF Core

We offer full support, answering any questions

See you in the course!



Khóa học liên quan

Khám phá thêm các khoá học cùng chủ đề

Hiển thị tất cả khoá học Entity Framework Core
Hiển thị tất cả khoá học Wpf
Zalo
Tôi có thể tư vấn khoá học cho bạn 😊