Intermediate SQL Bootcamp | February 21
Nigel Caldon
Co-Founder,
BALLSTAR
About This Workshop
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 participants leave with a working grasp of the SQL skills covered in class. Participants will immediately be able to apply their skills at work.
Important Note: Prior to class, you must have PostgreSQL and PGadmin installed. To do so, please follow these instructions for installation.
Interested in seeing this class held privately at your organization? Email us at bospartnerships@ga.co to request more info.
Takeaways
- Understanding of advanced SQL concepts
- JOIN operations
- UNION Statements
- Subqueries
- String Comparisons
- Optimizing Queries
- SQL in the Enterprise
Preparation
- Prior to class, please install PostgreSQL and PGadmin. Instructions for installation can be found here. 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.
About the Instructor
Nigel Caldon
Co-Founder,
BALLSTAR
Nigel was born and raised in Brooklyn, NY. Awarded a Presidential Scholarship to study economics at Hampton University. He then returned to NYC to complete his Bachelors in Economics at New York University. He worked in credit derivative markets at Goldman Sachs and Old Lane before founding The Street Academy for Financial Literacy, a non-profit serving over 1000 NYC youth annually. Today, Nigel is the Co-Founder and COO at BALLSTAR, a social database for global basketball statistics.
Refund Policy
We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.
