https://generalassemb.ly/education/sql-bootcamp/boston/41111 GA Boston
125 Summer Street, 13th floor
Boston, MA 02110
About This Workshop:
SQL provides powerful but reasonably simple tools for data analysis and handling. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. We will use a combination of lecture and in-class exercises to ensure that students leave with a working grasp of SQL fundamentals.
Important Note: Prior to class, you must have PostgreSQL and PGadmin installed.
-Background on SQL
-Basic SELECT-FROM-WHERE statements
-Math operations and constant expressions in SELECT statements
-Booleans and complex conditions in the WHERE clause
-Pattern matching in the WHERE clause
-Grouping and aggregations
-ORDER BY clauses