Technology Course

MCSA SQL SERVER 2012 (LIVE LABS INCLUDED)

Course Type: Certification | Study Mode: Full-Time
Keywords: MCSA SQL SERVER 2012 LIVE LABS INCLUDED
Course Provider:

Course Detail

Introduction
Units of study

 

 

Microsoft 70-461: Querying SQL Server 2012

         Getting Started with SQL Server 2012

         Working with T-SQL

         Writing SELECT Queries

         Working with SQL Data Types

         Sorting and Filtering Data

         Querying Data from Multiple Tables

         Modifying Data

         Working with SQL Server Built-in Functions

         Programming in T-SQL

         Implementing Stored Procedures

         Working with Subqueries and Table Expressions

         Working with Set Operators, Conditional Operators, and Window Functions

         Working with PIVOT, UNPIVOT, and Grouping Sets

         Managing Error Handling and Transactions

         Querying SQL Server System

         Optimizing Query Performance

Microsoft 70-462: Administering SQL Server 2012 Databases

         Identifying the SQL Server Platform

         Deploying SQL Server

         Configuring SQL Server

         Managing Databases in SQL Server 2012

         Managing SQL Server Security

         Implementing Advanced Security Settings

         Applying Encryption and Compression

         Working with Indexes and Log Files

         Working with Backup and Restore

         Implementing High Availability

         Optimizing Server Performance

         Troubleshooting Issues and Recovering Databases

         Performing Advanced Database Management Tasks

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

         Introduction to Data Warehouse

         Creating Dimensions and Changing Granularity of Dimensions

         Creating Fact Tables and ColumnStore Indexes

         Implementing Data Warehouse in SQL Server 2012

         Working with Integration Services

         Managing Control Flow

         Working with Dynamic Variables

         Implementing Data Flow

         Managing Data Flow

         Managing SSIS Package Execution

         Debugging and Troubleshooting

         Deploying Packages

         Securing Packages and Databases

         Working with MDS and Windows