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!
The ability to work SQL is becoming an increasingly in-demand skill, both for software developers and people in less technical r...Show More
Content
1.
Introduction
3 Lessons
Get familiar with SQL’s evolution, relational vs non-relational databases, and MySQL's architecture.
2.
Basic SQL
26 Lessons
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
6 Lessons
Break apart SQL joins, including inner, outer, self, left, right, and natural joins.
4.
Nested Queries
5 Lessons
Break down complex ideas in nested scalar, column, row queries, EXISTS and correlated queries.
5.
Multi Table Operations
4 Lessons
Dig into multi-table delete and update operations, SELECT/INSERT efficiency, and the REPLACE command.
6.
Views
5 Lessons
See how it works with SQL views creation, data integrity, updating, and management techniques.
7.
Stored Procedures
10 Lessons
Piece together the parts of stored procedures, variables, parameters, statements, cursors, error handling, and functions in SQL.
8.
Triggers
6 Lessons
Learn how to use SQL triggers for data integrity, logging, archiving, and managing multiple actions.
9.
Miscellaneous
3 Lessons
Discover the logic behind transactions, EXPLAIN statement, and foreign keys for data integrity.
10.
Practice & Prep
29 Lessons
Go hands-on with SQL queries to enhance database management and data analysis skills.
11.
Epilogue
1 Lessons
Find out about giving feedback and acknowledging contributors to enhance course quality.
Certificate of Completion
Showcase your accomplishment by sharing your certificate of completion.
Course Author:
Developed by MAANG Engineers
Trusted by 2.8 million developers working at companies
"These are high-quality courses. Trust me. I own around 10 and the price is worth it for the content quality. EducativeInc came at the right time in my career. I'm understanding topics better than with any book or online video tutorial I've done. Truly made for developers. Thanks"
Anthony Walker
@_webarchitect_
"Just finished my first full #ML course: Machine learning for Software Engineers from Educative, Inc. ... Highly recommend!"
Evan Dunbar
ML Engineer
"You guys are the gold standard of crash-courses... Narrow enough that it doesn't need years of study or a full blown book to get the gist, but broad enough that an afternoon of Googling doesn't cut it."
Software Developer
Carlos Matias La Borde
"I spend my days and nights on Educative. It is indispensable. It is such a unique and reader-friendly site"
Souvik Kundu
Front-end Developer
"Your courses are simply awesome, the depth they go into and the breadth of coverage is so good that I don't have to refer to 10 different websites looking for interview topics and content."
Vinay Krishnaiah
Software Developer
Hands-on Learning Powered by AI
See how Educative uses AI to make your learning more immersive than ever before.
AI Prompt
Code Feedback
Explain with AI
AI Code Mentor
Free Resources
Frequently Asked Questions
How do I start learning SQL?
