Database Integration and Management

Database Integration and Management

This course is part of multiple programs.

Instructor: Microsoft

Access provided by EDGE Group

3,984 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

16 reviews

Beginner level

Recommended experience

3 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

16 reviews

Beginner level

Recommended experience

3 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

22 assignments¹

AI Graded see disclaimer

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is available as part of

When you enroll in this course, you'll also be asked to select a specific program.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Microsoft

There are 4 modules in this course

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.

What's included

20 videos11 readings7 assignments3 ungraded labs3 plugins

20 videos Total 86 minutes

Course Introduction: Database Integration and Management 2 minutes
Instructor Introduction 2 minutes
The What’s What of the Course 3 minutes
Completing the Guided Labs 4 minutes
Introducing the AI Tool: Microsoft Copilot 3 minutes
How to Be Successful in This Program 5 minutes
Introduction to the Project 4 minutes
Introduction: Introduction to EF Core and Relational Databases 1 minute
Introduction to ORM and EF Core 6 minutes
Basic Structure of Relational Databases 4 minutes
Principles of Relational Database Design 6 minutes
Choosing a Database Management System (DBMS) 6 minutes
Practical Example: Initial Database Setup and Configuration 6 minutes
Setting Up a Relational Database 6 minutes
Introduction to Data Modeling in EF Core 4 minutes
Creating and Configuring Entity Classes 8 minutes
Modeling a Simple Database with EF Core 5 minutes
Performing CRUD Operations with EF Core 4 minutes
Implementing CRUD Operations in EF Core 5 minutes
Conclusion: Introduction to EF Core and relational databases 1 minute

11 readings Total 135 minutes

Course Syllabus: Database Integration and Management 10 minutes
Completing the Guided Labs 30 minutes
Microsoft Tools for Back-End Development 10 minutes
Entity Framework Core (EF Core) 10 minutes
Fundamentals of Relational Databases 15 minutes
Activity: Databases - Answer Key 10 minutes
You Try It! Setting Up a Relational Database - Answer Key 10 minutes
Data Modeling with Entity Framework Core 10 minutes
You Try It! Modeling a Simple Database with EF Core - Answer Key 10 minutes
Performing CRUD Operations with EF Core 10 minutes
You try It! Implementing CRUD Operations in EF Core - Answer Key 10 minutes

7 assignments Total 160 minutes

Practice Quiz: Overview of Entity Framework Core (EF Core) 15 minutes
Activity: Databases 30 minutes
Practice Quiz: Fundamentals of Relational Databases 15 minutes
Practice Quiz: Setting Up a Relational Database 15 minutes
Practice Quiz: Data Modeling with Entity Framework Core 20 minutes
Practice Quiz: Performing CRUD Operations with EF Core 15 minutes
Graded Quiz: Introduction to EF Core and relational databases 50 minutes

3 ungraded labs Total 180 minutes

You Try It! Setting up a Relational Database 60 minutes
You Try It! Modeling a Simple Database with EF Core 60 minutes
You Try It! Implementing CRUD Operations in EF Core 60 minutes

3 plugins Total 45 minutes

Guided Lab: Setting Up a Relational Database 15 minutes
Guided Lab: Modeling a Simple Database with EF Core 15 minutes
Guided Lab: Implementing CRUD Operations in EF Core 15 minutes

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.

What's included

15 videos9 readings6 assignments3 ungraded labs3 plugins

15 videos Total 78 minutes

Introduction: Basics of SQL 1 minute
Understanding SQL Syntax 5 minutes
Describe the Functionalities of Core SQL Commands 5 minutes
Basic Data Retrieval with SELECT 3 minutes
Filtering and Sorting Data 6 minutes
Writing SELECT Statements 5 minutes
Inserting Data with INSERT Statements 5 minutes
Updating and Deleting Data 6 minutes
Practicing Data Manipulation in SQL 5 minutes
Introduction to SQL JOINs 6 minutes
Practical Examples of Using JOINs 9 minutes
Introduction to SQL Functions 6 minutes
Using Aggregate Functions in SQL 6 minutes
Implementing SQL Functions and Aggregate Functions 7 minutes
Conclusion: Basics of SQL 1 minute

9 readings Total 95 minutes

