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.
Overview
Syllabus
- Introduction to Relational Databases
- Learn the principles behind relational data organization: tables, queries, aggregations, keys, and joins.
- 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.
- 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.
- SQL Joins
- In this lesson, you will learn how to combine data from multiple tables together.
- 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.
