Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

MCSE - Data Platform

( Duration: 5 Days )

By attending MCSE - Data Platform workshop, delegates will learn:

  • The technical skills required to develop Microsoft SQL Server Databases including database objectives, logical table design, indexing, query plans, procedure coding
  • The knowledge and skills to design solutions for Microsoft SQL Server including how to plan and design a database structure, storage, objects and servers along with how to design and monitor high performance, highly available data solutions, data migration, security and scalability
  • Key topics and concepts addressed in the exams 70-464 - Developing Microsoft SQL Server 2012 and 70-465 - Designing Database Solutions for Microsoft SQL Server 2012

  • MCSA - SQL Server 2012 certification or equivalent knowledge
  • Three years of hands-on experience working in a SQL Server environment
  • Basic knowledge of the Microsoft Windows operation system and its core functionality

This MCSE - Data Platform training course is intended for:

  • IT Professionals with at least three years of hands-on experience implementing and administering database systems
  • Database Administrators, Systems Engineers, Systems Analysts and Technical Consultants who have completed the MCSA - SQL Server 2012 certification or have equivalent knowledge
  • IT Professionals who want to prepare for the MCSE - Data Platform certification

COURSE AGENDA

Developing Microsoft SQL Server Databases

1

An Introduction to Database Development

  • SQL Server Platform
  • SQL Server Tools
  • Configuring SQL Server Services
Designing Database Solutions for Microsoft SQL Server

1

Introduction to SQL Server 2014

  • Overview of SQL Server 2014
  • SQL Server 2014 Editions and Components
  • Installing SQL Server 2014
  • Enhancements to SQL Server Management Studio
2

Designing and Implementing Tables

  • Designing Tables
  • Working with Schemas
  • Creating and Altering Tables
2

What's New in SQL Server Database Development

  • Transact-SQL Enhancements and Functions
  • Enhancements to Spatial Data Support
  • Storing and Querying Documents with SQL Server 2014
3

Ensuring Data Integrity through Constraints

  • Enforcing Data Integrity
  • Implementing Domain Integrity
  • Implementing Entity and Referential Integrity
3

In-Memory Database Capabilities

  • The Buffer Pool Extension
  • Columnstore Indexes and Memory-Optimized Tables
4

Introduction to Indexes

  • Core Indexing Concepts
  • Single Column and Composite Indexes
  • SQL Server Table Structures and Clustered Indexes
4

Scripting SQL Server 2014

  • Dynamic Management Views
  • Manage SQL Server using PowerShell
5

Advanced Indexing

  • Execution Plan Concepts and Elements
  • INCLUDE Clause, Padding, Hints, and Statistics
  • Designing Effective Non-Clustered Indexes
  • Performance Monitoring and the Database Engine Tuning Advisor
5

Implementing Security in Microsoft SQL Server 2014

  • Security Management Enhancements
  • Contained Databases
6

In-Memory Database Capabilities

  • Buffer Pool Extension
  • Columnstore Indexes
6

High Availability and Data Recovery Enhancements

  • AlwaysOn High Availability
  • Enhancements to Data Recovery
7

Designing and Implementing Views

  • Views
  • Creating and Managing Views
  • Performance Considerations for Views
7

Introduction to Cloud Data Solutions

  • Overview of Cloud Computing
  • Microsoft Azure Services for Data
8

Designing and Implementing Stored Procedures

  • Stored Procedures
  • Working with Stored Procedures
  • Implementing Parameterized Stored Procedures
  • Controlling Execution Context
8

Microsoft Azure SQL Database

  • Introduction to Microsoft Azure SQL Database
  • Microsoft Azure SQL Database Security
  • Implementing and Managing Databases
9

Designing and Implementing User-Defined Functions

  • Functions
  • Designing and Implementing Scalar and Table-Valued Functions
  • Implementation Considerations for Functions
  • Alternatives to Functions
9

SQL Server in Microsoft Azure Virtual Machines

  • Introduction to Microsoft Azure Virtual Machines
  • Microsoft Azure Virtual Machine Connectivity and Security
  • Creating Databases in a Microsoft Azure Virtual Machine
10

Responding to Data Manipulation via Triggers

  • Designing and Implementing DML Triggers
  • Advanced Trigger Concepts
11

Using In-Memory Tables

  • Memory-optimized Tables
  • Natively compiled Stored Procedures
12

Implementing Managed Code in SQL Server

  • SQL CLR Integration
  • Importing and Cataloging Assemblies
  • Implementing SQL CLR Integration
13

Storing and Querying XML Data in SQL Server

  • XML and XML Schemas
  • Storing XML Data and XML Schemas in SQL Sever
  • Implementing XML Indexes
  • Using the T-SQL for XML Statement
  • Getting Started with Xquery
  • Shredding XML
14

Working with SQL Server Spatial Data

  • Spatial Data
  • Working with SQL Server Spatial Data Types
  • Using Spatial Data in Applications
15

Incorporating Data Files into Databases

  • Considerations for Working with Data Files in SQL Server 2014Implementing FILESTREAM and FileTables
  • Searching Data Files

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X