This workshop will teach you the core concepts of databases as well as how to write effective SQL queries

Structured Query Language for Data Science, learn the core concepts of databases
What this course is about:

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. The session will be highly interactive and engaging - questions are encouraged!

This workshop will take place over two 1.5h sessions, one week apart. There will be homework exercises between sessions.

Who this program is for:

This workshop is for beginners. We will start with basic examples and gradually move toward more complex SQL queries. By the end of this workshop, you’ll know how to write SQL and work with databases to solve business problems and produce management reports.

You will learn:
  1. What databases are and why they are important
  2. The different “flavors” of databases
  3. Connecting to your work’s database
  4. The four operations you can perform on data
  5. The fundamental parts of a SQL query
  6. Analytical queries: GROUP BY
  7. Subqueries and Joins
Prerequisites & Preparation:
  1. Laptop

Start Dates

Nov 7th Evening

$75

Course schedule:
Nov. 7, 2017, 7:15 p.m.
Nov. 14, 2017, 7:15 p.m.

Tech Job Interview

Are you prepared for a job interview? This class will explain problem solving with Algorithms and Big-O notation

Learn more