No New Notifications

SQL Bootcamp

General Assembly

Select Option

Highlights

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 
  • Subqueries 
  • Using Common Tables Expressions (CTEs) to break up complex queries 
  • Useful SQL Functions (Date/ String manipulation) 
Preparation
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.

In response to growing concerns around COVID-19, we’re offering all of our programming remotely.

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.

What You'll Get

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 
  • Subqueries 
  • Using Common Tables Expressions (CTEs) to break up complex queries 
  • Useful SQL Functions (Date/ String manipulation) 
Preparation
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.

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 Apr 11, 2020.

  • ALL SALES FINAL.
  • Must be 18 or older to attend
  • Voucher valid only for date and time listed; may not be exchanged, altered, or redeemed for other dates, but may send a friend in place.
  • Must present CourseHorse confirmation email upon arrival.
  • Purchaser name must be provided at checkout; this information will be shared with CourseHorse and course provider for purposes of order fulfillment.
  • Groupon voucher Terms of Sale and Extraordinary Event Policy do not apply.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services.
  • Offer is not eligible for our promo codes or other discounts.
  • Note, additional equipment or materials may be required or included in purchase price, see course description for details.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services. Offer is not eligible for our promo codes or other discounts.

General Assembly

Class, Academic Course