Welcome visitor you can login or create an account.
£ R $
Your shopping cart is empty!


MCSE: Business Intelligence

MCSE: Business Intelligence

R7,999.00
Qty:  Add to Cart  
Product Code: MCSE: Business Intelligence
Reward Points: 0
Availability: In Stock
Tags: ,

MCSE: Business Intelligence

  • 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  
Course Outline

Microsoft Exam 70-461: Querying SQL Server 2012
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

  • Sub queries and Table Expressions
  • Sub queries
  • Self Contained Sub query
  • Correlated Sub query
  • Sub query 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

Microsoft Exam 70-462: Administering SQL Server 2012 Databases
Course Outline

Module 1

  • Introduction to SQL Server 2012
  • SQL Server
  • SQL Server Tools
  • Management Studio Demo
  • Data Tools
  • Exam Scenarios
  • Module Review

Module 2

  • Installing SQL Server
  • SQL Architecture
  • Hardware Requirements
  • Software Requirements
  • Installation Process
  • Troubleshooting Installation
  • Upgrading and Unattended Installations
  • Configuration Demo
  • Exam Scenarios
  • Module Review

Module 3

  • Backup and Restore a Database
  • Database Architecture
  • Database Backup
  • Restoration Process
  • Restoring System Database
  • Backup and Recovery Demo
  • Exam Scenarios
  • Module Review

Module 4

  • Tracing Access to SQL Server
  • Auditing Options
  • Introduction to SQL Audit
  • Audit Objects and Implementation
  • Extended Events
  • Tracing Activity Demo
  • Exam Scenarios
  • Module Review

Module 5

  • Importing and Exporting Data
  • Introduction to Data Transfer
  • ETL Tools
  • Improving Data Transfer
  • Copying Database Methods
  • Transferring Data Demo
  • Exam Scenarios
  • Module Review

Module 6

  • SQL Server Security
  • Security and Authentication
  • Server and Database Roles
  • Permissions
  • Securing SQL Server Demo
  • Exam Scenarios
  • Module Review

Module 7

  • Automating SQL Server
  • SQL Server Agent
  • Database Mail
  • Operators, Alerts and Jobs
  • Database Configuration Demo
  • Exam Scenarios
  • Module Review

Module 8

  • Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Profiler Trace
  • Database Tuning Advisor
  • Activity and Performance Monitor
  • Data Collection
  • Monitoring Demo
  • Exam Scenarios
  • Module Review

Module 9

  • Maintaining SQL Server
  • Checking Database Integrity
  • Indexing
  • Ongoing Maintenance
  • Managing and Maintaining Demo
  • Exam Scenarios
  • Module Review

Module 10

  • Troubleshooting SQL Server
  • Service Issues
  • Connectivity Issues
  • Locking Issues
  • Troubleshooting Demo
  • Exam Scenarios
  • Module Review
  • Program Review

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

Module 1

  • Introduction to Data Warehousing
  • OLTP vs. OLAP
  • Data Warehouse
  • Data Warehouse Architecture
  • Creating a Data Warehouse
  • Presenting OLAP Data
  • OLTP and OLAP Comparison Demonstration
  • Exam Scenarios
  • Module Review

Module 2

  • Designing a Data Warehouse
  • Data Modelling
  • Data Warehouse Schemas
  • Time Dimensions
  • Data Modelling Considerations
  • Implementing a Data Model
  • Logical Model
  • Physical Model
  • Dimensions and Facts
  • Exam Scenarios
  • Module Review

Module 3

  • ETL with SSIS
  • Introduction to SSIS
  • Upgrading SSIS Packages
  • SSIS Tools
  • Data Flow Tasks
  • Data Sources
  • Transformations
  • Utilizing SQL Server Data Tools
  • Data Flow Task
  • Exam Scenarios
  • Module Review

Module 4

  • SSIS Control Flow
  • Control Flow Tasks
  • Integration Services Variables
  • Expressions
  • Precedence
  • Containers and Annotation
  • Transactions
  • Checkpoints
  • Control Flow Tasks and Precedence
  • Exam Scenarios
  • Module Review

