Understanding SQL Databases
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Understanding the Value of SQL
Understanding the Value of SQL
This lesson introduces SQL as a useful tool for anyone who regularly works with data.
Demonstrating an SQL Query
Demonstrating an SQL Query
In this lesson, we learn how SQL queries can be used to acquire useful insights.
Exploring the Uses of SQL
Exploring the Uses of SQL
Learn about the various types of SQL and how professionals use them.
Comparing Spreadsheets and Databases
Comparing Spreadsheets and Databases
Explore the basics of how data is stored in either a spreadsheet or a database.
Understanding Data Redundancy
Understanding Data Redundancy
Learn how redundancy can make our data inefficient.
Removing Redundant Data
Removing Redundant Data
Learn how splitting tables removes redundant data.
Establishing Simple Relationships
Establishing Simple Relationships
Learn how relationships are used to connect separate tables.
Understanding Many to Many Relationships
Understanding Many to Many Relationships
Learn how about how many to many relationships can be problematic.
Resolving Many to Many Relationships
Resolving Many to Many Relationships
Learn how to use junction tables to work around many to many relationships.
Querying a Database
Querying a Database
Learn about the mechanics of SQL queries.
Performing Basic SQL Queries
Performing Basic SQL Queries
Perform a basic SQL query that selects data from a databse.
Performing a Basic SQL Join
Performing a Basic SQL Join
Learn how to join two tables and to sort the output of a query.
