18 and older
This workshop will build upon the skills developed in the GA SQL For Beginners course.
SQL provides powerful but reasonably simple tools for data analysis and manipulation. The workshop uses a combination of lecture and in-class exercises to ensure that students leave with a working grasp of the SQL skills covered in class. Students will immediately be able to apply their skills at work.
This is an Intermediate-Advanced course and is best suited for students with some basic SQL knowledge (Understand SELECT-FROM-WHERE statements and basic filtering). Beginner level students should attend GA’s SQL for Beginners course prior to this workshop.Takeaways
- Review SQL vocabulary such as tables, schema, functions, and joins
- Review basic SQL syntax with SELECT-FROM-WHERE statements (also LIMIT/ ORDER BY)
- Complex filtering using WHERE clauses
- Grouping and Aggregations [MIN, MAX, SUM, AVG, COUNT]
- CASE Statements
- Mathematical calculations in the SELECT statement
- Understanding Primary and Foreign Keys
- JOINs and UNIONs using aliases
- Using Common Tables Expressions (CTEs) to break up complex queries
- Useful SQL Functions (Date/ String manipulation)
This is an intermediate/advanced class. Please make sure you have attended SQL for Beginners course or have a basic familiarity with SQL syntax.
We will be pausing to let students run and write queries of their own, so students should bring laptops. We will use the first 10 minutes of class to install SQLite on laptops for use in class.
For students enrolling in 12 week part time and immersive classes, it is not recommended that you book more than one class simultaneously.