Home>
Courses>

An Introductory Guide to SQL

An Introductory Guide to SQL

Beginner

98 Lessons

13h

Certificate of Completion

AI-POWERED

Mock Interview
Explanations

AI-POWERED

Mock Interview
Explanations

This course includes

72 Playgrounds
78 Quizzes

This course includes

72 Playgrounds
78 Quizzes
Course Overview
Course Content

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

1.

Introduction

Introduction
Relational vs Non-Relational
MySQL History & Architecture
2.

Basic SQL

Exploring MySQL
Create Database
Data Types
Create Table
... continue
Temporary Table
Collations & Character Sets
Inserting Data
Querying Data
LIKE Operator
Combining Conditions
ORDER BY
LIMIT
Deleting Data
TRUNCATE
Updating Data
Primary Key and Indexes
... continued
Alterations
Alter Index
More on Alter
Alias
DISTINCT
Aggregate Methods
GROUP BY
HAVING
3.

Joins

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

Nested Queries

Nested Scalar Queries
Nested Column Queries
Nested Row Queries
EXISTS Operator
Correlated Queries
5.

Multi Table Operations

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

Views

5 Lessons

7.

Stored Procedures

10 Lessons

8.

Triggers

6 Lessons

9.

Miscellaneous

3 Lessons

10.

Practice & Prep

29 Lessons

11.

Epilogue

1 Lesson

Course Author

Trusted by 1.4 million developers working at companies

Anthony Walker

@_webarchitect_

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

Souvik Kundu

Front-end Developer

Eric Downs

Musician/Entrepeneur

Anthony Walker

@_webarchitect_

Evan Dunbar

ML Engineer

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

Adaptive Learning

Explain with AI

AI Code Mentor

Frequently Asked Questions

How do I start learning SQL?

You can start learning SQL by following these steps:

  1. Sign up for online courses if you prefer a more structured learning environment. These courses often provide a comprehensive overview of SQL
  2. Create your own database for practical experience. Regular practice with SQL queries on real-world datasets is invaluable
  3. Engage with problems available online to sharpen your skills
  4. Participate in online forums and communities. These platforms offer support, insights, and help in solving specific queries
  5. Attend SQL workshops and webinars, which can provide you with up-to-date knowledge and networking opportunities