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

Mon, Nov 18, 5:50pm - Nov 19, 9:20pm (2 sessions)

Next start dates (19)

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

What you'll learn in this sql server training:

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

    Still have questions? Ask the community.

    Refund Policy
    • 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 (20)
    Start Date Time Teacher # Sessions Price
    5:50pm - 9:20pm TBD 2 $325
    This course consists of multiple sessions, view schedule for sessions.
    Tue, Nov 19 5:50pm - 9:20pm TBD
    9:00am - 5:00pm TBD 1 $325
    9:00am - 5:00pm TBD 1 $325
    9:00am - 5:00pm TBD 1 $325
    5:50pm - 9:20pm TBD 2 $325
    This course consists of multiple sessions, view schedule for sessions.
    Thu, Dec 19 5:50pm - 9:20pm TBD
    Start Date Time Teacher # Sessions Price
    9:00am - 5:00pm TBD 1 $325
    9:00am - 5:00pm TBD 1 $325
    9:00am - 5:00pm TBD 1 $325
    9:00am - 5:00pm TBD 1 $325
    9:00am - 5:00pm TBD 1 $325
    Start Date Time Teacher # Sessions Price
    5:50pm - 9:20pm TBD 2 $325
    This course consists of multiple sessions, view schedule for sessions.
    Thu, Jan 30 5:50pm - 9:20pm TBD
    9:30am - 5:30pm TBD 1 $325
    9:00am - 5:00pm TBD 1 $325
    9:00am - 5:00pm TBD 1 $325
    5:50pm - 9:20pm TBD 2 $325
    This course consists of multiple sessions, view schedule for sessions.
    Tue, Feb 25 5:50pm - 9:20pm TBD
    Start Date Time Teacher # Sessions Price
    9:00am - 5:00pm TBD 1 $325
    9:00am - 5:00pm TBD 1 $325
    9:00am - 5:00pm TBD 1 $325
    5:50pm - 9:20pm TBD 2 $325
    This course consists of multiple sessions, view schedule for sessions.
    Thu, Mar 26 5:50pm - 9:20pm TBD
    9:30am - 5:30pm 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 (638)

    (638 Reviews)
    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.
    Intermediate SQL
    Reviewed by Kenton B. on 3/2/2018
    Great class, thanks!
    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