Log In
0% completed
All Lessons
Free 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
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
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
Wrap Up
Getting Started with SQL and Relational Databases
/
...
/
Solution: Apply Foreign Keys to Tables
Solution: Apply Foreign Keys to Tables
Learn to solve the previous challenge.
We'll cover the following...
Tasks 1
...