Technology Course

MCSE SQL SERVER 2012 SHAREPOINT (LIVE LABS INCLUDED)

Course Type: Certification | Study Mode: Full-Time
Keywords: MCSE SERVER | 2012 SHAREPOINT WITH LIVE LABS
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