Data Academy Course

Introduction to SQL (Structured Query Language)

About this course

Much of the initial and simple data analysis and manipulation is done in Excel spreadsheets.  However, with larger and more complex datasets, a relational database (e.g. Oracle, Microsoft SQL Server/Access) is usually a more popular choice.

What you’ll learn in this course

1)     Data Table Fundamental

2)    Basic syntax of SQL – Your First SQL Query

3)     Create a Custom View to Your Data Using the SELECT Statement

4)     Filter Data with the WHERE Clause

5)     Merge Data Elements from Different Tables Using JOINS

6)     Combine Subsets of Records from Different Tables Using UNION

7)     Aggregate data with SUM, AVG, MIN, MAX and the GROUP BY clause