Data Science & AI intermediate

Database Systems & SQL

A comprehensive course covering Databases. Topics include SQL queries, joins, aggregations, window functions, database design, PostgreSQL, data warehousing, ETL processes, and database optimization. Designed for intermediate level learners.

10 hours 3 modules 12 lessons 0 enrolled
Dr
Dr. Priya Patel
Professor of Data Science & Artificial Intelligence
Free

Full access to all course materials

Course Content

Foundations of Aggregations 4 lessons
SQL Queries 32 min
Joins 21 min
Aggregations 32 min
Applying SQL Queries 35 min
Understanding Window Functions 4 lessons
Window Functions 21 min
Database Design 24 min
PostgreSQL 29 min
Applying Window Functions 26 min
Working with Database Optimization 4 lessons
Data Warehousing 31 min
ETL Processes 23 min
Database Optimization 21 min
Applying Data Warehousing 32 min