Home>Courses>An Introductory Guide to SQL

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

Mock Interview

Explanations

AI-POWERED

Mock Interview

Explanations

This course includes

73 Playgrounds
78 Quizzes
Course Overview
Course Content
Recommendations

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

Course Content

1.

Introduction

3 Lessons

Get familiar with SQL’s evolution, relational vs non-relational databases, and MySQL's architecture.
Introduction
Relational vs Non-Relational
MySQL History & Architecture

3.

Joins

6 Lessons

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

4.

Nested Queries

5 Lessons

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

5.

Multi Table Operations

4 Lessons

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

6.

Views

5 Lessons

See how it works with SQL views creation, data integrity, updating, and management techniques.
Creating a View
Updating a View
With Check Option
Local & Cascaded Check
Drop, Show, & Rename Views

7.

Stored Procedures

10 Lessons

Piece together the parts of stored procedures, variables, parameters, statements, cursors, error handling, and functions in SQL.
What are Stored Procedures?
Create, Delete, and Alter a Stored Procedure
Variables
Parameters
Conditional Statements
Iterative Statements
Cursors
Error Handling
SIGNAL and RESIGNAL
Stored Functions

8.

Triggers

6 Lessons

Learn how to use SQL triggers for data integrity, logging, archiving, and managing multiple actions.
What are Triggers?
Create and Delete a Trigger
INSERT Triggers
UPDATE Triggers
DELETE Triggers
Multiple Triggers

9.

Miscellaneous

3 Lessons

Discover the logic behind transactions, EXPLAIN statement, and foreign keys for data integrity.
Transaction
EXPLAIN
Foreign Keys

11.

Epilogue

1 Lessons

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

Course Author

Trusted by 2.5 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."

Carlos Matias La Borde

Software Developer

"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

"I've tried probably 5-7 different sites and Educative is easily the best. It perfectly blends explanation with interactivity"

Eric Downs

Musician/Entrepeneur

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

Recommended before starting this course

Related Courses and Skill Paths

Free Resources

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

Learn in-demand tech skills in half the time

PRODUCTS

Mock Interview

New

Courses

Cloud Labs

Skill Paths

Projects

Assessments

TRENDING TOPICS

Learn to Code

Tech Interview Prep

Generative AI

Data Science

Machine Learning

GitHub Students Scholarship

Early Access Courses

Blind 75

Pricing

For Individuals

Try for Free

Gift a Subscription

CONTRIBUTE

Become an Author

Become an Affiliate

Earn Referral Credits

RESOURCES

Blog

Cheatsheets

Webinars

Answers

ABOUT US

Our Team

Careers

Hiring

Frequently Asked Questions

Contact Us

Press

LEGAL

Privacy Policy

Cookie Policy

Terms of Service

Business Terms of Service

Data & Privacy

Data Processing Agreement

INTERVIEW PREP COURSES

Grokking the Modern System Design Interview

Grokking the Product Architecture Design Interview

Grokking the Coding Interview Patterns

Machine Learning System Design

Copyright ©2024 Educative, Inc. All rights reserved.

soc2