author-cover
INTERACTIVE COURSE

Getting Started with SQL and Relational Databases

Beginner

62 Lessons

9h 40min

Certificate of Completion

author-cover
108 Playgrounds
8 Quizzes
60 Illustrations

Takeaway Skills

Get a strong understanding of relational databases and Structured Query Language (SQL).

Get a working knowledge of creating, managing, and transforming a MySQL data table.

Learn to create and leverage indexes to quickly access data within a database.

Learn to filter, limit, group, and order a database using SQL queries.

Learn to merge multiple tables into a single database using advanced SQL functions.

Get hands-on experience to create, manage, sort, filter, and edit a MySQL database.

Course Overview

Relational databases store data in a row-based table structure. Structured Query Language (SQL) is a core language used to retrieve data from the relational database. One of its most widely used extensions, MySQL, also gives you the power to edit, create, and manage...Show More

Course Content

1

Getting Started

6 Lessons

Show all 6 lessons
2

Manage MySQL Server

4 Lessons

3

Basic SQL Commands

12 Lessons

4

Add Columns and Indexes

9 Lessons

5

Count and Sort Records

8 Lessons

6

Foreign Keys

10 Lessons

7

Joins, Left Joins And Subqueries

12 Lessons

8

Conclusion

1 Lesson

How You'll Learn

Hands-on Coding Environments

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.

2x Faster Than Videos

Videos are holding you back. The average video tutorial is spoken at 150 words per minute, while you can read at 250. That‘s why our courses are text-based.

No Set-up Required

Start learning immediately instead of fiddling with SDKs and IDEs. It‘s all on the cloud.

Progress You Can Show

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