MCSE: Business Intelligence

$595.13
(No reviews yet) Write a Review

This certification provides you the skills, techniques and opportunities required to build, deploy and design solutions. These solutions deliver more data across the entire organization.

  • 1 x Microsoft 70-461: Querying SQL Server 2012  
  • 1 x Microsoft 70-462: Administering SQL Server 2012 Databases  
  • 1 x Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012  
  • 1 x Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012  
  • 1 x Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012  

For More Information E-Mail us at info@itbc.co.za

________________________________________________________________________________________________________

Microsoft Exam 70-461: Querying Microsoft SQL Server 2012 Certification Training Course Curriculum:

Instructor Introduction
Course Outline

 

Module 1

Introduction to SQL Server 2012
SQL Instances
Editions and Licensing
SQL Server Objects
System Databases
SQL Server Data Tools
Object Explorer
Object Scripting
Template Explorer
Query Tabs
Projects and Solutions
Customizing SSDT
Debugging T-SQL
SQLCMD
Exam Scenarios
Module Review

Module 2

T-SQL Overview
T-SQL Elements
Batch Separators
Line Terminator
Variables
Control Flow
Expressions
Functions
Predicates and Operators
SELECT
Column Aliasing
SELECT Execution
Exam Scenarios
Module Review

Module 3

SELECT Statements
Basic SELECT Statement
Specifying Columns
Derived Columns
Aliasing Columns
Calculated Columns
Ordering Results
Returning Distinct Results
Exam Scenarios
Module Review

Module 4

Filtering
WHERE Syntax
BETWEEN
WHERE Syntax IN
Filtering NULL Values
LIKE
Data Type Comparison
Filtering Data with WHERE
TOP
OFFSET-FETCH
Exam Scenarios
Module Review

Module 5

Join and Set Operators
Using Joins
Categories of Joins
INNER JOIN
OUTER JOIN
JOIN Demo
Set Operators
Set Operators Demo
Exam Scenarios
Module Review

Module 6

Subqueries and Table Expressions
Subqueries
Self Contained Subquery
Correlated Subquery
Subquery Demo
EXISTS
Common Table Expressions
Temporary Tables
Table Variables
Table Demo
Exam Scenarios
Module Review

Module 7

System Functions
Scalar Functions
ROWSET
System Function Demo
Aggregate Functions
DISTINCT
Aggregation Demo
GROUP BY
HAVING
Conversion Functions
Exam Scenarios
Module Review

Module 8

T-SQL Programming
Logical Functions
IIF, CHOOSE and CASE
Logical Function Demo
Using Views
Stored Procedures
Functions
Triggers
Views Demo
TRY CATCH
Exam Scenarios
Module Review

Module 9

Transactions
Introduction to Transactions
INSERT and UPDATE
DELETE and TRUNCATE
Transactions Demo
Managing Transactions
XACT_ABORT
Managing Transactions Demo
Exam Scenarios
Module Review

Module 10

Query Performance
Indexing
Index Strategies
Indexes Demo
Execution Plans
Statistics IO
Execution Plans Demo
Exam Scenarios
Module Review
Program Review