Discover Classes. Earn Rewards.
Course Details
Price:
$425 7 seats left
Start Date:

Fri, Dec 28, 9:00am - 5:00pm

Next start dates (6)

Location:
Midtown, Manhattan
185 Madison Ave Ste 1104
At E 34th St
New York, New York 10016
(Map)
Share:
Purchase Options
No Booking Fees Book Now Save to WishList

47 people saved this class

Give as a Gift
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

  • Use Stored Procedures and Triggers for the creation of parameterized queries and automation of workflow processes

  • 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

    Temporary Tables


    • Low Level Security Overview

    • Local Temp Tables

    • Global Temp Tables

    Stored Procedures


    • Parameter Queries using Variables through Views

    • Automation of Workflow Processes

    • Triggers to Create Workflow Events

    Still have questions? Ask the community.

    Refund Policy
    • No charge for substituting students at any time.
    • Students are eligible for a free retake within 6 months, contingent on class running and available seating
    • No refund or rescheduling permitted within 3 business days of start of class.

    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 TBD 1 $425
    9:00am - 5:00pm 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: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 (538)

    (538 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 Duke P. on 5/20/2018
    Advanced SQL
    Reviewed by Daniel D. on 9/7/2017
    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
    Taking this class for work? Get exclusive perks & discounts for free.
    Loading...