Course

CMCR01 - SQL for Data Querying

Unlock the power of data with this hands-on course designed specifically for aspiring data scientists. Learn the essentials of SQL using MySQL and gain the skills needed to efficiently query, manipulate, and analyze data. This course focuses on the foundational SQL concepts crucial for data analysis and machine learning, without delving into advanced database topics. By the end, you’ll be able to extract meaningful insights from datasets and confidently apply SQL in real-world data science projects.
No Prior Knowledge Needed
This course is for the beginners. We start from the basics and guide you step by step.
Swaminathan R
Trainer and Solution Architect
Share This Page
Highlights
Learning Curriculum

Course Highlights at a Glance

Explore the key features that make this course stand out — structured learning, practical skill-building, expert guidance, and up-to-date content to help you stay ahead.

Understand Databases from Scratch – Learn core database concepts and the role of SQL in data science
Master Data Retrieval – Write efficient SELECT queries to extract meaningful insights.
Work Across Multiple Tables – Use joins to combine data and uncover hidden patterns
Aggregate and Summarize Data – Group, filter, and compute metrics for informed decisions.
Modify Data Confidently – Insert, update, and delete records without errors.
Build Advanced Queries for Analytics – Leverage CASE statements, subqueries, and window functions to answer complex questions
Use Common Table Expressions (CTEs) – Simplify complex queries and make analytics more readable

Comprehensive Course Curriculum

Gain in-depth knowledge through a well-structured curriculum with chapters and lessons designed by experts. Test your understanding with assessments and earn a recognized certification upon completion.

