Mini Map
Search
⌘ K
Log In
Getting Started with SQL and Relational Databases
0%
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
Home
/
Courses
/
Getting Started with SQL and Relational Databases
Solution: Apply Foreign Keys to Tables
Learn to solve the previous challenge.
We'll cover the following...
Tasks 1 through 3
Tasks 4 through- 5
Tasks 6 through- 7
Tasks 1
...