Querying Microsoft SQL Server 2012/14/16

at Certstaffix Training - Laurel

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

Mon, Aug 31, 10:00am - Sep 04, 5:00pm Eastern Time (5 sessions)

Next start dates (2)

Laurel, Downtown, Washington, D.C.
14502 Greenview Dr Ste 300A
Near Laurel Bowie Rd
Laurel, Maryland 20708
Class Level: All levels
Age Requirements: 18 and older
Average Class Size: 3

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:

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.

This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities.

Course Outline:

Chapter 1 Foundations of Querying
  • Lesson 1: Understanding the Foundations of T-SQL
  • Lesson 2: Understanding Logical Query Processing
Chapter 2 Getting Started with the SELECT Statement
  • Lesson 1: Using the FROM and SELECT Clauses
  • Lesson 2: Working with Data Types and Built-in Functions
Chapter 3 Filtering and Sorting Data
  • Lesson 1: Filtering Data with Predicates
  • Lesson 2: Sorting Data
  • Lesson 3: Filtering Data with TOP and OFFSET-FETCH
Chapter 4 Combining Sets
  • Lesson 1: Using Joins
  • Lesson 2: Using Subqueries, Table Expressions, and the APPLY Operator
  • Lesson 3: Using Set Operators
Chapter 5 Grouping and Windowing
  • Lesson 1: Writing Grouped Queries
  • Lesson 2: Pivoting and Unpivoting Data
  • Lesson 3: Using Window Functions
Chapter 6 Querying Full-Text Data
  • Lesson 1: Creating Full-Text Catalogs and Indexes
  • Lesson 2: Using the CONTAINS and FREETEXT Predicates
  • Lesson 3: Using the Full-Text and Semantic Search Table-Valued Functions
Chapter 7 Creating Tables and Enforcing Data Integrity
  • Lesson 1: Creating and Altering Tables
  • Lesson 2: Enforcing Data Integrity
Chapter 8 Designing and Creating Views, Inline Functions, and Synonyms
  • Lesson 1: Designing and Implementing Views and Inline Functions
  • Lesson 2: Using Synonyms
Chapter 9 Inserting, Updating, and Deleting Data
  • Lesson 1: Inserting Data
  • Lesson 2: Updating Data
  • Lesson 3: Deleting Data
Chapter 10 Other Data Modification Aspects
  • Lesson 1: Using the Sequence Object and IDENTITY Column Property
  • Lesson 2: Merging Data
  • Lesson 3: Using the OUTPUT Option
Chapter 11 Implementing Transactions, Error Handling, and Dynamic SQL
  • Lesson 1: Managing Transactions and Concurrency
  • Lesson 2: Implementing Error Handling
  • Lesson 3: Using Dynamic SQL
Chapter 12 Designing and Implementing T-SQL Routines
  • Lesson 1: Designing and Implementing Stored Procedures
  • Lesson 2: Implementing Triggers
  • Lesson 3: Implementing User-Defined Functions
Chapter 13 Using Tools to Analyze Query Performance
  • Lesson 1: Getting Started with Query Optimization
  • Lesson 2: Using SET Session Options and Analyzing Query Plans
  • Lesson 3: Using Dynamic Management Objects
Chapter 14 Implementing Indexes and Statistics
  • Lesson 1: Implementing Indexes
  • Lesson 2: Using Search Arguments
  • Lesson 3: Understanding Statistics
  • These topics will be covered in class if time allows:
Chapter 15 Understanding Cursors, Sets, and Temporary Tables
  • Lesson 1: Evaluating the Use of Cursor/Iterative Solutions vs. Set-Based Solutions
  • Lesson 2: Using Temporary Tables vs. Table Variables
Chapter 16 Understanding Further Optimization Aspects
  • Lesson 1: Understanding Plan Iterators
  • Lesson 2: Using Parameterized Queries and Batch Operations
  • Lesson 3: Using Optimizer Hints and Plan Guides
Headsets for free, Guaranteed to Run, Re-Takes for free (Up to 6 months), Interactive Classroom environment.

Registration Note: We can only accept students into our classes whose tuition is being paid by an employer or sponsoring organization. Self-paying individuals cannot enroll.

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.

Certstaffix Training offers instructor-led live training classes that can be taken from your home or work. We also have real physical locations where students can go and connect to class in a quiet office with a computer that we provide. 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

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

All of our classes are offered live online and any student with a computer and an internet connection can take class from their home or anywhere else they feel comfortable. For customers who are concerned about COVID-19 with regard to attending classes from one of our computer labs, please know that you can switch to attend from home up to the day before class. We just ask that you notify us so we can send them class connection information and inform the center staff that they won’t be coming in for class. 

With regard to our computer labs, each one holds a maximum of only two students per room so no student will need to be in close proximity to any large group of people. We’ve also asked the centers that host our computer labs to disinfect all keyboards/mice/surfaces, etc. after each use and requested that they provide hand sanitizer to our students. That being said, we definitely understand if a student would feel more comfortable taking class from their home.  

We purchase and ship books to students two weeks before their class date and we are charged for any computer lab booking if not cancelled within a week of the booking date, so we would not be able to fully refund a student who wants to cancel less than two weeks before class without incurring a financial loss to us that we would not be able to recover. With the attend from home option, students do hava a choice to stay home and still get their training. Students can also choose to postpone their training to a later date if they wish. 


Original cancellation policy (non-COVID-19):

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

Start Dates (3)
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm Eastern Time Remote Instructor 5 $2,925
This course consists of multiple sessions, view schedule for sessions.
Tue, Sep 01 10:00am - 5:00pm Eastern Time Remote Instructor
Wed, Sep 02 10:00am - 5:00pm Eastern Time Remote Instructor
Thu, Sep 03 10:00am - 5:00pm Eastern Time Remote Instructor
Fri, Sep 04 10:00am - 5:00pm Eastern Time Remote Instructor
10:00am - 5:00pm Eastern Time Remote Instructor 5 $2,925
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 27 10:00am - 5:00pm Eastern Time Remote Instructor
Wed, Oct 28 10:00am - 5:00pm Eastern Time Remote Instructor
Thu, Oct 29 10:00am - 5:00pm Eastern Time Remote Instructor
Fri, Oct 30 10:00am - 5:00pm Eastern Time Remote Instructor
10:00am - 5:00pm Eastern Time Remote Instructor 5 $2,925
This course consists of multiple sessions, view schedule for sessions.
Tue, Dec 15 10:00am - 5:00pm Eastern Time Remote Instructor
Wed, Dec 16 10:00am - 5:00pm Eastern Time Remote Instructor
Thu, Dec 17 10:00am - 5:00pm Eastern Time Remote Instructor
Fri, Dec 18 10:00am - 5:00pm Eastern Time 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 (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Certstaffix Training (31)

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 DC educator.

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