AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Learn modern SQL features and database technologies in this comprehensive database systems lecture from Carnegie Mellon University's Introduction to Database Systems course. Explore advanced SQL capabilities beyond basic queries, including window functions, common table expressions, JSON operations, and other contemporary database features that have evolved to meet modern application needs. Discover how SQL has adapted to handle complex analytical workloads and data processing tasks that were traditionally handled by specialized tools. The lecture covers practical implementations of these features across different database management systems and demonstrates their real-world applications. Additionally, gain insights into dbt (data build tool) through a specialized database flash talk by Drew Banin, exploring how modern data transformation tools leverage SQL for building reliable data pipelines and analytics workflows. Access supplementary materials including detailed slides and comprehensive notes to reinforce your understanding of modern SQL concepts and their practical applications in contemporary database systems.
