Database Integration and Management

Database Integration and Management

本课程是多个项目的一部分。

位教师： Microsoft

访问权限由 New York State Department of Labor 提供

3,915 人已注册

4个模块

深入了解一个主题并学习基础知识。

16 条评论

初级等级

推荐体验

3 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

4个模块

深入了解一个主题并学习基础知识。

16 条评论

初级等级

推荐体验

3 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将获得的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

22 任务¹

AI 评分请参见免责声明

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

积累特定领域的专业知识

此课程作为的一部分提供

在注册此课程时，您还需要选择一个特定的合作项目。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
通过 Microsoft 获得可共享的职业证书

该课程共有4个模块

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.

By the end of the course, you will be able to… Describe the features and functionalities of Entity Framework Core (EF Core), the structure and principles of relational databases, and performance tuning and optimization techniques for SQL queries. Explain the steps to set up a relational database, model data using EF Core, retrieve and manipulate data using SQL, and handle transactions and concurrency control in SQL. Define the basic syntax and functionalities of SQL, and the principles of advanced query techniques and security best practices for SQL databases. Develop practical database operations using Microsoft Copilot, including writing, debugging, and optimizing SQL queries.

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 个人资料、简历或履历中。在社交媒体和绩效考核中分享。

位教师

Microsoft

287 门课程 2,292,838 名学生

提供方

Microsoft

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

自 2018开始学习的学生

''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'

Jennifer J.

自 2020开始学习的学生

''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'

Larry W.

自 2021开始学习的学生

''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'

Chaitanya A.

''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'

学生评论

5 stars
87.50%
4 stars
12.50%
3 stars
0%
2 stars
0%
1 star
0%

显示 3/16 个

已于 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.

查看更多评论