When will I have access to the lectures and assignments?

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.

What will I get if I subscribe to this Certificate?

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.

Database Integration and Management

Ends tomorrow! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

Database Integration and Management

This course is part of multiple programs.

Instructor: Microsoft

4,591 already enrolled

Included with

4 modules

Gain insight into a topic and learn the fundamentals.

18 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.

18 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

Category: Transaction Processing
Category: Data Modeling
Category: Secure Coding
Category: Object-Relational Mapping
Category: Data Security
Category: Performance Tuning
Category: Data Integrity
Category: Database Architecture and Administration
Category: Microsoft Copilot
Category: Database Development
Category: Database Design
Category: Database Management
Category: SQL

Tools you'll learn

Category: Relational Databases
Category: Query Languages

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

22 assignments¹

AI Graded see disclaimer

Taught in English

91%

of learners achieved a positive career outcome

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.

Module details

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 videosTotal 86 minutes

Course Introduction: Database Integration and Management2 minutes
Instructor Introduction2 minutes
The What’s What of the Course3 minutes
Completing the Guided Labs4 minutes
Introducing the AI Tool: Microsoft Copilot3 minutes
How to Be Successful in This Program5 minutes
Introduction to the Project4 minutes
Introduction: Introduction to EF Core and Relational Databases1 minute
Introduction to ORM and EF Core6 minutes
Basic Structure of Relational Databases4 minutes
Principles of Relational Database Design6 minutes
Choosing a Database Management System (DBMS)6 minutes
Practical Example: Initial Database Setup and Configuration6 minutes
Setting Up a Relational Database6 minutes
Introduction to Data Modeling in EF Core4 minutes
Creating and Configuring Entity Classes8 minutes
Modeling a Simple Database with EF Core5 minutes
Performing CRUD Operations with EF Core4 minutes
Implementing CRUD Operations in EF Core5 minutes
Conclusion: Introduction to EF Core and relational databases1 minute

11 readingsTotal 135 minutes

Course Syllabus: Database Integration and Management10 minutes
Completing the Guided Labs30 minutes
Microsoft Tools for Back-End Development10 minutes
Entity Framework Core (EF Core)10 minutes
Fundamentals of Relational Databases15 minutes
Activity: Databases - Answer Key10 minutes
You Try It! Setting Up a Relational Database - Answer Key10 minutes
Data Modeling with Entity Framework Core10 minutes
You Try It! Modeling a Simple Database with EF Core - Answer Key10 minutes
Performing CRUD Operations with EF Core10 minutes
You try It! Implementing CRUD Operations in EF Core - Answer Key10 minutes

7 assignmentsTotal 160 minutes

Practice Quiz: Overview of Entity Framework Core (EF Core)15 minutes
Activity: Databases30 minutes
Practice Quiz: Fundamentals of Relational Databases15 minutes
Practice Quiz: Setting Up a Relational Database15 minutes
Practice Quiz: Data Modeling with Entity Framework Core20 minutes
Practice Quiz: Performing CRUD Operations with EF Core15 minutes
Graded Quiz: Introduction to EF Core and relational databases50 minutes

3 ungraded labsTotal 180 minutes

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

3 pluginsTotal 45 minutes

Guided Lab: Setting Up a Relational Database15 minutes
Guided Lab: Modeling a Simple Database with EF Core15 minutes
Guided Lab: Implementing CRUD Operations in EF Core15 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 videosTotal 78 minutes

Introduction: Basics of SQL1 minute
Understanding SQL Syntax5 minutes
Describe the Functionalities of Core SQL Commands5 minutes
Basic Data Retrieval with SELECT3 minutes
Filtering and Sorting Data6 minutes
Writing SELECT Statements5 minutes
Inserting Data with INSERT Statements5 minutes
Updating and Deleting Data6 minutes
Practicing Data Manipulation in SQL5 minutes
Introduction to SQL JOINs6 minutes
Practical Examples of Using JOINs9 minutes
Introduction to SQL Functions6 minutes
Using Aggregate Functions in SQL6 minutes
Implementing SQL Functions and Aggregate Functions7 minutes
Conclusion: Basics of SQL1 minute

9 readingsTotal 95 minutes

