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.

Beginner

98 Lessons

13h

Certificate of Completion

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.

AI-POWERED

Explanations

AI-POWERED

Explanations

This course includes

73 Playgrounds

78 Quizzes

This course includes

73 Playgrounds

78 Quizzes

Course Overview

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 queri...Show More

Course Content

Introduction

Get familiar with SQL’s evolution, relational vs non-relational databases, and MySQL's architecture.

Introduction Relational vs Non-Relational MySQL History & Architecture

Basic SQL

Look at MySQL basics: databases, data types, tables, querying, and data manipulation.

Joins

Break apart SQL joins, including inner, outer, self, left, right, and natural joins.

Types of Joins Self Inner Join Inner Join Union Left and Right Joins Natural Join

Nested Queries

Break down complex ideas in nested scalar, column, row queries, EXISTS and correlated queries.

Nested Scalar Queries Nested Column Queries Nested Row Queries EXISTS Operator

Correlated Queries

Multi Table Operations

Dig into multi-table delete and update operations, SELECT/INSERT efficiency, and the REPLACE command.

Multi-Table Delete Multi-Table Update SELECT and INSERT REPLACE

Views

5 Lessons

See how it works with SQL views creation, data integrity, updating, and management techniques.

Stored Procedures

10 Lessons

Piece together the parts of stored procedures, variables, parameters, statements, cursors, error handling, and functions in SQL.

Triggers

6 Lessons

Learn how to use SQL triggers for data integrity, logging, archiving, and managing multiple actions.

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 Lesson

Find out about giving feedback and acknowledging contributors to enhance course quality.

Course Author

Trusted by 1.4 million developers working at companies

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Evan Dunbar

ML Engineer

Carlos Matias La Borde

Software Developer

Souvik Kundu

Front-end Developer

Vinay Krishnaiah

Software Developer

Eric Downs

Musician/Entrepeneur

Kenan Eyvazov

DevOps Engineer

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Hands-on Learning Powered by AI

See how Educative uses AI to make your learning more immersive than ever before.

Instant Code Feedback

Evaluate and debug your code with the click of a button. Get real-time feedback on test cases, including time and space complexity of your solutions.

AI-Powered Mock Interviews

Put your skills to the test in a simulated interview setting. Receive personalized feedback based on your performance. Available in Premium & Premium Plus plans.

Adaptive Learning

At various checkpoints throughout Educative courses, you will be prompted to take a quick assessment. Receive a condensed curriculum tailored to your strengths and skill gaps.

Explain with AI

Select any text within any Educative course, and get an instant explanation — without ever leaving your browser.

AI Code Mentor

AI Code Mentor helps you quickly identify errors in your code, learn from your mistakes, and nudge you in the right direction — just like a 1:1 tutor!