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

Tue, Feb 11, 9:00am - 5:00pm

Next start dates (8)

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

What you'll learn in this sql server training:

Advanced 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:

  • Create Databases and Tables
  • Insert, update and delete data through importing and coding techniques
  • Export data to other applications
  • Create constraints, indexes and referential integrity
  • Create database diagrams
  • Protect Live Data with Temporary Tables

Advanced SQL Class Outline

Importing and Exporting Data

  • Creating a Database and Tables in SQL
  • Importing and Exporting Data from and to Excel
  • Importing and Exporting Data from and to Access
  • Importing, Updating and Deleting Data via Code

Building Control Structures

  • Creating Primary Keys, Indexes and Constraints
  • Setting up Referential Integrity
  • Creating Database Diagrams

Optional

  • Protect Views with Schema binding
  • Data Conversion Functions
  • Temporary Tables
  • Stored Procedures

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 (9)
Start Date Time Teacher # Sessions Price
9:00am - 5:00pm TBD 1 $425
9:30am - 5:30pm TBD 1 $425
9:00am - 5:00pm TBD 1 $425
9:00am - 5:00pm TBD 1 $425
9:00am - 5:00pm TBD 1 $425
Start Date Time Teacher # Sessions Price
9:30am - 5:30pm TBD 1 $425
9:00am - 5:00pm TBD 1 $425
9:00am - 5:00pm TBD 1 $425
9:00am - 5:00pm TBD 1 $425

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 4250 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (3)

Get quick answers from CourseHorse and past students.

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? We 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

Reviews of Classes at NYC Career Centers (653)

(653 Reviews)
Advanced SQL
Reviewed by Gracie H. on 2/21/2017
Peter is an amazing instructor. Very clear, well structured
Advanced SQL
Reviewed by Daniel T. on 6/2/2016
Good class, instructor was very informative .
Advanced SQL
Reviewed by Anonymous on 10/21/2015
Super helpful. Peter is a great teacher and he makes sure nobody falls behind. And we have covered all the material in-depth! Definitely recommend!
Advanced SQL
Reviewed by Huijun W. on 12/16/2019
Advanced SQL
Reviewed by Wei Z. on 12/29/2018
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