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


MCSE: Data Platform

MCSE: Data Platform

R4,790.00
Qty:  Add to Cart  
Product Code: MCSE: Data Platform
Reward Points: 0
Availability: In Stock
Tags: ,

MCSE: Data Platform

  • 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-464: Developing Microsoft SQL Server 2012 Databases  
  • 1 x Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012  
Course Outline

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 Microsoft 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 Exam 70-464: Developing Microsoft SQL Server 2012 Databases
Course Outline

Module 1

  • Introduction to SQL Server 2012
  • SQL Instances
  • SQL Editions
  • SQL Server Tools
  • SQL Server Management Studio
  • SQL Data Tools
  • SQL Command
  • Utilizing SQL Server Tools
  • Exam Scenarios
  • Module Review

Module 2

  • Introduction to Data Types and Tables
  • Collations
  • Unicode Characters
  • Null Values
  • Converting Data Types
  • Introduction to Tables
  • Normalization
  • Temporary Tables
  • Working with Tables
  • Schemas
  • Primary and Foreign Keys
  • UNIQUE Constraint/Index
  • In Depth Look
  • Exam Scenarios
  • Module Review

Module 3

  • SQL Server Indexing
  • Introduction to Indexing
  • Clustered Indexes
  • Non Clustered Indexes
  • Maintaining Indexes
  • Index Fragmentation
  • Index Tuning
  • Creating and Altering Indexes
  • Exam Scenarios
  • Module Review

Module 4

  • Query Performance
  • Execution Plans
  • Reading Execution Plans
  • Execution Plan Operators
  • Plan Reuse
  • Query Performance
  • Exam Scenarios
  • Module Review

Module 5

  • Common Language Runtime (CLR) Integration
  • Assemblies
  • Permissions
  • CLR Objects
  • Integrating the CLR within SQL Server
  • Exam Scenarios
  • Module Review

Module 6

  • Transact-SQL (T-SQL) Error Handling
  • Error Severity
  • TRY CATCH Error Handling
  • TRY PARSE and TRY CONVERT
  • @@ ERROR
  • Alerts
  • Error Handling in T-SQL
  • Exam Scenarios
  • Module Review

Module 7

  • Views and Functions
  • Types of Views
  • Working with Views
  • Introduction to Functions
  • Working with Functions
  • Working with Views and Functions
  • Exam Scenarios
  • Module Review

Module 8

  • Stored Procedures and Triggers
  • Working with Stored Procedures
  • Introduction to Triggers
  • Working with Triggers
  • Stored Procedures and Triggers Demo
  • Exam Scenarios
  • Module Review

Module 9

  • Working with XML
  • XML Concepts
  • Schemas and Schema Collections
  • FOR XML Clause
  • FLOWR Queries
  • Working with XML in SQL Server
  • Exam Scenarios
  • Module Review

Module 10

  • Transactions
  • Implicit Transactions
  • Explicit Transactions
  • Locking
  • Working with Transactions and Locking within SQL
  • Exam Scenarios
  • Module Review
  • Course Review

Microsoft Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012
Course Outline

Module 1

  • Course Introduction
  • Course Modules
  • Introduction to SQL Server 2012
  • SQL Server Instances
  • SQL Server Editions and Licensing
  • SQL Server Objects
  • System Databases
  • SQL Server Management Studio
  • SSMS Components
  • SQL Server Data Tools
  • SQLCMD
  • Working with SSMS
  • Working with SQLCMD
  • Exam Scenarios
  • Module Review

Module 2

  • Introduction to Databases
  • Database Files
  • Temp db
  • Working with Databases
  • Introduction to File groups and Files
  • Introduction to Log Files
  • Transactions
  • Moving Databases
  • Detaching and Attaching Databases
  • Backing Up and Restoring Databases
  • Copy Database Wizard
  • Database Catalog View
  • Creating and Configuring Databases
  • Exam Scenarios
  • Module Review

Module 3

  • Introduction to Data Types and Tables
  • Supported Data Types
  • Collations and Unicode Characters
  • Introduction to NULLS
  • Converting Data Types
  • Introduction to Tables
  • Normalization
  • Temporary Tables
  • Working with Tables
  • Schemas
  • Primary and Foreign Keys
  • UNIQUE Constraint/Index
  • Data Types in SQL Server Demonstration
  • Working with Tables Demonstration
  • Exam Scenarios
  • Module Review

Module 4

  • SQL Server Indexing
  • Introduction to Indexing
  • Heaps
  • Clustered Indexes
  • Non-Clustered Indexes
  • Maintaining Indexes
  • Index Fragmentation
  • SQL Server Profiler
  • Index Tuning
  • Working with Indexes Demonstration
  • SQL Server Tuning Advisor Demonstration
  • Exam Scenarios
  • Module Review

Module 5

  • Performance Considerations
  • Partitioning Function
  • Partition Scheme
  • Partitioned Table or Index
  • Introduction to Transaction
  • Implicit and Explicit Transactions
  • Locking
  • Working with Partition Tables, Transaction and Locks
  • Exam Scenarios
  • Module Review

Module 6

  • Backup and Restore
  • Database Data and Log Files
  • Recovery Model
  • Database Backups Types
  • Backup Compression and Mirrored Media Sets
  • Verifying Backups
  • Restoration Process
  • Restoring Backup Types
  • Restoring to a Point in Time
  • WITH STANDBY
  • Restoring a Database
  • Restoring System Databases
  • Restoring the Master Database
  • Backing Up and Restoring SQL Server
  • Exam Scenarios
  • Module Review

Module 7

  • Views and Functions
  • Types Of Views
  • Creating and Altering Views
  • Updatable and Indexed Views
  • Partitioned Views
  • Introduction to Functions
  • Function Types
  • Scalar and Table Valued Functions
  • Working with Views and Functions
  • Exam Scenarios
  • Module Review

Module 8

  • Stored Procedures and Triggers
  • Types of Stored Procedures
  • Parameters
  • Stored Procedure Compilation
  • Execution Context
  • Introduction to Triggers
  • Types of Triggers
  • Nested and Recursive Triggers
  • Trigger Firing Order
  • Working with Stored Procedures and Triggers
  • Exam Scenarios
  • Module Review

Module 9

  • SQL Server Security
  • SQL Authentication
  • SQL Logins
  • Accessing a Database
  • Authorization Across Servers
  • Server Roles
  • Database Roles
  • Application Roles
  • Authorizing Access
  • Configuring Access Using Schemas
  • Working with SQL Security
  • Exam Scenarios
  • Module Review

Module 10

  • Installing and Upgrading SQL
  • Server Resources
  • 32 vs. 64 Bit
  • SQL Requirements
  • Software Requirements
  • Collations
  • Service Accounts
  • Installing SQL Server
  • Troubleshooting Installation
  • Upgrading SQL Server
  • Unattended Installations
  • 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: