SERVICE

Intro to SQL

What to know

Prerequisites

You should be comfortable with data analysis and have experience manipulating data in Excel.

About the course

This course will introduce you to a global database language SQL (Structured Query Language) so you can manipulate your data more elegantly and efficiently.

Duration: 2 hours
Location: Offered virtually over Microsoft Teams

What to do

1. Review the course learning objectives

In this course, you will learn:

  • 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
  • Aggregate data with SUM, AVG, MIN, MAX and the GROUP BY clause
  • How to run SQL queries in Snowflake (CCSF’s cloud based data warehouse solution)
  • Resources to learn more!
  • [if time] Merge Data Elements from Different Tables Using JOINS

2. Join the interest list

Fill out our Course Interest form to get a notification email when courses open for enrollment.

This email will include a short Enrollment Form that you will need to fill out to get on the waitlist for that scheduled class. Seats are granted on a first-come, first-served basis so please complete the enrollment form as soon as you can.

Note that filling out the course interest form does NOT guarantee enrollment in any course.

Fill out the course interest form

More details

What is SQL?

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 often a more popular and effective choice. SQL is an international standard language for data manipulation in a relational database and is an important skill for data scientists and analysts.

Resources