MCSE: Data Platform SQL Server 2012 Training & Certification (Boot Camp - 6 Days)
  • Overview
  • Certifications
  • Curriculum
  • What’s Included
  • Schedule
  • Testimonials
  • View Comments

Program Description:

Demonstrate your broad skill sets in building and administrating enterprise-scale data solutions both on-premises and in cloud environments to achieving the MCSE: Data Platform SQL Server Certification.

The MCSE: Data Platform training is an intense deep dive into all aspect of SQL Server 2012 including Developing Microsoft SQL Server 2012 Databases and Designing Database Solutions for Microsoft SQL Server 2012.

Audience Profile

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2012 product features and technologies for implementing a database.

 

Course Covers

·         Course 10776A: Developing Microsoft SQL Server 2012 Databases

·         Course 20465A: Designing Database Solutions for Microsoft SQL Server 2012

 

MCSE: Data Platform Training will prepare you for the following exams:

·         70-464: Developing Microsoft SQL Server 2012 Databases

·         70-465: Designing Database Solutions for Microsoft SQL Server 2012

 Note: Student must have achieved the MCSA: SQL Server 2012 Certification to achieve the MCSE: Data Platform Certification.

 

What you will learn:

 

Course 10776A: Developing Microsoft SQL Server 2012 Databases

Exam 70-464: Developing Microsoft SQL Server 2012 Databases

 

This training introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course. Also this will help to prepare for the Exam 70-464.

 

After completing this Training, students will be able to:

·     Introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts.

·     Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types.

·     Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered).

·     Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints.

·     Determine appropriate single column and composite indexes strategies.

·     Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure.

·     Read and interpret details of common elements from execution plans.

·     Design effective non-clustered indexes.

·     Design and implement views

·     Design and implement stored procedures.

·     Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses.

·     Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues).

·     Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency.

·     Use both traditional T-SQL error handling code and structured exception handling.

·     Design and implement DML triggers

·     Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.

·     Store XML data and schemas in SQL Server.

·     Perform basic queries on XML data in SQL Server.

·     Work with the GEOGRAPHY and GEOMETRY data types

·     Implement and query a full-text index.

 

Course 20465A:  Designing Database Solutions for Microsoft SQL Server 2012

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

 

This training covers how to design and monitor high performance, highly available data solutions with SQL Server 2012. This training focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability.

This course maps to skills and knowledge measured by Microsoft Exam 70-465, and in conjunction with on-the-job experience, will help prepare your for the exam.

 

After completing this Training, students will be able to:

·     Design an appropriate database server infrastructure for a given business application scenario

·     Design a logical schema for a database based on application requirements

·     Design the physical implementation of a database for a given set of requirements

·     Evaluate options for including binary large object data in a database design

·     Plan and manage indexes to optimize performance

·     Describe the key considerations for designing security for SQL Server instances and databases

·     Plan policy-based management to manage server instances, databases, and other SQL Server 2012 objects more efficiently

·     Plan SQL Server health monitoring

·     Implement SQL Server health monitoring by using SQL Server Utility

·     Identify and implement the appropriate backup strategy for a given scenario

·     Plan and manage multi-server maintenance and automation

·     Understand the benefits of using PowerShell to manage SQL Server 2012

·     Design an optimal replication strategy from a given set of business and technical requirements

·     Plan and implement a high availability solution

Each day of training is section wise of Lecture, Lab, and Review modules.  

 

Days 1-3: Developing Microsoft SQL Server 2012 Databases

Exam: 70-464

Days 3-6: Designing Database Solutions for Microsoft SQL Server 2012

Exam: 70-465

Note:  Daily schedule might be changes according to materials requirements to ensure that the objectives of the course are met.
Certificate Covers
  • MCSE: Data : MCSE: Data Plantform (SQL Server)

LIIT's Certification Boot Camp include the following:

  • Hands-on Instructor-Led Training
  • Our Guarantee - Pass first time or Free retake within a year of completion, just pay for accommodation, meals, and vendor exam fees.
  • Books & Study Materials
  • Test Preparation Questions and answers for practice
  • Certification exams vouchers, two retake exam vouchers (if required)
  • Breakfast & Lunch

Also we have all include in price option with AirFair and Hotel.

LOCATION START END TIME ENROLL