Module 5

  • Troubleshooting Packages
  • Overview of Troubleshooting
  • Debugging
  • Breakpoints
  • Error Handling
  • SSIS Log Providers
  • Custom Logging
  • Troubleshooting and Logging
  • Exam Scenarios
  • Module Review

Module 6

  • Advanced Packages
  • Maintaining a Data Warehouse
  • Change Data Capture
  • Slowly Changing Dimensions
  • Script Components
  • Incremental Updates
  • Exam Scenarios
  • Module Review

Module 7

  • Data Quality Services
  • Introduction to Data Quality Services
  • Data Quality Services Components
  • Working with Data Quality Services
  • Exam Scenarios
  • Module Review

Module 8

  • Master Data Services
  • Introduction to Master Data Services
  • MDS vs. DQS
  • How MDS Works
  • Exam Scenarios
  • Module Review

Module 9

  • Deployment and Security
  • Deployment Options

Package Deployment

  • Securing Packages
  • Deploying SSIS Packages and Projects
  • Exam Scenarios
  • Module Review
  • Program Review

Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
Course Outline

Module 1

  • Course Introduction
  • Course Modules
  • SQL Server 2012 Business Intelligence
  • Introduction to Business Intelligence
  • Data Warehouse
  • Extract, Transform and Load (ETL)
  • SQL Server Integration Services
  • SQL Server 2012 BI Tools
  • Developer Tools
  • Exam Scenarios

Module 2

  • SQL Server Reporting Services
  • Introduction to SSRS
  • Creation and Delivery
  • SSRS Reports
  • Report Grouping
  • Expressions
  • Drilldown Report
  • Parameters
  • Visual Components
  • Creating SQL Server
  • Exam Scenarios
  • Module Review

Module 3

  • SSRS Management
  • Deploying Reports
  • Report Security
  • Executing Reports
  • Report Caching
  • Report Snapshot
  • Subscriptions
  • Data Alerts
  • Managing Reporting Services
  • Exam Scenarios
  • Module Review

Module 4

  • Multidimensional Cubes
  • Introduction to Cubes
  • Cube Components
  • Creating and Configuring Analysis Services Cube
  • Exam Scenarios
  • Module Review

Module 5

  • Advanced Cube Concepts
  • Measures
  • Formatting Measures
  • Measure Groups
  • Measure Group Storage
  • Aggregations
  • Dimensions
  • Dimension Storage
  • Hierarchies
  • Grouping and Sorting
  • Working with Measures
  • Exam Scenarios
  • Module Review

Module 6

  • Customizing Cubes and Security
  • Actions
  • Perspectives
  • Key Performance Indicators
  • Translations
  • SSAS Security
  • Cell Permissions
  • Dimension Permissions
  • Customizing Cubes and Cube Security
  • Exam Scenarios
  • Module Review

Module 7

  • MultiDimensional eXpressions (MDX)
  • Introduction to MDX
  • Why Use MDX?
  • DX Syntax
  • MDX Queries and Filters
  • Sets
  • Applying MDX
  • Working with MDX
  • Exam Scenarios
  • Module Review

Module 8

  • Tabular Data Models
  • Introduction to TDM
  • PowerPivot
  • Linked and Non-Linked Tables
  • PowerPivot
  • Server Based Tabular Data Models
  • Creating a Tabular Data Model
  • Workspace Database
  • Tabular Data Model
  • Working with Tabular Data Modeling
  • Exam Scenarios
  • Module Review

Module 9

  • Data Analysis eXpressions (DAX)
  • Introduction to DAX
  • Working with DAX
  • DAX Functions
  • DAX Queries
  • Calculated Columns
  • Measures
  • Multiple Relationships
  • Working with DAX within PowerPivot
  • Exam Scenarios
  • Module Review

Module 10

  • Data Mining
  • Introduction to Data Mining
  • Data Mining Algorithms
  • Data Mining Components
  • Validating Mining Models
  • Presenting Mining Data
  • Creating a Mining Structure
  • Exam Scenarios
  • Module Review
  • Course Review

