MCSE Data Platform


SSDN Technologies offers MCSE-Data Platform track for those who intend to build career as a Microsoft Certified Database Experts. The primary focus of this course is you will learn to create database objects that include tables, indexes, views, stored procedures, and functions. Some other important aspects like error handling, triggers, SQL CLR etc. You will get how to plan and build database infrastructure using SQL Server 2014 locally and in cloud environment. Join this course to prepare for the Microsoft Certification Exam also as:

  • Exam 70-464:   Developing Microsoft SQL Server 2012 Databases
  • Exam 70-465:  Designing Database Solutions for SQL Server 2012

Learn to:

After completing, participants should be able to:

  • Know SQL Server platform and its major tools.
  • Work withdatabase objects like Create User and Table, design, implement and troubleshoot security.
  • Work with stored programming objects like design Procedures, Triggers, automation scripts etc.
  • Understand a deadlock situation.
  • Implement appropriate backup strategy for high availability solutions.
  • Learn how to optimise and tune queries to improve the performance.

Audience:

Best suited for:

  • Individuals or Database Administrators maintaining SQL Server 2012 databases.
  • Software Developers who use SQL Server Database
  • Administrator supporting Windows Servers/PCs, Devices, Security Resources, Internet and Cloud services and associated network.

Next Course:

  • MCSE - Business Intelligence.

Duration: 40 Hours

  • Introduction to Database Development

    • Introduction to the SQL Server Platform
    • SQL Server Database Development Tasks
  • Designing and Implementing Tables

    • Designing Tables
    • Working with Schemas
    • Creating and Altering Tables
    • Data Types
    • Partitioning Data
    • Compressing Data
  • Ensuring Data Integrity through Constraints

    • Enforcing Data Integrity
    • Implementing Domain Integrity
    • Implementing Entity and Referential Integrity
  • Introduction to Indexing

    • Core Indexing Concepts
    • Data Types and Indexes
    • Single Column and Composite Indexes
  • Designing Optimized Index Strategies

    • Covering Indexes
    • Managing Indexes
    • Working with Execution Plans
    • Using the DTE
  • Columnstore Indexes

    • Introduction to Column store indexes
    • Creating Columnstore Indexes
    • Working with Column store Indexes
  • Designing and Implementing Views

    • Introduction to Views
    • Creating and Managing Views
    • Performance Considerations for Views
  • Designing and Implementing Stored Procedures

    • Introduction to Stored Procedures
    • Working With Stored Procedures
    • Implementing Parameterized Stored Procedures
    • Controlling Execution Context
  • Designing and Implementing User-Defined Functions

    • Overview of Functions
    • Designing and Implementing Scalar Functions
    • Designing and Implementing Table-Valued Functions
    • Implementation Considerations for Functions
    • Alternatives to Functions
  • Responding to Data Manipulation via Triggers

    • Designing DML Triggers
    • Implementing DML Triggers
    • Advanced Trigger Concepts
  • Using In-Memory Tables

    • Memory-Optimized Tables
    • Native Stored Procedures
  • Implementing Managed Code in SQL Server

    • Introduction to SQL CLR Integration
    • Importing and Configuring Assemblies
    • Implementing SQL CLR Integration
  • Storing and Querying XML Data in SQL Server

    • Introduction to XML and XML Schemas
    • Storing XML Data and Schemas in SQL Server
    • Implementing the XML Data Type
    • Using the T-SQL FOR XML Statement
    • Getting Started with XQuery
  • Working with SQL Server Spatial Data

    • Introduction to Spatial Data
    • Working with SQL Server Spatial Data Types
    • Using Spatial Data in Applications

Duration: 24 Hours

  • Introduction to Enterprise Data Architecture

    • Considerations for Enterprise Data
    • Assessing an Existing Infrastructure
  • Multi-Server Configuration Management

    • Policy-Based Management
    • Microsoft System Center
  • Monitoring SQL Server 2014 Health

    • Introduction to Health Monitoring
    • Data Collector
    • SQL Server Utility
  • Consolidating Database Workloads with SQL Server 2014

    • Considerations for Database Server Consolidation
    • Managing Resources in a Consolidated Database Infrastructure
  • Introduction to Cloud Data Solutions

    • Overview of Cloud Computing
    • SQL Server in a Private Cloud
  • Introduction to High Availability in SQL Server 2014

    • High Availability Concepts and Options in SQL Server 2014
    • Log Shipping
  • Clustering with Windows Server and SQL Server 2014

    • Introduction to Windows Server Failover Clustering
    • SQL Server AlwaysOn Failover Cluster Instances
  • Always On Availability Groups

    • Introduction to AlwaysOn Availability Groups
    • Working with AlwaysOn Availability Groups
    • Considerations for Using AlwaysOn Availability Groups
  • Planning High Availability and Disaster Recovery

    • High Availability and Disaster Recovery with SQL Server 2014
    • SQL Server High Availability and Disaster Recovery Solutions
  • Replicating Data

    • SQL Server Replication
    • Planning Replication
Batch Date Course Duration
Citrix Authorize Learning Center Microsoft Partner Network Summer Training Training Center Amcat Partner Network
Testimonials
Enquiry Button
x

Fill this form to Enquiry us


       5 + 8   =
L G Y