Facebook Twitter Blogger You Tube


MCSA SQL Server 2012 Ultimate Bootcamp (MS 10774, 10775, 10777)

Facebook Share on Facebook
9 Days
MCSA SQL Server 2012 Ultimate Bootcamp (MS 10774, 10775, 10777)

Join our Mailing list


Course At A Glance

This 9-day MCSA: SQL Server 2012 Ultimate Bootcamp package includes all the Microsoft recommended courses to prepare you for the 3 exams required to achieve your MCSA in SQL Ser... READ MORE

Request a Quote


There are currently no scheduled classes.

Try searching for another option from our course list.

Course Locator

Or call us at (623) 570-4309 to request a class near you!

MCSA SQL Server 2012 Ultimate Bootcamp (MS 10774, 10775, 10777)

Course Length: 9 Days

This 9-day MCSA: SQL Server 2012 Ultimate Bootcamp package includes all the Microsoft recommended courses to prepare you for the 3 exams required to achieve your MCSA in SQL Server 2012. Be among the first to achieve this highly valued and sought after certification and boost your resume with the most relevant and up to date credentials.

Demonstrate to potential hiring managers your essential skills and breakthrough insights in developing and maintaining the next wave of mission critical environments by achieving the MCSA: SQL Server 2012 certification. This certification is your first step towards earning an MCSE: Data Platform or MCSE: Business Intelligence certification.

The MCSA: SQL Server 2012 certification validates a set of core SQL Server 2012 skills that are relevant across multiple solution areas.

The data explosion is happening at every level of the business - across devices, applications, and individual roles. Become certified on Microsoft SQL Server and prove your knowledge and skills in designing, building, and maintaining the next wave of cloud-ready database and information solutions.

Benefits of Certification

For IT professionals, certification is a third party validation of your skills, that helps distinguish you from your peers. Beyond demonstrating a level of competency and proficiency, certification proves that you are committed to your cause and that you've invested the time and money to prove it. Holding a certification also makes you a more valuable employee, and often results in raises, promotions, and a better career.

For organizations, certifications identify the credentials that can be used to hire the right employee. Having certified employees also increases sales for the organization by proving to prospective clients that the organization has the skills to support its claims.

Course Objectives

10774: Querying Microsoft SQL Server 2012 Boot Camp (3 days)

  • Write SELECT Queries
  • Query Multiple Tables
  • Use Built-In Functions
  • Use Subqueries
  • Execute Stored Procedures
  • Use Set Operators
  • Implement Error Handling
  • Implementing Transactions
  • Use Table Expressions
  • Sort and Filter Data
  • Use Window Ranking, Offset and Aggregate Functions
  • Query SQL Server Metadata
  • Program with T-SQL
  • Improve Query Performance

10775: Administering Microsoft SQL Server 2012 Databases Boot Camp (3 days)

  • Plan and install SQL Server
  • Describes the system databases, the physical structure of databases and the most common configuration options related to them
  • Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server
  • Create SQL Server Backups
  • Restore SQL Server databases
  • Use the import/export wizards and explain how they relate to SSIS
  • Work with SQL Server security models, logins and users
  • Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles
  • Work with permissions and the assignment of permissions
  • Work with SQL Server Audit
  • Work with SQL Server Agent, jobs and job history
  • Implement SQL Server agent security, proxy accounts and credentials
  • Configure database mail, alerts and notifications
  • Create database maintenance plans
  • Work with SQL Profiler and SQL Trace stored procedures
  • Introduce DMVs and the configuration of data collection
  • Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications
  • Troubleshoot SQL Server databases

10777: Implementing a Data Warehouse with Microsoft SQL Server 2012 Boot Camp (3 days)

  • Describe data warehouse concepts and architecture considerations
  • Select an appropriate hardware platform for a data warehouse
  • Design and implement a data warehouse
  • Implement Data Flow in an SSIS Package
  • Implement Data Flow in an SSIS Package
  • Debug and Troubleshoot SSIS packages
  • Implement an SSIS solution that supports incremental DW loads and changing data
  • Integrate cloud data into a data warehouse ecosystem infrastructure
  • Implement data cleansing by using Microsoft Data Quality Services
  • Implement Master Data Services to enforce data integrity at source
  • Extend SSIS with custom scripts and components
  • Deploy and Configure SSIS packages
  • Describe how information workers can consume data from the data warehouse

MCSA SQL Server 2012 Ultimate Bootcamp (MS 10774, 10775, 10777)

10774: Querying Microsoft SQL Server 2012 Boot Camp (3 days)

