Comprehensive Video Tutorials

MCSE Data Platform SQL 2012 Online Training Bundle

CareerVision Training
Online

£360 - (R$1.576)

Informação importante

  • Curso
  • Online
  • Duração:
    Flexible
  • Quando:
    à escolha
  • Campus online
Descrição

MCSE Data Platform SQL Server 2012 Certification Training:

The following course, offered by Career vision, will help you improve your skills and achieve your professional goals. During the program you will study different subjects which are deemed to be useful for those who want to enhance their professional career. Sign up for more information!

Informação importante
Instalações

Instalações e datas

Início Localização
à escolha
Online

O que se aprende nesse curso?

IT
SQL
MCSE training
MCSE

Programa

PACKAGE INCLUDES: • Instructor Led Video Training - 12 Months Online On-Demand Access
• Demos and Lab Learning
• Multimedia Presentations and Self-Paced Navigation
• Practice Exam and Test Simulator

COURSE DESCRIPTION Demonstrate your broad skill sets in building and administrating enterprise-scale data solutions both on-premises and in cloud environments. Earning an MCSE: Data Platform certification will qualify you for such jobs as database analyst and database designer.

Our MCSE Data Platform SQL 2012 Training Package includes the following exams:

  • 70-461
  • 70-462
  • 70-463
  • 70-464
  • 70-465

As a Microsoft Certified Partner, you can be certain that our comprehensive SQL Server 2012 training courses will provide you with all the tools necessary to successfully prepare for your MCSE Business Intelligence SQL 2012 Certification.

COURSE OUTLINE

MCSE Data Platform SQL Server 2012 Certification Training:

Microsoft Exam 70-461 - Querying SQL Server 2012 Course Curriculum:
Microsoft Exam 70-462 - Administering Microsoft SQL Server 2012 Databases Course Curriculum:
Microsoft Exam 70-463 - Implementing a Data Warehouse with Microsoft SQL Server 2012 Course Curriculum:
Microsoft Exam 70-464 - Developing Microsoft SQL Server 2012 Databases Course Curriculum:
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 Curriculum
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 Filegroups 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