Relational Database Design and Advanced Querying

Labor Day starts with $70+ in savings on Coursera Plus. Save 40% for 3 months.

Relational Database Design and Advanced Querying

This course is part of Microsoft SQL Server Professional Certificate

Instructor: Microsoft

4,532 already enrolled

Included with Learn more

Ask Coursera

4 modules

Gain insight into a topic and learn the fundamentals.

11 reviews

Beginner level

Recommended experience

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

11 reviews

Beginner level

Recommended experience

2 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

12 assignments

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 Data Analysis expertise

This course is part of the Microsoft SQL Server Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

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

Develop expertise in relational database design principles and implementation using SQL Server. This course teaches normalization techniques, entity-relationship modeling, and schema optimization to create efficient database structures. You'll use DDL (Data Definition Language) statements to build and modify database objects while enforcing data integrity through constraints. The advanced querying section covers complex joins, subqueries, CTEs, and aggregate functions that enable sophisticated data analysis. You'll also explore data warehousing concepts and learn to leverage GenAI to assist with complex query development from natural language descriptions. By the end of this course, you'll be able to design normalized databases from scratch and write advanced queries that extract meaningful insights from complex data structures.

In this module, you will explore the principles of relational database design and their role in building efficient, reliable databases. You will explain the importance of relational database design, evaluate database schemas using design principles, implement primary and foreign key constraints to maintain data integrity, and apply normalization techniques to reduce redundancy and optimize database performance.

What's included

5 videos12 readings3 assignments

5 videosTotal 22 minutes

Welcome to Relational Database Design and Advanced Querying2 minutes
Real-World Impacts of Database Design2 minutes
Implementing Relational Database Design Concepts6 minutes
Validating Table Details and Constraints3 minutes
Applying Normalization to TechHealth's Datasets7 minutes

12 readingsTotal 140 minutes

Course Structure and Learning Outcomes5 minutes
Course Accessibility Information10 minutes
Setting up SQL Server and SSMS10 minutes
Setting Up the TechHealth Database10 minutes
Overview of Relational Database Design10 minutes
DiscountTech Database Code File5 minutes
Analyze TechHealth Analytics' Existing Database Setup15 minutes
Understanding Key Constraints for Data Integrity15 minutes
DiscountTech Data Code File5 minutes
Applying Data Integrity with Key Constraints to TechHealth's Datasets15 minutes
Normalization and its Applications15 minutes
Normalize Sample Datasets from TechHealth Analytics25 minutes

3 assignmentsTotal 60 minutes

Database Design Fundamentals15 minutes
Understanding and Applying Key Constraints15 minutes
Principles of Normalization30 minutes

In this module, you will develop advanced SQL querying skills for retrieving, summarizing, and analyzing data across multiple tables. You will construct queries using joins and subqueries, apply aggregate functions and grouping techniques, evaluate and optimize SQL queries using execution plans and indexing strategies, and use performance-driven querying techniques to support efficient analysis in large-scale relational databases.

What's included

4 videos6 readings3 assignments

4 videosTotal 17 minutes

Leveraging Multi-Join SQL Queries to Gain Business Insights1 minute
Building Multi-Join Queries with Joins and Subqueries5 minutes
Applying Aggregate Functions and GROUP BY for Reporting3 minutes
Analyzing and Improving Query Execution Plans8 minutes

6 readingsTotal 120 minutes

Learn to Master Advanced SQL Joins and Subqueries20 minutes
Use Joins and Subqueries to Consolidate and Analyze TechHealth's Data25 minutes
Using Aggregate Functions and Grouping for Reporting15 minutes
Generate Data Summaries Using Aggregate Functions for TechHealth Analytics20 minutes
SQL Query Optimization Techniques15 minutes
Optimize Queries to Improve the Performance of TechHealth's Database25 minutes

3 assignmentsTotal 90 minutes

Advanced Joins and Subqueries in SQL30 minutes
Assessing Practical Usage of Aggregate Functions30 minutes
Assess the Principles of Query Optimization30 minutes

In this module, you will learn how to design and maintain database schemas that support evolving business requirements. You will apply Data Definition Language (DDL) commands to create and modify database objects, evaluate and refine schemas for efficiency, implement relational constraints to enforce data integrity, and use Generative AI techniques to assist with schema design and relational rule enforcement.

What's included

5 videos6 readings3 assignments1 ungraded lab

5 videosTotal 20 minutes

Creating Streamlined Data Structures2 minutes
Creating and Modifying DiscountTech Database Schemas6 minutes
Implementing Relational Constraints in SQL Server6 minutes
Using GenAI for Innovative Database Design2 minutes
Applying GenAI to Automate and Optimize Schema Design5 minutes

6 readingsTotal 85 minutes

DDL Operations and Schema Design15 minutes
Design and Modify a Schema for TechHealth's Operational Needs20 minutes
Relational Constraints and their Applications15 minutes
Apply Constraints to Enhance TechHealth Data Integrity15 minutes
The Role of AI Tools in Database Schema Design10 minutes
Accessing GitHub for Copilot10 minutes

3 assignmentsTotal 90 minutes

DDL Command Usage and Schema Management30 minutes
Techniques for Relational Constraint Implementation30 minutes
GenAI's Role in Modern Database Schema Design30 minutes

1 ungraded labTotal 60 minutes

Design a Schema Using GenAI for TechHealth Analytics60 minutes

In this module, you will explore how data warehouses support business intelligence and analytics. You will explain the purpose and structure of data warehouses, describe star schema modeling, query warehouse data to extract business insights, integrate SQL Server with Power BI to visualize trends and performance, and apply analytical outputs to support strategic decision-making.

What's included

4 videos9 readings3 assignments

4 videosTotal 21 minutes

Transforming Data into Insights with Data Warehousing2 minutes
Building a Data Warehouse in SQL Server4 minutes
SQL for Data Warehousing: From Basics to Advanced Analytics8 minutes
Power BI Workflows: Connecting, Visualizing, and Presenting Data7 minutes

9 readingsTotal 150 minutes

Understanding OLTP and OLAP15 minutes
Introduction to Star Schema15 minutes
Create a Star Schema and Run a Basic Extract, Transform, Load (ETL) Process25 minutes
Comprehensive Guide to Data Warehouse Querying10 minutes
Integrated Data Warehouse Query Challenge25 minutes
Power BI: Visualizing and Presenting Data Insights10 minutes
Connecting to Power BI15 minutes
Integrated Power BI Challenge25 minutes
Wrapping Up and Looking Ahead10 minutes

3 assignmentsTotal 90 minutes

Database Systems and Star Schema Fundamentals30 minutes
Data Warehouse Querying, Time Analysis, and Techniques Assessment30 minutes
Power BI Mastery Assessment30 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

420 Courses2,801,254 learners

Offered by

Microsoft

Explore more from Data Analysis

Status: Free Trial
Coursera
Advanced Relational Database and SQL
Guided Project
Status: Free Trial
Coursera
Design & Optimize SQL Database Schemas
Course
Status: Free Trial
Illinois Tech
Relational Database Design
Course
Status: Free Trial
Coursera
Mastering Advanced SQL Queries
Course

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

Break down barriers to learning with big savings
Get Coursera Plus
Start with easy savings for hard-working teams
Save 30% today

Frequently asked questions

To access course materials, assignments, and earn a Certificate, you'll need to purchase the Certificate experience when you enroll in a course. Eligible learners may also have the option to start with a Free Trial. Some courses may also offer a Full Course, No Certificate option. This lets you access course materials, submit required assessments, and receive a final grade, but you won't be able to earn or purchase a 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.