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
Database Integration and Management
This course is part of multiple programs.
Instructor: Microsoft
Access provided by New York State Department of Labor
Gain insight into a topic and learn the fundamentals.
Beginner level
Recommended experience
27 hours to complete
3 weeks at 9 hours a week
Flexible schedule
Learn at your own pace
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
22 assignments
Taught in English
Recently updated!
January 2025
See how employees at top companies are mastering in-demand skills
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
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There are 4 modules in this course
In this module, you鈥檒l explore the core features of a powerful tool for working with relational databases. You鈥檒l learn about relational database structure, how to set one up, and the principles behind it. You鈥檒l also discover how to model data and perform essential CRUD (Create, Read, Update, Delete) operations efficiently. By the end, you鈥檒l have the skills to manage data effectively in your projects.
What's included
20 videos11 readings7 assignments3 ungraded labs3 plugins
In this module, you鈥檒l dive into the fundamentals of SQL, learning its basic syntax and key functionalities. You鈥檒l 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鈥檒l explore essential SQL and aggregate functions to perform powerful data operations easily. By the end, you鈥檒l be equipped to manage and query databases effectively.
What's included
15 videos9 readings6 assignments3 ungraded labs3 plugins
In this module, you鈥檒l build on your SQL knowledge with advanced query techniques and learn how to optimize query performance. You鈥檒l explore transactions and concurrency control to ensure data integrity and discover how to use stored procedures and functions for efficient database operations. Additionally, you鈥檒l learn essential security best practices to protect your SQL databases. By the end, you鈥檒l be ready to handle complex database challenges confidently.
What's included
13 videos7 readings6 assignments1 ungraded lab1 plugin
In this module, you鈥檒l harness the power of Microsoft Copilot to streamline your SQL workflow. You鈥檒l 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鈥檒l be equipped to leverage AI assistance for efficient and accurate database management.
What's included
5 videos1 reading3 assignments1 peer review
Why people choose 糖心vlog官网观看 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, 糖心vlog官网观看 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. 糖心vlog官网观看 allows me to learn without limits."
Explore more from Computer Science
University of Colorado System
Akamai Technologies, Inc.
Illinois Tech
Open new doors with 糖心vlog官网观看 Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose 糖心vlog官网观看 for Business
Upskill your employees to excel in the digital economy