0% completed

All LessonsFree Lessons (5)

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

Manage MySQL Server

Get Started with the MySQL Server Communicate with the MySQL Server Summary Quiz Yourself on Installing and Communicating with MySQL server

Basic SQL Commands

Introduction to SQL Commands

Create and Select a Database

Insert Data into a Table

Restricting the Specific Rows

Deleting Rows from Tables

Update Rows on a Table

Retrieve Data Using the like Operator

Quiz on SQL Queries

Challenge: Create a Table

Solution: Create a Table

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

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

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

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

Conclusion

Getting Started with SQL and Relational Databases/

...

/

Quiz on SQL Queries

Quiz on SQL Queries

Test your understanding of SQL commands.

We'll cover the following...

Technical Quiz

1.

Which mysql> command lists the databases defined and managed by the database server?

A.

list databases;

B.

databases;

C.

show databases;

D.

show all;

1 / 5