This course will help you gain an understanding of the core concepts of databases and SQL, gain practical experience writing simple SQL queries to filter, manipulate, and retrieve data from relational databases, and utilize complex SQL queries with joins, window functions, and subqueries for data extraction and manipulation to solve real-world data problems and extract actionable business insights.
SQL is a widely used querying language for efficiently managing and manipulating relational databases. This module provides an essential foundation for understanding and working with relational databases. Participants will explore the principles of database management and Structured Query Language (SQL), and learn how to fetch, filter, and aggregate data using SQL queries, enabling them to extract valuable insights from large datasets efficiently.
(Introduction to Databases and SQL, Fetching data, Filtering data, Aggregating data)
SQL offers a wide range of numeric, string, and date functions, gaining proficiency in leveraging these functions to perform advanced calculations, string manipulations, and date operations. SQL joins are used to combine data from multiple tables effectively and window functions enable performing complex analytical tasks such as ranking, partitioning, and aggregating data within specified windows. This module provides a comprehensive exploration of the various functions and joins available within SQL for data manipulation and analysis, enabling them to summarize and analyze large datasets effectively.
(In-built functions (Numeric, Datetime, Strings), Joins, Window functions)
Subqueries allow one to nest queries within other queries, enabling more complex and flexible data manipulation. This module will equip participants with advanced techniques for filtering data based on conditional expressions or calculating derived values to extract and manipulate data dynamically.
(Subqueries, Order of query execution)