Discover Classes. Earn Rewards.

Querying Microsoft SQL Server 2012/14/16

at Certstaffix Training - Near North Side

Course Details
$2,925 4 seats left
Start Date:

Mon, Nov 04, 9:00am - Nov 08, 4:00pm (5 sessions)

Next start dates (1)

Near North Side, Downtown/Loop
500 N Michigan Ave Ste 600
At N Michigan Ave
Chicago, Illinois 60611
Purchase Options
Class Level: All levels
Age Requirements: 18 and older
Average Class Size: 3

What you'll learn in this sql server training:

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are seeking to prove their skills and knowledge in writing queries. 

Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider.. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam.

Course Outline:
  • Chapter 1 Foundations of Querying
  • Chapter 2 Getting Started with the SELECT Statement
  • Chapter 3 Filtering and Sorting Data
  • Chapter 4 Combining Sets
  • Chapter 5 Grouping and Windowing
  • Chapter 6 Querying Full-Text Data
  • Chapter 7 Querying and Managing XML Data
  • Chapter 8 Creating Tables and Enforcing Data Integrity
  • Chapter 9 Designing and Creating Views, Inline Functions, and Synonyms
  • Chapter 10 Inserting, Updating, and Deleting Data
  • Chapter 11 Other Data Modification Aspects
  • Chapter 12 Implementing Transactions, Error Handling, and Dynamic SQL
  • Chapter 13 Designing and Implementing T-SQL Routines
  • Chapter 14 Using Tools to Analyze Query Performance
  • Chapter 15 Implementing Indexes and Statistics
  • Chapter 16 Understanding Cursors, Sets, and Temporary Tables
  • Chapter 17 Understanding Further Optimization Aspects 

School Notes:
Courseware (if a course has a Courseware) will be shipped to the address provided two weeks before the class starts. Make sure that the additional info field is properly and correctly filled out to avoid Courseware being lost in transit. Please also note that P.O. Box addresses are not allowed.

The classes are instructor-led live training you attend in a local classroom or from your home/office. Our instructors teach from a remote location while being able to interact with students as in a traditional classroom setting.

Instructors can view student progress and take control of their PC to provide direct assistance. Students can see the instructor's presentation as well as voice questions directly to the instructor and participate in class discussions.

Still have questions? Ask the community.

Refund Policy
You can cancel or reschedule your registration without penalty or charge provided you give notice of 10 business days (M-F) or more days before the start of my class.

If you request to cancel or reschedule your registration 10 Business Days (M-F) or less days before the class start you will be charged 100% the course fee and will not be entitled to a refund. You have one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

You cannot change your class location ten (10) Business days (M-F) or less before the class start because Certified Staffing Solutions has shipped training materials and provisioned resources. Location changes requested prior to that timeframe are subject to availability and may incur an additional charge.

Should Certified Staffing Solutions need to cancel your class due to insufficient enrollment, or postpone it due to events beyond their control, Certified Staffing Solutions will notify you as soon as possible. In such cases, you may reschedule to a future class date at no additional charge or receive a refund for any money on account relating to that registration.

Travel arrangements and costs are the sole responsibility of the student. Certified Staffing Solutions suggests obtaining refundable reservations. Certified Staffing Solutions classes are confirmed approximately 14 days before the start of the class. We cannot guarantee class commitments before that window of time. Certified Staffing Solutions will not be responsible for any cancellation costs incurred, including but not limited to, airline/mass transit tickets, hotel reservations and so on.


Google Map

Certstaffix Training

All classes at this location

Our downtown Chicago classroom is located at the Avenue Business Center in the Magnificent Mile district, close to plenty of restaurants and parking. When arriving for class, please proceed to Suite 600 and the receptionist will guide you to your classroom.

Start Dates (2)
Start Date Time Teacher # Sessions Price
9:00am - 4:00pm Remote Instructor 5 $2,925
This course consists of multiple sessions, view schedule for sessions.
Tue, Nov 05 9:00am - 4:00pm Remote Instructor
Wed, Nov 06 9:00am - 4:00pm Remote Instructor
Thu, Nov 07 9:00am - 4:00pm Remote Instructor
Fri, Nov 08 9:00am - 4:00pm Remote Instructor
9:00am - 4:00pm Remote Instructor 5 $2,925
This course consists of multiple sessions, view schedule for sessions.
Tue, Dec 17 9:00am - 4:00pm Remote Instructor
Wed, Dec 18 9:00am - 4:00pm Remote Instructor
Thu, Dec 19 9:00am - 4:00pm Remote Instructor
Fri, Dec 20 9:00am - 4:00pm Remote Instructor

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

Get quick answers from CourseHorse and past students.

Question from Anonymous
Does the class "Querying Microsoft SQL Server 2012/14/16" cover ETL tools like SSIS?
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi there! The SSIS tool is not covered in this class.

Reviews of Classes at Certstaffix Training (24)

Similar Classes

School: Certstaffix Training

Certstaffix Training

Certified Staffing Solutions specializes in providing computer training and instructors nationwide. Our instructors are professional trainers and utilize hands-on exercises to reinforce lecture. Each averages more than 5 years delivering classes to business professionals.

Our Advantages

  • Our Instructors:...

Read more about Certstaffix Training

CourseHorse Approved

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

Ready to take this class?
Taking this class for work? Get exclusive perks & discounts for free.