
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement testA free 15-lesson course built from Rishabh Mishra's 2h 35m of YouTube video. 2 days at 90 minutes a day, with study notes and a quiz in every lesson. A 2-minute placement test skips what you already know.
Taught by Rishabh Mishra on YouTube. Videos play in YouTube's own player, so the creator keeps every view.
Understand what SQL is, its applications, and how it differs from Excel.
Identify common SQL data types and define primary keys, foreign keys, and constraints.
Write CREATE DATABASE and CREATE TABLE statements with appropriate columns and data types.
Modify table data using INSERT, UPDATE, DELETE and change table structure with ALTER TABLE.
Retrieve specific data using SELECT with filtering conditions in the WHERE clause.
Apply built-in SQL functions, focusing on string manipulation functions like CONCAT, SUBSTRING, and UPPER.
Calculate summary values using aggregate functions such as COUNT, SUM, AVG, MIN, and MAX.
Group rows with GROUP BY and filter groups using the HAVING clause.
Work with date and time data types and extract specific parts using date functions.
Combine data from multiple tables using INNER, LEFT, RIGHT, and FULL OUTER JOINs.
Query hierarchical data with self-joins and combine result sets using UNION and UNION ALL.
Write subqueries in WHERE, FROM, and SELECT clauses to solve multi-step problems.
Perform calculations across row sets using window functions like ROW_NUMBER, RANK, and LEAD.
Implement conditional logic in queries using CASE expressions.
Simplify complex queries by defining temporary result sets with Common Table Expressions (CTEs).