Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Relational Database Design and Advanced Querying

Microsoft via Coursera

Go to class Write review

Details

Go to class

Provider

Coursera
Pricing

Paid Course
Languages

English
Certificate

Certificate Available
Effort

4 weeks, 5 hours a week
Sessions

Self-Paced
Level

Beginner
Subtitles

English, Kazakh, German, Pashto, Korean, Portuguese, Italian, French, Hungarian, Spanish, Arabic, Japanese, Farsi

Found in

Part of

Microsoft SQL Server

Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Unlock All Certificates

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.

Syllabus

Fundamentals of Relational Database Design
- 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.
Advanced Query Techniques
- 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.
Designing and Implementing Database Schemas
- 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.
Data Warehousing and Business Intelligence with SQL Server
- 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.