Module 1: Introduction to Microsoft SQL Server 2012

  • Describe SQL Server components
  • Create and save T-SQL scripts in SQL Server Management Studio
  • Browse the objects in a database
  • Search T-SQL syntax definitions in Books Online

Module 2: Introduction to Transact-SQL Querying

  • Describe the elements of T-SQL and its role in writing queries
  • Describe the use of sets in SQL Server
  • Describe the use of predicate logic in SQL Server
  • Define the logical order of operations in SELECT statements

Module 3: Writing SELECT Queries

  • Write Simple SELECT statements
  • Eliminate duplicates using the DISTINCT clause
  • Use column and table aliases
  • Write simple CASE expressions

Module 4: Querying Multiple Tables

  • Describe how multiple tables may be queried in a SELECT statement using joins
  • Write queries which use inner joins
  • Write queries which use outer joins
  • Write queries which use self-joins and cross joins

Module 5: Sorting and Filtering Data

  • Filter data with predicates in the WHERE clause
  • Sort data using ORDER BY
  • Filter data in the SELECT clause with TOP
  • Filter data with OFFSET and FETCH
  • Understand and handle NULLs

Module 6: Working with SQL Server Denali Data Types

  • Describe numeric data types, type precedence and type conversions
  • Write queries using character data types
  • Write queries using date and time data types

Module 7: Using Built-In Functions

  • Write queries with built-in scalar functions
  • Use conversion functions
  • Use logical functions
  • Use functions that work with NULL

Module 8: Grouping and Aggregating Data

  • Write queries which summarize data using built-in aggregate functions
  • Use the GROUP BY clause to arrange rows into groups
  • Use the HAVING clause to filter out groups based on a search condition

Module 9: Using Subqueries

  • Use self-contained subqueries, correlated subqueries, scalar subqueries, and multi-valued subqueries
  • Use the IN and EXISTS predicates

Module 10: Using Table Expressions

  • Write queries against views
  • Use derived tables
  • Use common table expressions
  • Use inline table-valued expressions

Module 11: Use Set Operators

  • Describe the difference between a set and a multi-set
  • Use the UNION and UNION ALL operators
  • Use EXCEPT and INTERSECT operators

Module 12: Using Window Ranking, Offset and Aggregate Functions

  • Use window ranking functions ROW_NUMBER, RANK, DENSE_RANK, NTILE
  • Use offset functions LAG, LEAD, FIRST_VALUE, LAST_VALUE
  • Use window aggregate functions
  • Use the basic forms of window partitioning, window ordering and window framing

Module 13: Pivoting and Grouping Sets

  • Use the basic form of PIVOT and UNPIVOT operators
  • Use the fundamental form of GROUPING SETS clause

Module 14: Querying SQL Server Metadata

  • Write queries against system catalog views and functions
  • Execute system stored procedures
  • Identify and query system dynamic management objects
  • Describe security permissions necessary to query system objects

Module 15: Executing Stored Procedures

  • Invoke existing stored procedures with EXECUTE
  • Pass input parameters and receive output parameters
  • Generate dynamic SQL statements

Module 16: Programming with T-SQL

  • Understand where T-SQL programming objects can be used
  • Declare variables and delimit batches
  • Use control of flow elements such as IF, WHILE, BEGIN, END, RETURN
  • Use synonyms

Module 17: Implementing Error Handling

  • Describe the behavior of SQL Server when errors occur in T-SQL code
  • Use TRY/CATCH blocks to handle error flow
  • Understand ERROR class functions

Module 18: Implementing Transactions

  • Describe the benefits of using transactions
  • Control transactions with BEGIN, COMMIT, ROLLBACK
  • Describe error handling behavior in transactions

Module 19: Improving Query Performance

  • Describe how SQL Server uses indexes to support query execution
  • Enable the display of execution plans in SQL Server Management Studio
  • Enable system IO and time information in query results
  • Describe the differences between accessing data in sets versus via cursors

10775: Administering Microsoft SQL Server 2012 Databases Boot Camp
(3 days)

Module 1: Introduction to SQL Server 2012 and its Toolset

  • Introduction to the SQL Server Platform
  • Working with SQL Server Tools
  • Configuring SQL Server Services

Module 2: Preparing Systems for SQL Server 2012

  • Overview of SQL Server Architecture
  • Planning Server Resource Requirements
  • Pre-installation Testing for SQL Server

Module 3: Installing and Configuring SQL Server 2012

  • Preparing to Install SQL Server
  • Installing SQL Server
  • Upgrading and Automating Installation

