Lesson 1
Introduction to Relational Databases
Learn the principles behind relational data organization: tables, queries, aggregations, keys, and joins.
Course
SQL is one of the most versatile tools available for extracting insights from stored data. In this course, you will learn how databases work. You will also learn some basic SQL queries for that can be used to select, manipulate and aggregate data in databases.
SQL is one of the most versatile tools available for extracting insights from stored data. In this course, you will learn how databases work. You will also learn some basic SQL queries for that can be used to select, manipulate and aggregate data in databases.
9 hours
Completion Certificate
Last Updated November 15, 2022
No experience required
Lesson 1
Introduction to Relational Databases
Learn the principles behind relational data organization: tables, queries, aggregations, keys, and joins.
Lesson 2
Getting Started in SQL
In this section, you will gain knowledge about SQL basics for working with a single table. You will learn the key commands to filter a table in many different ways.
Lesson 3
Creating a Database Using Tables
Create your own database tables using normalized table design, using keys to declare relationships between tables; then apply these relationships to draw conclusions from data.
Lesson 4
SQL Joins
In this lesson, you will learn how to combine data from multiple tables together.
Lesson 5
SQL Aggregations
In this lesson, you will learn how to aggregate data using SQL functions which allow you to count, sum, find the minimum value, the maximum value, or an average of the data values.
Get Started Today