Master the Skills
Test Your Knowledge
Certification
Relational Database Concepts: Tables, Rows, Columns, Keys(08 Mins)
Video - SQL Unlocked - Gateway to Data Mastery(04 Mins)
Why SQL Is a Must-Have Skill for Every Data Professional(16 Mins)
Introduction to Databases and MySQL(15 Mins)
Relational Database Concepts(15 Mins)
Installing MySQL Database and Workbench(11 Mins)
Configuring MySQL(07 Mins)
Understanding the MySQL WorkBench(07 Mins)
Creating Database(08 Mins)
Creating Tables(10 Mins)
Inserting Data into Tables (INSERT INTO)(07 Mins)
Practice Time(30 Mins)
Setting Up MySQL for Data Analysis and BI Work(15 Mins)
Getting Started with MySQL Workbench for Data Analysis(15 Mins)
Configuring MySQL for Reliable Data Analysis(15 Mins)
Understanding the MySQL WorkBench Video(01 Mins)
Creating Databases for Data Analysis and BI Projects(15 Mins)
Creating Tables: Structuring Data(15 Mins)
Inserting Data into Tables: Bringing Databases to Life(15 Mins)
Databases, Tables, and Data Insertion(15 Mins)
Lab Exercise: Building a Sales Database from Scratch(20 Mins)
Lab Solutions: Building a Sales Database from Scratch(30 Mins)
Basic SELECT Queries(04 Mins)
Filtering Data Using WHERE Clause(10 Mins)
Sorting Data with ORDER BY(07 Mins)
Limiting Results with LIMIT(06 Mins)
Practice Time(30 Mins)
Basic SELECT Queries: Retrieving Data for Analysis(15 Mins)
Filtering Data with the WHERE Clause: Focusing on What Matters(15 Mins)
Sorting Data with ORDER BY: Making Insights Easier to See(15 Mins)
Shaping Query Results for Analysis: From Raw Data to Insight-Ready Output(15 Mins)
Filtering with Multiple Conditions: Asking Better Questions with AND, OR, and NOT(15 Mins)
Practical Filtering Techniques: IN, BETWEEN, and LIKE(15 Mins)
Writing Clean and Readable SELECT Queries: SQL That Thinks Like an Analyst(20 Mins)
Lab Exercise: Data Retrieval and Analysis Using SELECT(20 Mins)
Self-Review Quiz: SQL Foundations & Data Retrieval(15 Mins)
Introduction to Table Joins(06 Mins)
INNER JOIN and LEFT JOIN(06 Mins)
RIGHT JOIN and FULL OUTER JOIN(04 Mins)
CROSS JOIN and SELF JOINS(06 Mins)
Practice Time(40 Mins)
Introduction to Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)(10 Mins)
Grouping Data with GROUP BY(15 Mins)
Filtering Grouped Results with HAVING(15 Mins)
Introduction to Table Relationships and JOIN Concepts(15 Mins)
Combining Tables with INNER JOIN(15 Mins)
Using LEFT JOIN for Complete Data Analysis(15 Mins)
Using RIGHT JOIN and FULL OUTER JOIN for Complete Relationship Analysis(15 Mins)
Handling NULL Values in Aggregations and Joins(15 Mins)
Building Analytical Reports by Combining GROUP BY and JOIN(15 Mins)
Self-Review Quiz: Aggregations, Grouping & Multi-Table Insights(20 Mins)
Aggregate Functions: COUNT, SUM, AVG, MIN, MAX(09 Mins)
Grouping Data with GROUP BY(09 Mins)
Filtering Groups with HAVING(09 Mins)
Practice Time(40 Mins)
Introduction to Data Modification in SQL(10 Mins)
Updating Records Using UPDATE(15 Mins)
Deleting Records Using DELETE(15 Mins)
Understanding the Risks of Data Modification(15 Mins)
Using WHERE Safely in UPDATE and DELETE(15 Mins)
Introduction to Transactions (COMMIT and ROLLBACK)(15 Mins)
Ensuring Data Integrity with Transaction Management(15 Mins)
Practical Scenarios – Safe Data Modification in Real Systems(20 Mins)
Updating Data (UPDATE)(07 Mins)
Deleting Records (DELETE)(10 Mins)
Transaction Management(08 Mins)
Practice Time(40 Mins)
Foundations of Data Cleaning in SQL(15 Mins)
Handling Missing Data and Standardizing Text(15 Mins)
Data Type Conversion and Date Transformations(15 Mins)
Creating Derived Features and Conditional Transformations(15 Mins)
Removing Duplicates and Building Clean Analytical Datasets(15 Mins)
Subqueries and Nested Queries(10 Mins)
Using CASE Statements for Conditional Logic(08 Mins)
Window Functions (ROW_NUMBER, RANK, PARTITION BY)(11 Mins)
Common Table Expressions (CTEs)(06 Mins)
Optimizing Queries for Performance(07 Mins)
Practice Time(40 Mins)
Introduction to Subqueries and Single-Value Subqueries(15 Mins)
Subqueries with IN, EXISTS, and NOT EXISTS(15 Mins)
Correlated Subqueries(15 Mins)
Subqueries in SELECT and FROM (Scalar Subqueries and Derived Tables)(15 Mins)
Bringing it All Together(20 Mins)
Introduction to Window Functions and the OVER() Clause(15 Mins)
Ranking Functions (ROW_NUMBER, RANK, DENSE_RANK)(15 Mins)
Aggregate Window Functions (Running Totals and Moving Averages)(15 Mins)
Advanced Window Functions (LAG, LEAD, FIRST_VALUE, LAST_VALUE)(15 Mins)
Practical Analytical Reporting Using Window Functions(15 Mins)
Self Review Quiz 1(20 Mins)
Self-Review Quiz Data Cleaning, Subqueries & Window Functions(20 Mins)
Exemplar: Retail Performance Intelligence System(45 Mins)
Course Wrap-Up: SQL Fundamentals for Data Science with MySQL(15 Mins)
SQL in the Modern Data Ecosystem – From Relational Databases to Big Data Platforms(15 Mins)

CMCR01 - SQL for Data Querying CMCR01 - SQL for Data Querying

Pay ₹1799
₹999/-
(Including 18% GST)
Begin Your Learning Journey!Register Now
Copyright © 2020 - 2025 Learnovate Academy Private Limited