AI-powered learning
Save this course
An Introductory Guide to SQL
Gain insights into SQL by exploring database creation, data manipulation, and advanced queries. Learn about practical applications and practice for SQL interviews to build confidence and readiness.
4.7
98 Lessons
13h
Updated 1 month ago
Join 3 million developers at
Join 3 million developers at
LEARNING OBJECTIVES
- Identify differences between relational and non-relational databases, schemas, and DBMS concepts
- Navigate MySQL by connecting, listing databases/tables, and inspecting schemas with SHOW and DESCRIBE
- Create and manage databases and tables using CREATE/DROP, data types, and constraints (PK, NOT NULL, DEFAULT)
- Insert, query, sort, and filter data using SELECT, WHERE, LIKE, logical operators, ORDER BY, and LIMIT/OFFSET
- Modify and remove data safely using UPDATE, DELETE, TRUNCATE, and multi-table update/delete statements
- Combine and analyze data with joins, UNION, subqueries (EXISTS, correlated), aggregates, GROUP BY, and HAVING
- Build database logic using views, stored procedures/functions, triggers, transactions, indexes, and EXPLAIN
Learning Roadmap
1.
Introduction
Introduction
Get familiar with SQL’s evolution, relational vs non-relational databases, and MySQL's architecture.
2.
Basic SQL
Basic SQL
Look at MySQL basics: databases, data types, tables, querying, and data manipulation.
Exploring MySQLCreate DatabaseData TypesCreate Table... continueTemporary TableCollations & Character SetsInserting DataQuerying DataLIKE OperatorCombining ConditionsORDER BYLIMITDeleting DataTRUNCATEUpdating DataPrimary Key and Indexes... continuedAlterationsAlter IndexMore on AlterAliasDISTINCTAggregate MethodsGROUP BYHAVING
3.
Joins
Joins
6 Lessons
6 Lessons
Break apart SQL joins, including inner, outer, self, left, right, and natural joins.
4.
Nested Queries
Nested Queries
5 Lessons
5 Lessons
Break down complex ideas in nested scalar, column, row queries, EXISTS and correlated queries.
5.
Multi Table Operations
Multi Table Operations
4 Lessons
4 Lessons
Dig into multi-table delete and update operations, SELECT/INSERT efficiency, and the REPLACE command.
6.
Views
Views
5 Lessons
5 Lessons
See how it works with SQL views creation, data integrity, updating, and management techniques.
7.
Stored Procedures
Stored Procedures
10 Lessons
10 Lessons
Piece together the parts of stored procedures, variables, parameters, statements, cursors, error handling, and functions in SQL.
8.
Triggers
Triggers
6 Lessons
6 Lessons
Learn how to use SQL triggers for data integrity, logging, archiving, and managing multiple actions.
9.
Miscellaneous
Miscellaneous
3 Lessons
3 Lessons
Discover the logic behind transactions, EXPLAIN statement, and foreign keys for data integrity.
10.
Practice & Prep
Practice & Prep
29 Lessons
29 Lessons
Go hands-on with SQL queries to enhance database management and data analysis skills.
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
The ability to work SQL is becoming an increasingly in-demand skill, both for software developers and people in less technical roles. If you’re interested in learning SQL and have no prior experience with it, then this course will be your light in a dark tunnel.
You’ll start by covering the basics of SQL such as how to create a database, how to insert, query, and update data. You’ll also learn fundamental concepts that developers and data scientists use everyday such as multi-table operations, nested queries, and how to set up views.
Throughout, you’ll get to execute SQL queries in your browser and see results in real-time - you won’t need to worry about set-up.
At the end of this course, you’ll also get some hands-on practice with common SQL interview questions, so when the time comes, you’ll be ready and confident to answer any question that comes your way. Let’s get started!
ABOUT THE AUTHOR
DataJek
A bay area tech outfit, throwing lots of good ideas on the wall to see what sticks!
Trusted by 3 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
