Discover Classes. Earn Rewards.
Querying Microsoft SQL Server 2012/14/16 is unfortunately unavailable

Thankfully we have 33 other SQL Server Classes for you to choose from. Check our top choices below or see all classes for more options.

Querying Microsoft SQL Server 2012/14/16

at Certstaffix Training - Mint Hill

(123)
Course Details
Price:
$2,925
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Mint Hill
1811 Sardis Rd N Ste 207
Btwn Tower Point Dr & Monroe Rd
Matthews, North Carolina 28270
(Map)
Purchase Options
Save to WishList

1 person saved this class

Book Private Class
Description
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.

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

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.

Map

Google Map

Certstaffix Training

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

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)

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

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

33 Top Choices

Beginner SQL

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get an overview of databases and queries in SQL Level 1. In this course, you’ll begin with an introduction to relational database management systems and practice connecting to Microsoft SQL Server. Next, you'll dive right into writing basic SQL queries to retrieve data from the database management system. The Best SQL Courses in NYC Our SQL courses...

Monday Jun 1st, 5:50pm - 9:20pm Eastern Time

  (2 sessions)
$325

2 sessions

Intermediate SQL

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Discover views, functions, and subqueries in SQL Level 2. You’ll begin by reviewing SQL queries related to joins. Next, you’ll dive into the core of SQL—views, functions, stored procedures, subqueries, math, functions, and logic statements. The course concludes with a lab session to practice your skills. Practical SQL Courses in New York City...

Sunday May 31st, 9:30am - 5:30pm Eastern Time

Advanced SQL

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Become a master of all things SQL in SQL Level 3. Export data to external applications, like Access and Excel, automate workflow with triggers, and protect live data by using temporary tables. At the end of the course, you’ll have the option to explore data conversion functions and Schema binding. Advanced SQL Classes in Midtown NYC At the start...

Wednesday Jun 10th, 5:50pm - 9:20pm Eastern Time

  (2 sessions)
$425

2 sessions

SQL Training For Beginners

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Do you keep hearing the word ‘SQL’ buzzing around and want to find out more about it? This 3 hour workshop will provide an introduction to fundamental concepts in relational databases and using the query language SQL.  Participants will learn to how to work with data that is stored in a relational database. By the end of the workshop, you...

Tuesday Jun 30th, 6:30pm - 9:30pm Eastern Time

Developing SQL Data Models

This class is temporarily being offered remotely.

at New Horizons Learning Group LA - Anaheim 1900 S State College Blvd Ste 100, Anaheim, California 92806

Are you looking for hands-on experience developing SQL data models? This course from New Horizons will equip you with the skills you need to level up in your Business Intelligence career. In the Developing SQL Data Models course, you will learn how to implement multidimensional databases and create tabular semantic data models for analysis using SQL...

Tuesday Jun 9th, 6am - 2pm Pacific Time

  (3 sessions)
$1,785

3 sessions

PowerShell for SQL Server Administrators

This class is temporarily being offered remotely.

at New Horizons Learning Group LA - San Bernardino 451 E Vanderbilt Wy Ste 250, San Bernardino, California 92408

This course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks. Who Should Attend This course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering...

Wednesday Jun 10th, 6am - 2pm Pacific Time

  (2 sessions)
$1,190

2 sessions

Analyzing Data with Power BI

This class is temporarily being offered remotely.

at Learning Tree International - Midtown 1601 Broadway 9th Fl, New York, New York 10019

This  course provides a comprehensive understanding of how to analyze data with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. Plus, this course will prepare you for Microsoft exam 70-778, a core requirement for the MCSA: BI Reporting certification. You Will Learn How To: Perform...

Wednesday Jun 10th, 9am - 4:30pm Eastern Time

  (3 sessions)
$2,650

3 sessions

Writing Reports with Report Builder and SSRS Level 1

This class is temporarily being offered remotely.

at New Horizons Learning Group LA - Anaheim 1900 S State College Blvd Ste 100, Anaheim, California 92806

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. Who Should Attend The primary audience for this course are persons who are new to reporting with Microsoft® SQL Server® Report Builder and SSRS, persons who are transitioning from another reporting software...

Thursday Jun 11th, 6am - 2pm Pacific Time

  (2 sessions)
$1,190

2 sessions

Implementing a Data Warehouse w/ Microsoft® SQL Server®

This class is temporarily being offered remotely.

at New Horizons Learning Group LA - Anaheim 1900 S State College Blvd Ste 100, Anaheim, California 92806

Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Who Should Attend This course is intended for database professionals who need to create and support a data warehousing...

Monday Jun 15th, 6am - 2pm Pacific Time

  (5 sessions)