Understanding SQL Syntax10 minutes
Describe the Functionalities of Core SQL Commands10 minutes
Retrieving Data with SELECT Statements10 minutes
You try It! Writing SELECT Statements - Answer Key10 minutes
Data Manipulation in SQL10 minutes
You Try It! Practicing Data Manipulation in SQL - Answer Key10 minutes
Combining Data with SQL JOIN Clauses15 minutes
Working with SQL Functions and Aggregate Functions10 minutes
You Try It! Implementing SQL Functions and Aggregate Functions - Answer Key10 minutes

6 assignmentsTotal 145 minutes

Practice Quiz: Introduction to SQL Syntax and Basic Commands15 minutes
Practice Quiz: Retrieving Data with SELECT Statements20 minutes
Practice Quiz: Data Manipulation in SQL25 minutes
Practice Quiz: Combining Data with SQL JOIN Clauses15 minutes
Practice Quiz: Working with SQL Functions and Aggregate Functions20 minutes
Graded Quiz: Basics of SQL50 minutes

3 ungraded labsTotal 180 minutes

You try It! Writing SELECT Statements60 minutes
You Try It! Practicing Data Manipulation in SQL60 minutes
You Try It! Implementing SQL Functions and Aggregate Functions60 minutes

3 plugins

Guided Lab: Writing SELECT Statements0 minutes
Guided Lab: Practicing Data Manipulation in SQL0 minutes
Guided Lab: Implementing SQL Functions and Aggregate Functions0 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 videosTotal 71 minutes

Introduction: Advanced Data Handling2 minutes
Introduction to Subqueries and Common Table Expressions (CTEs)7 minutes
Advanced Filtering and Query Techniques9 minutes
Introduction to SQL Performance Tuning4 minutes
Techniques for Optimizing SQL Queries5 minutes
Introduction to SQL Transactions6 minutes
Concurrency Control in SQL8 minutes
Introduction to Stored Procedures and Functions5 minutes
Creating and Managing Stored Procedures and Functions6 minutes
Advanced SQL, Transactions, and Stored Procedures8 minutes
Introduction to SQL Database Security5 minutes
Protecting Against SQL Injection and Other Attacks4 minutes
Conclusion: Advanced Data Handling2 minutes

7 readingsTotal 95 minutes

Mastering Advanced SQL Query Techniques10 minutes
Introduction to SQL Performance Tuning10 minutes
Techniques for Optimizing SQL Queries30 minutes
Managing Transactions and Concurrency in SQL10 minutes
Leveraging Stored Procedures and Functions in SQL15 minutes
You Try It! Advanced SQL, Transactions, and Stored Procedures - Answer Key10 minutes
Securing SQL Databases10 minutes

6 assignmentsTotal 130 minutes

Practice Quiz: Mastering Advanced SQL Query Techniques20 minutes
Practice Quiz: SQL Query Performance Tuning and Optimization15 minutes
Practice Quiz: Managing Transactions and Concurrency in SQL15 minutes
Practice Quiz: Leveraging Stored Procedures and Functions in SQL15 minutes
Practice Quiz: Securing SQL Databases15 minutes
Graded Quiz: Advanced Data Handling50 minutes

1 ungraded labTotal 60 minutes

You Try It! Advanced SQL, Transactions, and Stored Procedures60 minutes

1 pluginTotal 15 minutes

Guided Lab: Advanced SQL, Transactions, and Stored Procedures15 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 videosTotal 25 minutes

Introduction: Writing SQL Queries with Microsoft Copilot1 minute
Introduction to Microsoft Copilot for SQL Query Writing8 minutes
Advanced SQL Query Capabilities of Microsoft Copilot8 minutes
Introduction to SQL Query Debugging and Optimization with Microsoft Copilot7 minutes
Course Conclusion: Database Integration and Management2 minutes

1 readingTotal 10 minutes

Writing SQL Queries with Microsoft Copilot10 minutes

3 assignmentsTotal 90 minutes

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

1 peer reviewTotal 60 minutes

Capstone Project Overview and Requirements60 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

302 Courses2,541,960 learners

Offered by

Microsoft

Database Integration and Management

Database Integration and Management

Skills you'll gain

Tools you'll learn

Details to know

Build your subject-matter expertise

There are 4 modules in this course

Introduction to EF Core and Relational Databases

What's included

Basics of SQL

What's included

Advanced Data Handling

What's included

Using Microsoft Copilot for Generating SQL Queries and Database Operations

What's included

Earn a career certificate

Instructor

Offered by

Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

Learner reviews

Frequently asked questions

When will I have access to the lectures and assignments?

What will I get if I subscribe to this Certificate?