Data Academy Course

Intro to SQL

About This Course

*** Data Academy has suspended its in-person classes due to the City’s Shelter-in-Place Directive.  Meanwhile, please take advantage of the free SF Public Library online SQL courses from Gale if you have a library card, or other SQL related courses at EDX.org (audits only).***

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 a global database language 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

Created 6/8/2017