0% completed

All LessonsFree Lessons (5)

Getting Started

Overview of the Course

Introduction to Relational Database Management Systems

Conceptual vs. Actual Model of a Database

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 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

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

Group-Based Aggregation

Practice Some More Queries

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/

...

/

Summary

Summary

Get an overview of what we’ve covered in this chapter.

We'll cover the following...

Learning outcome

Learning outcome

In this chapter, we learned to query and get useful information. We went over how to combine data from two or more different tables. Combining information wasn’t restricted to information coming from tables ...