SQL is a valuable tool and skill to unlocking your company’s data. This powerful but simple programming language is used to communicate with
What You'll Get
SQL is a valuable tool and skill to unlocking your company's data. This powerful but simple programming language is used to communicate with databases and is a standard across most online applications. Knowing SQL allows you to gather, analyze and process data from any database you have access to, helping you unlock insights to make better business decisions.
In this workshop, you’ll learn what SQL is, how databases function, and the SQL queries needed to collect data from a database to analyze and find the answers you’re looking for.
- Background on databases & database structure
- Connecting to a remote database
- Finding basic data with SELECT, FROM, WHERE, & ORDER BY
- Combining data from multiple tables with INNER JOIN
- Calculating statistics with aggregate functions and GROUP BY
Prereqs & Preparation
This workshop is designed for beginners. No prior knowledge or experience with SQL is required.
What to bring to class: All participants must bring their own laptop. Please also download the Sqlectron SQL client here prior to class.
Note on installing Sqlectron: Mac users may need to allow installation of non-app-store programs in their System Preferences
A computer will not be provided.
The class identified is made available through CourseHorse, a 3rd party marketplace for SQL classes and more. Groupon is not affiliated with or sponsored by the merchant, General Assembly, in connection with this offer. Please contact Groupon customer service for all inquiries related to this offer. Inquiries placed to CourseHorse will be directed back to Groupon.
The Fine Print
Promotional value expires Feb 5, 2020.