This course covers intermediate SQL concepts like SQL queries, SELECT query, SQL WHERE, SQL DISTINCT, SQL GROUP BY, SQL ORDER BY, SQL aggregate functions, SQL joins, and SQL subqueries.
4.5
28 Lessons
3h
Updated today
Join 2.9 million developers at
Join 2.9 million developers at
LEARNING OBJECTIVES
- An understanding of the declarative nature of SQL and its core principles
- The ability to formulate SQL queries using SELECT query, SQL WHERE, and SQL DISTINCT
- Hands-on experience building queries with SQL GROUP BY, SQL ORDER BY, and SQL aggregate functions to uncover crucial information
- The ability to create, update, and delete data within tables
- The ability to extract and manipulate data across multiple tables using SQL joins and SQL subqueries
Learning Roadmap
1.
Introduction to SQL
Introduction to SQL
In this chapter, you’ll learn SQL queries and the SELECT query in an introduction to SQL, and how to interact with a relational database.
2.
SQL SELECT
SQL SELECT
In this chapter, you’ll master SQL SELECT and SQL DISTINCT to eliminate duplicates, ensuring you retrieve accurate and unique data from your database.
3.
SQL Queries: SELECT, WHERE, AND, OR, NOT, and Strings
SQL Queries: SELECT, WHERE, AND, OR, NOT, and Strings
3 Lessons
3 Lessons
In this chapter, learn to filter data using SQL SELECT WHERE, handle SQL Strings, and combine conditions with SQL AND, SQL OR, SQL NOT for query results.
4.
SQL ORDER BY, Aggregate functions, and GROUP BY
SQL ORDER BY, Aggregate functions, and GROUP BY
3 Lessons
3 Lessons
In this chapter, learn data sorting with SQL ORDER BY, perform calculations using SQL aggregate functions, and organize query results with SQL GROUP BY.
5.
SQL CREATE, DESCRIBE, INSERT INTO, UPDATE and DELETE Tables
SQL CREATE, DESCRIBE, INSERT INTO, UPDATE and DELETE Tables
3 Lessons
3 Lessons
In this chapter, create tables with SQL CREATE TABLE, add data using SQL INSERT INTO, modify records with SQL UPDATE, and remove them using SQL DELETE.
6.
SQL Alter Table and Aliases
SQL Alter Table and Aliases
5 Lessons
5 Lessons
In this chapter, modify database structures using SQL ALTER TABLE and simplify query readability with SQL aliases for table and column names.
7.
Data Redundancy
Data Redundancy
4 Lessons
4 Lessons
In this chapter, minimize data redundancy by using SQL foreign keys to establish relationships between tables to ensure data integrity and management.
8.
SQL Joins and Subqueries
SQL Joins and Subqueries
5 Lessons
5 Lessons
In this chapter, learn SQL joins and subqueries to retrieve related data, while understanding the implications of the SQL cartesian product in queries.
Certificate of Completion
Showcase your accomplishment by sharing your certificate of completion.
Complete more lessons to unlock your certificate
Developed by MAANG Engineers
ABOUT THIS COURSE
In this course, you will explore Structured Query Language (SQL), mastering its core concepts through hands-on projects.
You’ll start with fundamental SQL queries like SELECT query, SQL WHERE, etc. and gradually progress to using SQL DISTINCT, SQL GROUP BY, SQL ORDER BY, and SQL aggregate functions. You'll learn how to create and manage tables, compute new fields, and optimize data relationships using foreign keys.
By the end, you will be adept at using SQL joins, SQL subqueries, and merging techniques to generate comprehensive reports.
Trusted by 2.9 million developers working at companies
A
Anthony Walker
@_webarchitect_
E
Evan Dunbar
ML Engineer
S
Software Developer
Carlos Matias La Borde
S
Souvik Kundu
Front-end Developer
V
Vinay Krishnaiah
Software Developer
Built for 10x Developers
No Passive Learning
Learn by building with project-based lessons and in-browser code editor
Personalized Roadmaps
The platform adapts to your strengths & skills gaps as you go
Future-proof Your Career
Get hands-on with in-demand skills
AI Code Mentor
Write better code with AI feedback, smart debugging, and "Ask AI"
MAANG+ Interview Prep
AI Mock Interviews simulate every technical loop at top companies
Free Resources