Understanding SQL Syntax 10 minutes
Describe the Functionalities of Core SQL Commands 10 minutes
Retrieving Data with SELECT Statements 10 minutes
You try It! Writing SELECT Statements - Answer Key 10 minutes
Data Manipulation in SQL 10 minutes
You Try It! Practicing Data Manipulation in SQL - Answer Key 10 minutes
Combining Data with SQL JOIN Clauses 15 minutes
Working with SQL Functions and Aggregate Functions 10 minutes
You Try It! Implementing SQL Functions and Aggregate Functions - Answer Key 10 minutes

6 assignments Total 145 minutes

Practice Quiz: Introduction to SQL Syntax and Basic Commands 15 minutes
Practice Quiz: Retrieving Data with SELECT Statements 20 minutes
Practice Quiz: Data Manipulation in SQL 25 minutes
Practice Quiz: Combining Data with SQL JOIN Clauses 15 minutes
Practice Quiz: Working with SQL Functions and Aggregate Functions 20 minutes
Graded Quiz: Basics of SQL 50 minutes

3 ungraded labs Total 180 minutes

You try It! Writing SELECT Statements 60 minutes
You Try It! Practicing Data Manipulation in SQL 60 minutes
You Try It! Implementing SQL Functions and Aggregate Functions 60 minutes

3 plugins

Guided Lab: Writing SELECT Statements 0 minutes
Guided Lab: Practicing Data Manipulation in SQL 0 minutes
Guided Lab: Implementing SQL Functions and Aggregate Functions 0 minutes

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.

What's included

13 videos7 readings6 assignments1 ungraded lab1 plugin

13 videos Total 71 minutes

Introduction: Advanced Data Handling 2 minutes
Introduction to Subqueries and Common Table Expressions (CTEs) 7 minutes
Advanced Filtering and Query Techniques 9 minutes
Introduction to SQL Performance Tuning 4 minutes
Techniques for Optimizing SQL Queries 5 minutes
Introduction to SQL Transactions 6 minutes
Concurrency Control in SQL 8 minutes
Introduction to Stored Procedures and Functions 5 minutes
Creating and Managing Stored Procedures and Functions 6 minutes
Advanced SQL, Transactions, and Stored Procedures 8 minutes
Introduction to SQL Database Security 5 minutes
Protecting Against SQL Injection and Other Attacks 4 minutes
Conclusion: Advanced Data Handling 2 minutes

7 readings Total 95 minutes

Mastering Advanced SQL Query Techniques 10 minutes
Introduction to SQL Performance Tuning 10 minutes
Techniques for Optimizing SQL Queries 30 minutes
Managing Transactions and Concurrency in SQL 10 minutes
Leveraging Stored Procedures and Functions in SQL 15 minutes
You Try It! Advanced SQL, Transactions, and Stored Procedures - Answer Key 10 minutes
Securing SQL Databases 10 minutes

6 assignments Total 130 minutes

Practice Quiz: Mastering Advanced SQL Query Techniques 20 minutes
Practice Quiz: SQL Query Performance Tuning and Optimization 15 minutes
Practice Quiz: Managing Transactions and Concurrency in SQL 15 minutes
Practice Quiz: Leveraging Stored Procedures and Functions in SQL 15 minutes
Practice Quiz: Securing SQL Databases 15 minutes
Graded Quiz: Advanced Data Handling 50 minutes

1 ungraded lab Total 60 minutes

You Try It! Advanced SQL, Transactions, and Stored Procedures 60 minutes

1 plugin Total 15 minutes

Guided Lab: Advanced SQL, Transactions, and Stored Procedures 15 minutes

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.

What's included

5 videos1 reading3 assignments1 peer review

5 videos Total 25 minutes

Introduction: Writing SQL Queries with Microsoft Copilot 1 minute
Introduction to Microsoft Copilot for SQL Query Writing 8 minutes
Advanced SQL Query Capabilities of Microsoft Copilot 8 minutes
Introduction to SQL Query Debugging and Optimization with Microsoft Copilot 7 minutes
Course Conclusion: Database Integration and Management 2 minutes

1 reading Total 10 minutes

Writing SQL Queries with Microsoft Copilot 10 minutes

3 assignments Total 90 minutes

Activity: Writing Basic SQL Queries with Microsoft Copilot 30 minutes
Activity: Creating Complex SQL Queries with Microsoft Copilot 30 minutes
Activity 3: Debugging and Optimizing SQL Queries with Microsoft Copilot 30 minutes

1 peer review Total 60 minutes

Capstone Project Overview and Requirements 60 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Microsoft

287 Courses 2,317,051 learners

Offered by

Microsoft

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

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

Showing 3 of 16

Reviewed on 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.

View more reviews