Microsoft Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012 
Course Outline

Module 1

  • Course Introduction
  • Course Modules
  • Introduction to Data Warehousing
  • On-Line Transaction Processing (OLTP) vs. OLAP
  • Data Warehousing
  • Data Warehouse Architecture
  • Creating a Data Warehouse
  • Presenting On-Line Analytical Processing (OLAP) Data
  • OLTP vs. OLAP Demonstration
  • Exam Scenarios
  • Module Review

Module 2

  • Designing a Data Warehouse
  • Data Modeling
  • Data Warehouse Schemas
  • Time Dimensions
  • Data Modeling Considerations
  • Implementing a Data Model
  • Logical Model
  • Physical Model
  • Working with Dimensions and Fact Tables
  • Exam Scenarios
  • Module Review

Module 3

  • Extraction, Transformation, and Load (ETL) with SSIS
  • Introduction to SQL Server Integration Services (SSIS)
  • Upgrading SSIS Packages
  • SSIS Tools
  • Introduction to Data Flow Tasks
  • Data Sources
  • Transformations
  • Destinations
  • Control Flow
  • Variables
  • Expressions
  • Precedence
  • Containers
  • Control Flow Containers
  • Transactions
  • Package Execution with Checkpoints
  • Working with SSIS Packages
  • Exam Scenarios
  • Module Review

Module 4

  • Deploying and Securing Packages
  • Deploying Options
  • Deploying Packages
  • Deploying Projects
  • Securing Packages
  • Deploying and Securing Packages
  • Exam Scenarios
  • Module Review

Module 5

  • SQL Server Reporting Services (SSRS)
  • Introduction to Reporting Services
  • SSRS Reports Creation and Delivery
  • SSRS Reports
  • Grouping
  • Expressions
  • Drilldown
  • Parameters
  • Drillthrough
  • Visual Components
  • Creating Reports Within Reporting Services
  • Exam Scenarios
  • Module Review

Module 6

  • SSRS Reports
  • Deploying Reports
  • Report Security
  • Report Execution
  • Report Caching
  • Report Snapshot
  • Subscriptions
  • Data Alerts
  • Deploying Reports and Report Security
  • Exam Scenarios
  • Module Review

Module 7

  • Multidimensional Cubes
  • Introduction to Cubes
  • Components of a Multidimensional Cubes
  • Measures
  • Measure Format and Aggregation Functions
  • Measure Groups
  • Aggregations
  • Dimensions
  • Dimension Storage
  • Dimensions Hierarchies
  • Grouping and Sorting
  • Actions
  • Perspectives
  • Key Performance Indicators
  • Translations
  • SSAS Security
  • Cell Permissions
  • Dimension Permissions
  • Creating and Configuring a Cube
  • Exam Scenarios
  • Module Review

Module 8

  • Tabular Data Models
  • Introduction to Tabular Data Models
  • PowerPivot
  • Working with PowerPivot
  • Linked and Non-Linked Tables
  • PowerPivot Features
  • Server Based Tabular Data Models
  • Creating a Tabular Data Model
  • Tabular Models with SSDT
  • Workspace Database
  • Tabular Data Model
  • Tabular Data Model Security
  • Creating a Tabular Data Model Using PowerPivot
  • Exam Scenarios
  • Module Review

Module 9

  • MDX/DAX
  • Introduction to Multidimensional Expressions (MDX)
  • Why Use MDX?
  • MDX Syntax
  • Sets
  • Where is MDX Used?
  • Introduction to Data Analysis eXpressions (DAX)
  • Working with DAX
  • DAX Functions
  • DAX Queries
  • Calculated Columns
  • DAX Measures
  • Multiple Relationships
  • Exam Scenarios
  • Module Review

Module 10

  • Data Mining
  • Introduction to Data Mining
  • Data Mining Algorithms
  • Data Mining Components
  • Validating and Presenting Data Mining Models
  • Creating a Data Mining Model
  • Exam Scenarios
  • Module Review
  • Course Review

Write a review

Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad            Good

Enter the code in the box below: