Fine Tune Your SQL Skills in 2 Days

Join Pragmatic Works as we tour the country with our live two-day sessions on SSIS, SSRS & Performance Tuning.  We target major cities providing affordable SQL training courses sure to be near your local home base. 

Microsoft SQL industry experts delivering quality training. 

Hone Your SQL Expertise

Remote SQL Server, SharePoint and Performance Tuning training classes saving you time and money.  We offer morning and afternoon sessions providing less time away from work at a fraction of the cost.   

 

Increase BI Knowledge in 1 Week

The Pragmatic Works BI Quick Start provides hands on labs teaching you how to build a fully functional prototype data warehouse using SQL Server. We train you on the complete Microsoft BI Platform: SSIS, SSAS, SSRS, and SharePoint BI in 5 days. Our  Business Intelligence courses are taught in major cities throughout the United States.

 

Master SSIS Workshop
I have taken probably 50 training classes in my career and this one was, by far, the best one I've taken. Perfect match for what I was looking for. Great job!

- Peter Tassmer, ConnectiCare

Performance Tuning Workshop
Class was overflowing with value delivered by extremely competent professionals and instructors and I have walked away truly enriched by it.

- Zoran Cvijetic
Sr. SQL Server DBA /
Database Systems Architect
20th Century Fox
Performance Tuning Workshop
If you have the time and money, please take the workshop. You might even learn something like this old IT guy did.

-John F Miner III, Senior SQL Developer at Total Quality Management
Virtual Training

"I'm impressed by the number of examples involved in the training, the affordability of the class, and more than anything, the fact that I can keep a video recording of the training after it's over. Pragmatic Works is the first place I look to and recommend for SQL training. "

Jason Hurley

Virtual Training

"This is the class that got me going on SSRS. The format: a unique combination of an online class where you still could interact personally with the instructor. The class content: Starting from scratch so everyone can keep up. The instructor: I have also taken other Pragmatics webcasts and these people are specialized in BI"

-Philip Leduc

Virtual Training

"The best providers of high quality Microsoft BI related virtual and on-site classes. Their assistance during class, hands-on approach as well as post-class help made for a great experience"

Cosmin Ioan
Sr. Data Architect at Acquinity Interactive

Virtual Training
If you have become or expect to become responsible for SQL Server Analysis Services in your shop you owe it to yourself to take this course.

Bryant Byrd,
Sr. BI Systems Analyst
Eastman Chemical Company

New York City SQL Server 2012 DBA Workshop

Duration: 2 Days
Location: 1290 Avenue of the Americas, Sixth Floor
New York, NY 10104

Training Course Sections

Instructor Date/Time Cost Registration Link

Training Course Overview

SQL Server 2012 is the newest version of SQL Server available from Microsoft. This two day course is designed to introduce SQL Server DBA’s to the new and exciting features available in that version. We use a variety of lab exercises to ensure lecture sessions are backed up by hands-on experience. With the hands-on labs, you will experience how the new features can be utilized in your everyday DBA work. This course will cover topics such as AlwaysOn, column store indexes, SQL Server Data Tools, the FileTable feature, and administering the BI platform within the context of SQL Server 2012.

Training Course Prerequisites

  • Microsoft Windows 7 or Server 2008R2
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server 2012 Developer Edition, Standard Edition or Enterprise Edition with the client tools, SSIS and SSDT
  • AdventureWorks2012 and AdventureWorksDW2012 databases installed on the instance found at www.codeplex.com

Terms & Conditions

A full refund will be provided with seven days advanced written notice prior to the event. Cancellations less than seven days prior to the event will receive Pragmatic Works credit towards another Workshop, Advanced Online Training or Software purchase.

Training Course Outline

Day 1 - Administration and Performance / AlwaysOn and DR:

  • Deprecated and Discontinued features
    • Discontinued features
    • Features not supported in the next version of SQL Server (after 2012)
    • Features not supported in a future version of SQL Server
  • Column Store Indexes
  • DMV's & Extended Events
  • Security
    • Contained databases
    • Custom database roles
    • Auditing
  • SQLOS
    • Full-text search
    • Table partitioning
  • Central Management
  • DRU
  • Availability Groups Setup
  • Using Availability Groups
    • Usage
    • Mirrored databases
    • Types of target databases
  • Clustering enhancements
  • DR Enhancements

Day 2 - Programmability / Administering the BI platform:

  • SSDT (SQL Server Data Tools)
  • DAC Pac’s
  • T-SQL
  • FileTable
  • SSIS (IS Catalog)
  • SSAS Security
  • SSAS admin
    • Deploy
    • Configuration
    • Backup
  • SharePoint Admin
    • Content databases
    • Tuning
    • DR
Copyright 2014 by Pragmatic Works