This workshop will build upon the skills developed in the SQL Bootcamp. The program uses a combination of lecture and in-class exercises to.
What You'll Get
This workshop will build upon the skills developed in the SQL Bootcamp. The program 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.
The workshop will include the following topics:
Understanding of advanced SQL concepts
- JOIN operations
- UNION Statements
- String Comparisons
- Optimizing Queries
- SQL in the Enterprise
- Prior to class, please install PostgreSQL and PGadmin. There are multiple ways to install SQL. However, please follow the instructions found in the link to be prepared for the start of class.
- Familiarity with SQL concepts including: SELECT-FROM-WHERE statements, LIMIT clauses, Math operations and constant expressions in SELECT statements, Booleans and complex conditions in the WHERE clause, Pattern matching in the WHERE clause, NULL values, Grouping and aggregations, HAVING clauses, and ORDER BY clauses.
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