Technology Course


Course Type: Certification | Study Mode: Full-Time
Course Provider:

Course Detail


                                                              Units of study


 Microsoft 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

         SSIS Packages

         Debugging and Error Handling in SSIS

         Deploying and Configuring SSIS Packages

         Securing and Executing SSIS Packages; Service Administration

         Data Analysis

         Extending SSAS Cubes

         Extending SSAS Cubes

         Securing and Administering SSAS

         Working With SSAS Data Mining

         Developing SSAS Reports

         Extending and Deploying SSRS Reports

         Scheduling Deployed Reports and Data Sources

         Configuring And Administering the SSRS Server

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