Log In
Join
for free
Back To Module Home
Relational Databases and SQL
0% completed
Manage MySQL Server
Get Started with the MySQL Server
Communicate with the MySQL Server
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
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
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
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
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
Quiz on Joins and Subqueries
Challenge: Use Joins to Combine Rows
Solution: Use Joins to Combine Rows
Conclusion
Final Remarks
Home
/
...
/
Solution: Use Joins to Combine Rows
Solution: Use Joins to Combine Rows
Learn the solution to the previous challenge.
...