Data Academy Course

Intro to SQL

About This Course

Simple data analysis and manipulation is often done in Excel.  However, with larger and more complex datasets, a relational database (e.g. Oracle, Microsoft SQL Server/Access) is usually a more popular choice. This course introduces attendees to SQL  (Structured Query Language).

What You’ll Learn In This Course

  • Data Table Fundamental
  • Basic syntax of SQL – Your First SQL Query
  • Create a Custom View to Your Data Using the SELECT Statement
  • Filter Data with the WHERE Clause
  • Merge Data Elements from Different Tables Using JOINS
  • Combine Subsets of Records from Different Tables Using UNION
  • Aggregate data with SUM, AVG, MIN, MAX and the GROUP BY clause