Educative: Interactive Courses for Software Developers

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

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

How You'll Learn

You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.

Videos are holding you back. Educative‘s interactive, text-based lessons accelerate learning — no setup, downloads, or alt-tabbing required.

Learn faster and smarter with adaptive AI tools embedded in every Educative course.

Built-in assessments let you test your skills. Completion certificates let you show them off.

Frequently Asked Questions

How do I start learning SQL?

You can start learning SQL by following these steps:

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

BEFORE STARTING THIS COURSE

AFTER FINISHING THIS COURSE

An Introductory Guide to SQL