This course covers database integration and management using Entity Framework Core (EF Core) and SQL. You'll learn to set up relational databases, optimize SQL queries, and use Microsoft Copilot to efficiently write, debug, and manage SQL operations.
Database Integration and Management
了解顶级公司的员工如何掌握热门技能
积累特定领域的专业知识
此课程作为 的一部分提供
在注册此课程时，您还需要选择一个特定的合作项目。
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 通过 Microsoft 获得可共享的职业证书
该课程共有4个模块
In this module, you’ll explore the core features of a powerful tool for working with relational databases. You’ll learn about relational database structure, how to set one up, and the principles behind it. You’ll also discover how to model data and perform essential CRUD (Create, Read, Update, Delete) operations efficiently. By the end, you’ll have the skills to manage data effectively in your projects.
涵盖的内容
20个视频11篇阅读材料7个作业3个非评分实验室3个插件
20个视频•总计86分钟
- Course Introduction: Database Integration and Management•2分钟
- Instructor Introduction•2分钟
- The What’s What of the Course•3分钟
- Completing the Guided Labs•4分钟
- Introducing the AI Tool: Microsoft Copilot•3分钟
- How to Be Successful in This Program•5分钟
- Introduction to the Project•4分钟
- Introduction: Introduction to EF Core and Relational Databases•1分钟
- Introduction to ORM and EF Core•6分钟
- Basic Structure of Relational Databases•4分钟
- Principles of Relational Database Design•6分钟
- Choosing a Database Management System (DBMS)•6分钟
- Practical Example: Initial Database Setup and Configuration•6分钟
- Setting Up a Relational Database•6分钟
- Introduction to Data Modeling in EF Core•4分钟
- Creating and Configuring Entity Classes•8分钟
- Modeling a Simple Database with EF Core•5分钟
- Performing CRUD Operations with EF Core•4分钟
- Implementing CRUD Operations in EF Core•5分钟
- Conclusion: Introduction to EF Core and relational databases•1分钟
11篇阅读材料•总计135分钟
- Course Syllabus: Database Integration and Management•10分钟
- Completing the Guided Labs•30分钟
- Microsoft Tools for Back-End Development•10分钟
- Entity Framework Core (EF Core)•10分钟
- Fundamentals of Relational Databases•15分钟
- Activity: Databases - Answer Key•10分钟
- You Try It! Setting Up a Relational Database - Answer Key•10分钟
- Data Modeling with Entity Framework Core•10分钟
- You Try It! Modeling a Simple Database with EF Core - Answer Key•10分钟
- Performing CRUD Operations with EF Core•10分钟
- You try It! Implementing CRUD Operations in EF Core - Answer Key•10分钟
7个作业•总计160分钟
- Graded Quiz: Introduction to EF Core and relational databases•50分钟
- Practice Quiz: Overview of Entity Framework Core (EF Core)•15分钟
- Activity: Databases•30分钟
- Practice Quiz: Fundamentals of Relational Databases•15分钟
- Practice Quiz: Setting Up a Relational Database•15分钟
- Practice Quiz: Data Modeling with Entity Framework Core•20分钟
- Practice Quiz: Performing CRUD Operations with EF Core•15分钟
3个非评分实验室•总计180分钟
- You Try It! Setting up a Relational Database•60分钟
- You Try It! Modeling a Simple Database with EF Core•60分钟
- You Try It! Implementing CRUD Operations in EF Core•60分钟
3个插件•总计45分钟
- Guided Lab: Setting Up a Relational Database•15分钟
- Guided Lab: Modeling a Simple Database with EF Core•15分钟
- Guided Lab: Implementing CRUD Operations in EF Core•15分钟
In this module, you’ll dive into the fundamentals of SQL, learning its basic syntax and key functionalities. You’ll master retrieving data with SELECT statements, manipulating data with INSERT, UPDATE, and DELETE commands, and combining data from multiple tables using JOIN clauses. Additionally, you’ll explore essential SQL and aggregate functions to perform powerful data operations easily. By the end, you’ll be equipped to manage and query databases effectively.
涵盖的内容
15个视频9篇阅读材料6个作业3个非评分实验室3个插件
15个视频•总计78分钟
- Introduction: Basics of SQL•1分钟
- Understanding SQL Syntax•5分钟
- Describe the Functionalities of Core SQL Commands•5分钟
- Basic Data Retrieval with SELECT•3分钟
- Filtering and Sorting Data•6分钟
- Writing SELECT Statements•5分钟
- Inserting Data with INSERT Statements•5分钟
- Updating and Deleting Data•6分钟
- Practicing Data Manipulation in SQL•5分钟
- Introduction to SQL JOINs•6分钟
- Practical Examples of Using JOINs•9分钟
- Introduction to SQL Functions•6分钟
- Using Aggregate Functions in SQL•6分钟
- Implementing SQL Functions and Aggregate Functions•7分钟
- Conclusion: Basics of SQL•1分钟
9篇阅读材料•总计95分钟
- Understanding SQL Syntax•10分钟
- Describe the Functionalities of Core SQL Commands•10分钟
- Retrieving Data with SELECT Statements•10分钟
- You try It! Writing SELECT Statements - Answer Key•10分钟
- Data Manipulation in SQL•10分钟
- You Try It! Practicing Data Manipulation in SQL - Answer Key•10分钟
- Combining Data with SQL JOIN Clauses•15分钟
- Working with SQL Functions and Aggregate Functions•10分钟
- You Try It! Implementing SQL Functions and Aggregate Functions - Answer Key•10分钟
6个作业•总计145分钟
- Graded Quiz: Basics of SQL•50分钟
- Practice Quiz: Introduction to SQL Syntax and Basic Commands•15分钟
- Practice Quiz: Retrieving Data with SELECT Statements•20分钟
- Practice Quiz: Data Manipulation in SQL•25分钟
- Practice Quiz: Combining Data with SQL JOIN Clauses•15分钟
- Practice Quiz: Working with SQL Functions and Aggregate Functions•20分钟
3个非评分实验室•总计180分钟
- You try It! Writing SELECT Statements•60分钟
- You Try It! Practicing Data Manipulation in SQL•60分钟
- You Try It! Implementing SQL Functions and Aggregate Functions•60分钟
3个插件
- Guided Lab: Writing SELECT Statements•0分钟
- Guided Lab: Practicing Data Manipulation in SQL•0分钟
- Guided Lab: Implementing SQL Functions and Aggregate Functions•0分钟
In this module, you’ll build on your SQL knowledge with advanced query techniques and learn how to optimize query performance. You’ll explore transactions and concurrency control to ensure data integrity and discover how to use stored procedures and functions for efficient database operations. Additionally, you’ll learn essential security best practices to protect your SQL databases. By the end, you’ll be ready to handle complex database challenges confidently.
涵盖的内容
13个视频7篇阅读材料6个作业1个非评分实验室1个插件
13个视频•总计71分钟
- Introduction: Advanced Data Handling•2分钟
- Introduction to Subqueries and Common Table Expressions (CTEs)•7分钟
- Advanced Filtering and Query Techniques•9分钟
- Introduction to SQL Performance Tuning•4分钟
- Techniques for Optimizing SQL Queries•5分钟
- Introduction to SQL Transactions•6分钟
- Concurrency Control in SQL•8分钟
- Introduction to Stored Procedures and Functions•5分钟
- Creating and Managing Stored Procedures and Functions•6分钟
- Advanced SQL, Transactions, and Stored Procedures•8分钟
- Introduction to SQL Database Security•5分钟
- Protecting Against SQL Injection and Other Attacks•4分钟
- Conclusion: Advanced Data Handling•2分钟
7篇阅读材料•总计95分钟
- Mastering Advanced SQL Query Techniques•10分钟
- Introduction to SQL Performance Tuning•10分钟
- Techniques for Optimizing SQL Queries•30分钟
- Managing Transactions and Concurrency in SQL•10分钟
- Leveraging Stored Procedures and Functions in SQL•15分钟
- You Try It! Advanced SQL, Transactions, and Stored Procedures - Answer Key•10分钟
- Securing SQL Databases•10分钟
6个作业•总计130分钟
- Graded Quiz: Advanced Data Handling•50分钟
- Practice Quiz: Mastering Advanced SQL Query Techniques•20分钟
- Practice Quiz: SQL Query Performance Tuning and Optimization•15分钟
- Practice Quiz: Managing Transactions and Concurrency in SQL•15分钟
- Practice Quiz: Leveraging Stored Procedures and Functions in SQL•15分钟
- Practice Quiz: Securing SQL Databases•15分钟
1个非评分实验室•总计60分钟
- You Try It! Advanced SQL, Transactions, and Stored Procedures•60分钟
1个插件•总计15分钟
- Guided Lab: Advanced SQL, Transactions, and Stored Procedures•15分钟
In this module, you’ll harness the power of Microsoft Copilot to streamline your SQL workflow. You’ll learn how to write and generate complex queries, debug and optimize them, and apply Copilot effectively in real-world database operations. By the end, you’ll be equipped to leverage AI assistance for efficient and accurate database management.
涵盖的内容
5个视频1篇阅读材料3个作业1次同伴评审
5个视频•总计25分钟
- Introduction: Writing SQL Queries with Microsoft Copilot•1分钟
- Introduction to Microsoft Copilot for SQL Query Writing•8分钟
- Advanced SQL Query Capabilities of Microsoft Copilot•8分钟
- Introduction to SQL Query Debugging and Optimization with Microsoft Copilot•7分钟
- Course Conclusion: Database Integration and Management•2分钟
1篇阅读材料•总计10分钟
- Writing SQL Queries with Microsoft Copilot•10分钟
3个作业•总计90分钟
- Activity: Writing Basic SQL Queries with Microsoft Copilot•30分钟
- Activity: Creating Complex SQL Queries with Microsoft Copilot•30分钟
- Activity 3: Debugging and Optimizing SQL Queries with Microsoft Copilot•30分钟
1次同伴评审•总计60分钟
- Capstone Project Overview and Requirements•60分钟
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
位教师
312 门课程•2,549,932 名学生
提供方
提供方
Microsoft
Our goal at Microsoft is to empower every individual and organization on the planet to achieve more. In this next revolution of digital transformation, growth is being driven by technology. Our integrated cloud approach creates an unmatched platform for digital transformation. We address the real-world needs of customers by seamlessly integrating Microsoft 365, Dynamics 365, LinkedIn, GitHub, Microsoft Power Platform, and Azure to unlock business value for every organization—from large enterprises to family-run businesses. The backbone and foundation of this is Azure.
人们为什么选择 Coursera 来帮助自己实现职业发展
Felipe M.
自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'
Jennifer J.
自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'
Larry W.
自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'
Chaitanya A.
''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'
学生评论
4.8
18 条评论
- 5 stars
83.33%
- 4 stars
16.66%
- 3 stars
0%
- 2 stars
0%
- 1 star
0%
显示 3/18 个
N
NR
5·
已于 Apr 21, 2025审阅
A strongly recommended course for backend developers. The aspects covered in the course on security, performance and best practices are really helpful.
通过在线学位推动您的职业生涯
获取世界一流大学的学位 - 100% 在线
常见问题
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
更多问题
提供助学金，
¹ 本课程的部分作业采用 AI 评分。对于这些作业，将根据 Coursera 隐私声明使用您的数据。