No New Notifications

Intermediate SQL

NYC Career Centers

Select Option

Highlights

Intermediate SQL Class Overview

SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep, and then shown to your seat with a computer that is fully equipped with SQL. The instructor computer is attached to an overhead projector so you can easily follow their instructions. The class is taught in a very hands-on way, with the instructor teaching a concept and then the class doing exercises to enforce it. The maximum class size is 10 so you don't have to worry about getting lost in the crowd!

Upon successful completion of this course, students will be able to:

  • Code subqueries to generate query output

  • Create views, manipulate data through views, modify the view structure, and drop views

  • Use date functions, text parsing, concatenation and formatting functions

  • Create logic statements, variables and user functions

  • Use conversion functions to make outputs more user friendly

Intermediate SQL Class Outline

The Code

  • Self Joins
  • Union Joins
  • Cross Joins

Saving Queries Programmatically

  • Views
  • Functions
  • Layered Views
  • Create Top Value Views

Sub Queries

  • What is a Sub Query?
  • Clarity and Transparency
  • Single Table Sub Query
  • Multiple Table Sub Query
  • Exists versus In Operators
  • Any versus All Operator

Math, Advanced Functions and Logic Statements

  • Basic Math
  • Advanced Date and Time Functions
  • Advanced Text Functions
  • Case When Then Logic Statements
  • Variables and User Functions

Student Labs

  • Creating Views
  • Sub Queries
  • Advanced Functions
  • Logic and Date Functions

Note: Students will receive a Certificate of Completion at the end of this course and may retake the same course for free.

Class Starting Monday, February 24

2 sessions

  • Monday, February 24, 5:50PM- 9:20PM
  • Tuesday, February 25, 5:50PM- 9:20PM

Class Starting Thursday, March 05

2 sessions

  • Thursday, March 05, 9:00AM- 5:00PM

Class Starting Saturday, March 07

2 sessions

  • Saturday, March 07, 9:00AM- 5:00PM

Class Starting Wednesday, March 18

2 sessions

  • Wednesday, March 18, 9:00AM- 5:00PM

Class Starting Wednesday, March 25

2 sessions

  • Wednesday, March 25, 5:50PM- 9:20PM
  • Thursday, March 26, 5:50PM- 9:20PM

Class Starting Tuesday, March 31

2 sessions

  • Tuesday, March 31, 9:00AM- 5:00PM

Class Starting Sunday, April 05

2 sessions

  • Sunday, April 05, 9:30AM- 5:30PM

Class Starting Tuesday, April 14

2 sessions

  • Tuesday, April 14, 9:00AM- 5:00PM

Class Starting Friday, April 24

2 sessions

  • Friday, April 24, 9:00AM- 5:00PM

Class Starting Saturday, May 02

2 sessions

  • Saturday, May 02, 9:00AM- 5:00PM

Class Starting Wednesday, May 06

2 sessions

  • Wednesday, May 06, 5:50PM- 9:20PM
  • Thursday, May 07, 5:50PM- 9:20PM

Class Starting Thursday, May 07

2 sessions

  • Thursday, May 07, 9:00AM- 5:00PM

Class Starting Tuesday, May 19

2 sessions

  • Tuesday, May 19, 9:00AM- 5:00PM

Class Starting Sunday, May 31

2 sessions

  • Sunday, May 31, 9:30AM- 5:30PM

The class identified is made available through CourseHorse, a 3rd party marketplace for SQL Server classes and more. Groupon is not affiliated with or sponsored by the merchant, NYC Career Centers, 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.

Customer Reviews

This deal doesn't have any written reviews yet.

What You'll Get

Intermediate SQL Class Overview

SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep, and then shown to your seat with a computer that is fully equipped with SQL. The instructor computer is attached to an overhead projector so you can easily follow their instructions. The class is taught in a very hands-on way, with the instructor teaching a concept and then the class doing exercises to enforce it. The maximum class size is 10 so you don't have to worry about getting lost in the crowd!

Upon successful completion of this course, students will be able to:

  • Code subqueries to generate query output

  • Create views, manipulate data through views, modify the view structure, and drop views

  • Use date functions, text parsing, concatenation and formatting functions

  • Create logic statements, variables and user functions

  • Use conversion functions to make outputs more user friendly

Intermediate SQL Class Outline

The Code

  • Self Joins
  • Union Joins
  • Cross Joins

Saving Queries Programmatically

  • Views
  • Functions
  • Layered Views
  • Create Top Value Views

Sub Queries

  • What is a Sub Query?
  • Clarity and Transparency
  • Single Table Sub Query
  • Multiple Table Sub Query
  • Exists versus In Operators
  • Any versus All Operator

Math, Advanced Functions and Logic Statements

  • Basic Math
  • Advanced Date and Time Functions
  • Advanced Text Functions
  • Case When Then Logic Statements
  • Variables and User Functions

Student Labs

  • Creating Views
  • Sub Queries
  • Advanced Functions
  • Logic and Date Functions

Note: Students will receive a Certificate of Completion at the end of this course and may retake the same course for free.

Class Starting Monday, February 24

2 sessions

  • Monday, February 24, 5:50PM- 9:20PM
  • Tuesday, February 25, 5:50PM- 9:20PM

Class Starting Thursday, March 05

2 sessions

  • Thursday, March 05, 9:00AM- 5:00PM

Class Starting Saturday, March 07

2 sessions

  • Saturday, March 07, 9:00AM- 5:00PM

Class Starting Wednesday, March 18

2 sessions

  • Wednesday, March 18, 9:00AM- 5:00PM

Class Starting Wednesday, March 25

2 sessions

  • Wednesday, March 25, 5:50PM- 9:20PM
  • Thursday, March 26, 5:50PM- 9:20PM

Class Starting Tuesday, March 31

2 sessions

  • Tuesday, March 31, 9:00AM- 5:00PM

Class Starting Sunday, April 05

2 sessions

  • Sunday, April 05, 9:30AM- 5:30PM

Class Starting Tuesday, April 14

2 sessions

  • Tuesday, April 14, 9:00AM- 5:00PM

Class Starting Friday, April 24

2 sessions

  • Friday, April 24, 9:00AM- 5:00PM

Class Starting Saturday, May 02

2 sessions

  • Saturday, May 02, 9:00AM- 5:00PM

Class Starting Wednesday, May 06

2 sessions

  • Wednesday, May 06, 5:50PM- 9:20PM
  • Thursday, May 07, 5:50PM- 9:20PM

Class Starting Thursday, May 07

2 sessions

  • Thursday, May 07, 9:00AM- 5:00PM

Class Starting Tuesday, May 19

2 sessions

  • Tuesday, May 19, 9:00AM- 5:00PM

Class Starting Sunday, May 31

2 sessions

  • Sunday, May 31, 9:30AM- 5:30PM

The class identified is made available through CourseHorse, a 3rd party marketplace for SQL Server classes and more. Groupon is not affiliated with or sponsored by the merchant, NYC Career Centers, 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

Expiration varies.

  • 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.

NYC Career Centers

Class, Academic Course