Course Details
Price:
$325 10 seats left
Start Date:

Fri, Jul 24, 9:00am - 5:00pm Eastern Time

Next start dates (6)

Location:
Midtown, Manhattan
185 Madison Ave 3rd Floor
At E 34th St
New York, New York 10016
(Map)
Purchase Options
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7

Flexible Reschedule Policy: This provider has flexible, free rescheduling for any-in person workshop. Please see the cancellation policy for more details

What you'll learn in this sql server training:

Discover views, functions, and subqueries in SQL Level 2. You’ll begin by reviewing SQL queries related to joins. Next, you’ll dive into the core of SQL—views, functions, stored procedures, subqueries, math, functions, and logic statements. The course concludes with a lab session to practice your skills.

Practical SQL Courses in New York City
At the start of the class, you’ll receive our proprietary SQL course manual that you can keep after the course for reference. During the course, your instructor will explain concepts, show examples, and provide time to complete practice activities in the workbook. Our class sizes cap at 10, so you’ll be able to ask questions during the class.

SQL Bootcamp
Do you want to become a SQL expert? Get 15% off the SQL Bootcamp, which bundles SQL Level 1, SQL Level 2, and SQL Level 3 into three consecutive days of training. Choose from consecutive three-day classes offered on weekdays, or take the course over several weekends.

Get a free retake of the course within 6 months.

Class Notes
SQL can be used with a variety of programs. This course uses Microsoft SQL Server.

Prerequisite
SQL proficiency equivalent to our SQL Level 1 course is required, including basic querying, filtering, and aggregation.

Course Overview

  • 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

Please CLICK HERE for the Course Syllabus


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Still have questions? Ask the community.

Refund Policy

Note: This provider has a temporary cancellation policy for COVID-19 related cancellations which is as follows: 

We are allowing attendees to reschedule at no charge or keep class credit for up to two years. Email us at [email protected] 

---- 

Original cancellation policy (non-COVID-19):

  • Registration Fee: All courses include a non-refundable registration fee of 10%.
  • Cancellations: Students may cancel up to seven business days prior to the course and receive all monies paid, less the non-refundable registration fee. Cancellation requests within the policy should be made directly to CourseHorse.
  • Rescheduling: Students may reschedule once up to three business days prior to the start date of the course at no charge. Reschedules within three business days incur a $20 rescheduling fee. Reschedule requests should be emailed to [email protected]

Map

Google Map

NYC Career Centers

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square.

Start Dates (7)
Start Date Time Teacher # Sessions Price
9:00am - 5:00pm Eastern Time TBD 1 $325
9:30am - 5:30pm Eastern Time TBD 1 $325
9:00am - 5:00pm Eastern Time TBD 1 $325
5:50pm - 9:20pm Eastern Time TBD 2 $325
This course consists of multiple sessions, view schedule for sessions.
Thu, Aug 13 5:50pm - 9:20pm Eastern Time TBD
9:00am - 5:00pm Eastern Time TBD 1 $325
Start Date Time Teacher # Sessions Price
9:00am - 5:00pm Eastern Time TBD 1 $325
9:00am - 5:00pm Eastern Time TBD 1 $325

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 3250 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (8)

Get quick answers from CourseHorse and past students.

Question from MURALIDHAR N.
Is this course taught on SQL server? if so, what version SQL server?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi Muralidhar! The school uses a SQL 2014 version on the back end. Hope this helps!
Answer
Cancel
Question from Katayoun V.
Just want to confirm that I don't need to bring my own laptop to the class. right?
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi Katayoun! The school will provide the computers.
Answer
Cancel
Question from MURALIDHAR N.
Is this course taught on the SQL server? Which version?
Answer from Eli S. Verified Student
SQL Server Management Studio 2014
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi there! The SQL they use runs on SQL server 2014.
Show all 2 answers
Answer
Cancel
Question from Emmanuel A.
What's thé name this school?
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi Emmanuel, this course is being offered by Career Centers.
Answer
Cancel
Question from Angelica B.
What is the background of the trainer?
Answer from Angelica B. CourseHorse StaffCourseHorse Staff
All of our Instructors are BPSS approved with more than 20 years of experience.
Answer
Cancel
Question from Angelica B.
Will the users be using ssms and doing actual queries?
Answer from Angelica B. CourseHorse StaffCourseHorse Staff
Students will be using SQL Server Management Studio 2014, and yes, they are doing actual queries.
Answer
Cancel
Question from Angelica B.
Are the classes definite? They may have someone travel to NY for one of these classes.
Answer from Angelica B. CourseHorse StaffCourseHorse Staff
We only reschedule or cancel classes in case of emergency and will try to notify students in advance of any potential schedule changes.
Answer
Cancel
Question from Danielle T.
After taking the class once, can you retake it for free as a refresher ?
Answer from Pablo M. Verified Student
Yes, you can. You get a retake within a year.
Answer
Cancel
View all 8 questions

Reviews of Classes at NYC Career Centers (666)

(666 Reviews)
Intermediate SQL
Reviewed by Amanda U. on 2/10/2020
Great experience, I learned a good deal and feel much more confident in my skills after this class. It’s the right value for what I paid for. I had finished a couple of free tutorials on sql before this intermediate class and was able to hold my own.
Intermediate SQL
Reviewed by Bob T. on 11/3/2019
Professor Peter was great - covered a lot of material in a smooth fashion !
Intermediate SQL
Reviewed by Natalie K. on 3/10/2019
Learned more in this workshop than a 6 week course I took elsewhere.
Intermediate SQL
Reviewed by Anonymous on 11/17/2018
Great instructor and a great class to help master this topic. Well worth.
Intermediate SQL
Reviewed by Anonymous on 10/25/2018
Great Class. Super intense. Love the fact that you can retake it once free of charge.
loading...
loading...
Similar Classes

School: NYC Career Centers

NYC Career Centers

Career Centers
Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD. Our courses are instructor-led...

Read more about NYC Career Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Ready to take this class?
BOOK NOW
Booking this class for a group? Find great private group events here