A Deep Dive into SQL, March 12

Who: General Assembly
Where: General Assembly – Seattle, 1218 3rd Ave. Suite #300,Seattle, WA 98101
When: March 12, 10:00 am – 4:00 pm
What: Much of the data that we need to analyze is stored in databases. SQL is a powerful but reasonably simple tool for retrieving data from databases. This class will take those new to SQL, or those who need a refresher, through the basics of retrieving data from databases. Students will access large real world databases and retrieve the data they want.

Takeaways

Understand the way data is organized in large databases and data warehouses
Combine data from more than one table
Group, count and sum data
Control what is data is returned from the database to filter to just what you need
Prereqs & Preparation

Students should bring a laptop to be able to access databases and learn with the hands on exercises in class
Students will need to create a Google developers account prior to class. This is a simple thing to do and instructions will be sent out prior to class.
While some prior basic experience in SQL is helpful, students brand new to SQL will be able to learn these aspect of retrieving data with SQL without prior knowledge