Getting Started with SQL and Relational Databases

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.

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 the queried data. ... See More

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.

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.

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.

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.

Course Contents

Show All

Show All Lessons

1. Getting Started

Overview of the Course

Introduction to Relational Database Management Systems

Data Modeling

Conceptual vs. Actual Model of a Database

Summary

Quiz on the Basics of RDBMS

2. Manage MySQL Server

Get Started with the MySQL Server

Communicate with the MySQL Server

Summary

Quiz Yourself on Installing and Communicating with MySQL server

3. Basic SQL Commands

Introduction to SQL Commands

Create and Select a Database

Create Tables

Insert Data into a Table

Restricting the Specific Rows

Deleting Rows from Tables

Update Rows on a Table

Retrieve Data Using the like Operator

Summary

Quiz on SQL Queries

Challenge: Create a Table

Solution: Create a Table

4. Add Columns and Indexes

Add a New Column

Indexes

Create an Index

Remove an Index

Unique Indexes

Summary

Quiz on Indexing

Challenge: Create Indexes

Solution: Create Indexes

5. Count and Sort Records

Create Table Products

Insert Product Data

Sort Results

Limit the Number of Resulting Records

Summary

Quiz on Counting, Sorting, and Limiting Results

Challenge: Limit Records

Solution: Limit Records

6. Foreign Keys

Create the orders Table

Insert Data into the orders Table

Unique Order Number

Insert the Wrong Customer Id

Create the order_items Table

Visualize Relationships and a Multicolumn Unique Index

Summary

Quiz on Foreign Keys

Challenge: Apply Foreign Keys to Tables

Solution: Apply Foreign Keys to Tables

7. Joins, Left Joins And Subqueries

Introduction to Joins

Delete Unnecessary Data

Insert Necessary Data

Combine Data from Various Tables

Joins with Aggregate Functions

Left Joins

Group-Based Aggregation

Practice Some More Queries

Summary

Quiz on Joins and Subqueries

Challenge: Use Joins to Combine Rows

Solution: Use Joins to Combine Rows

8. Conclusion

Wrap Up