Module 4: Working with Databases

  • Overview of SQL Server Databases
  • Working with Files and Filegroups
  • Moving Database Files

Module 5: Understanding SQL Server 2012 Recovery Models

  • Backup Strategies
  • Understanding SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy

Module 6: Backup of SQL Server 2012 Databases

  • Backing up Databases and Transaction Logs
  • Managing Database Backups
  • Working with Backup Options

Module 7: Restoring SQL Server 2012 Databases

  • Understanding the Restore Process
  • Restoring Databases
  • Working with Point-in-time recovery
  • Restoring System Databases and Individual Files

Module 8: Importing and Exporting Data

  • Transferring Data To/From SQL Server
  • Importing & Exporting Table Data
  • Inserting Data in Bulk

Module 9: Authenticating and Authorizing Users

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers

Module 10: Assigning Server and Database Roles

  • Working with Server Roles
  • Working with Fixed Database Roles
  • Creating User-defined Database Roles

Module 11: Authorizing Users to Access Resources

  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level

Module 12: Auditing SQL Server Environments

  • Options for Auditing Data Access in SQL
  • Implementing SQL Server Audit
  • Managing SQL Server Audit

Module 13: Automating SQL Server 2012 Management

  • Automating SQL Server Management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs

Module 14: Configuring Security for SQL Server Agent

  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts

Module 15: Monitoring SQL Server 2012 with Alerts and Notifications

  • Configuration of Database Mail
  • Monitoring SQL Server Errors
  • Configuring Operators, Alerts and Notifications

Module 16: Performing Ongoing Database Maintenance

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance

Module 17: Tracing Access to SQL Server 2012

  • Capturing Activity using SQL Server Profiler
  • Improving Performance with the Database Engine Tuning Advisor
  • Working with Tracing Options

Module 18: Monitoring SQL Server 2012

  • Monitoring Activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data

Module 19: Managing Multiple Servers

  • Working with Multiple Servers
  • Virtualizing SQL Server
  • Deploying and Upgrading Data-Tier Applications

Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues

  • SQL Server Troubleshooting Methodology
  • Resolving Service-related Issues
  • Resolving Concurrency Issues
  • Resolving Login and Connectivity Issues

10777: Implementing a Data Warehouse with Microsoft SQL Server 2012 Boot Camp (3 days)

Module 1: Introduction to Data Warehousing

  • Describe data warehouse concepts and architecture considerations
  • Considerations for a Data Warehouse Solution

Module 2: Data Warehouse Hardware Considerations

  • The Challenges of Building a Data Warehouse
  • Data Warehouse Reference Architectures
  • Data Warehouse Appliances

Module 3: Designing and Implementing a Data Warehouse

  • Logical Design for a Data Warehouse
  • Physical Design for a Data Warehouse

Module 4: Design and implement a schema for a data warehouse

  • Introduction to ETL with SSIS
  • Exploring Source Data
  • Implementing Data Flow

Module 5: Implementing Control Flow in an SSIS Package

  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Managing Consistency

Module 6: Debugging and Troubleshooting SSIS Packages

  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package

Module 7: Implementing an Incremental ETL Process

  • Introduction to Incremental ETL
  • Extracting Modified Data
  • Loading Modified Data

Module 8: Incorporating Data from the Cloud in a Data Warehouse

  • Overview of Cloud Data Sources
  • SQL Server Azure
  • Azure Data Market

Module 9: Enforcing Data Quality

  • Introduction to Data Cleansing
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data

Module 10: Using Master Data Services

  • Master Data Services Concepts
  • Implementing a Master Data Services Model
  • Using the Master Data Services Excel Add-in

Module 11: Extending SSIS

  • Using Custom Components in SSIS
  • Using Scripting in SSIS

Module 12: Deploying and Configuring SSIS Packages

  • Overview of Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution

Module 13: Consuming Data in a Data Warehouse

  • Using Excel to Analyze Data in a data Warehouse
  • An Introduction to PowerPivot
  • An Introduction to Crescent

MCSA: SQL Server 2012

MCSA: SQL Server 2012

The skills for your professional career

Demonstrate your essential skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments.

Earning an MCSA: SQL Server 2012 certification will qualify you for a position as a database developer or database analyst.


Exam title

Optional training

Required exam


Querying Microsoft SQL Server 2012



Administering Microsoft SQL Server 2012 Databases



Implementing a Data Warehouse with Microsoft SQL Server 2012



Training and Certification Courses and Bootcamps in VMware | Microsoft Technical | Microsoft Developer | Microsoft Sharepoint | Security | Cisco | Citrix