$2,975

5 sessions

Administering a SQL Database Infrastructure

This class is temporarily being offered remotely.

at New Horizons Learning Group LA - Anaheim 1900 S State College Blvd Ste 100, Anaheim, California 92806

This course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Who Should Attend The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as...

Monday Jun 22nd, 6am - 2pm Pacific Time

  (5 sessions)
$2,975

5 sessions

Provisioning SQL Databases

This class is temporarily being offered remotely.

at New Horizons Learning Group LA - Anaheim 1900 S State College Blvd Ste 100, Anaheim, California 92806

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure. Who Should Attend The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work...

Monday Jun 22nd, 6am - 2pm Pacific Time

  (5 sessions)
$2,975

5 sessions

Microsoft SQL Server 2012/14/16 Reporting Services

This class is temporarily being offered remotely.

at Certstaffix Training - Downtown 355 S Grand Ave Ste 2450, Los Angeles, California 90071

This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data with SELECT queries Generate reports from the Report Wizard and from scratch...

Monday Jun 22nd, 7am - 2pm Pacific Time

  (5 sessions)
$2,925

5 sessions

Analyzing Data with SQL Server Reporting Services

This class is temporarily being offered remotely.

at New Horizons Learning Group LA - Anaheim 1900 S State College Blvd Ste 100, Anaheim, California 92806

The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions. Who Should Attend The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile...

Monday Jun 22nd, 8am - 4pm Pacific Time

  (5 sessions)
$2,975

5 sessions

SQL Server 2014 BI: Application Devt (SSRS, SSIS, SSAS)

This class is temporarily being offered remotely.

at Hands On Technology Transfer, Inc. - Chelsea (Exact location to be announced), New York, New York 00000

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  This hands-on course introduces the SQL Server 2014 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Students start by installing and configuring SQL Server 2014 servers...

Monday Jun 22nd, 9am - 5pm Eastern Time

  (5 sessions)
$2,795

5 sessions

Microsoft SQL Server 2012/14/16 Reporting Services

This class is temporarily being offered remotely.

at Certstaffix Training - Near North Side 205 N Michigan Ave Ste 810, Chicago, Illinois 60611

This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data with SELECT queries Generate reports from the Report Wizard and from scratch...

Monday Jun 22nd, 9am - 4pm Central Time

  (5 sessions)
$2,925

5 sessions

SQL Server 2016 BI: Application Devt (SSRS, SSIS, SSAS)

This class is temporarily being offered remotely.

at Hands On Technology Transfer, Inc. - Chelsea (Exact location to be announced), New York, New York 00000

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  SQL Server Reporting Services 2016 contains significant new functionality and improvements over its predecessors including the new Reporting Services Web portal, support for mobile reports and dashboards, a new HTML5 rendering engine, and exciting...

Monday Jun 22nd, 9am - 5pm Eastern Time

  (5 sessions)
$2,795

5 sessions

SQL Server 2016 Reporting Services

This class is temporarily being offered remotely.

at Hands On Technology Transfer, Inc. - Chelsea (Exact location to be announced), New York, New York 00000

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  SQL Server Reporting Services 2016 contains significant new functionality and improvements over its predecessors including the new Reporting Services Web portal, support for mobile reports and dashboards, a new HTML5 rendering engine, and exciting...

Monday Jun 22nd, 9am - 5pm Eastern Time

  (3 sessions)
$1,795

3 sessions

SQL Server 2017 BI: Application Devt (SSRS, SSIS, SSAS)

This class is temporarily being offered remotely.

at Hands On Technology Transfer, Inc. - Chelsea (Exact location to be announced), New York, New York 00000

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  Full Course Name: SQL Server 2017 Business Intelligence Application Development (SSRS, SSIS, SSAS) This hands-on course introduces the SQL Server 2017 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS)...

Monday Jun 22nd, 9am - 5pm Eastern Time

  (5 sessions)
$2,795

5 sessions

Microsoft SQL Server 2012/14/16 Reporting Services

This class is temporarily being offered remotely.

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

Full Course Name Microsoft SQL Server 2012/14/16 Reporting Services SSRS This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data...

Monday Jun 22nd, 10am - 5pm Eastern Time

  (5 sessions)
$2,925

5 sessions

Microsoft SQL Server 2012/14/16 Reporting Services

This class is temporarily being offered remotely.

at Certstaffix Training - Burlington 67 S Bedford St Ste 400 W, Burlington, Massachusetts 01803

This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data with SELECT queries Generate reports from the Report Wizard and from scratch...

Monday Jun 22nd, 10am - 5pm Eastern Time

  (5 sessions)
$2,925

5 sessions

Loading...