MCSA: SQL Server 2012/2014 Training & Certification (Boot Camp - 9 days)
  • Overview
  • Certifications
  • Curriculum
  • What’s Included
  • Schedule
  • Testimonials
  • View Comments

The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014 certification confirms that you have the essential skills required to develop and maintain mission critical Microsoft SQL Server 2012/2014 environments. MCSA: SQL Server 2012/2014 certification is the first step towards earning an MCSE: Data Platform certification or MCSE: Business Intelligence certification.

The MCSA: SQL Server 2012/2014 Bootcamp is 9 days of an intense deep dive into all aspect of SQL Server 2012/2014 including query, administration and data warehousing.

Course Covers

The Boot Camp will prepare you for the following exams:

  • Exam 70-461: Querying Microsoft SQL Server 2012
  • Exam 70-462: Administering Microsoft SQL Server 2012 Databases
  • Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

What you will learn?

Exam 70-461: Querying Microsoft SQL Server 2012/2014

After completing this course, students will be able to:

  • Write SELECT queries
  • Query multiple tables
  • Use built-in functions
  • Use subqueries
  • Execute stored procedures
  • Use set operators
  • Implement error handling
  • Implement transactions
  • Use table expressions
  • Sort and filter data
  • Use window ranking, offset and aggregate functions
  • Query SQL Server metadata
  • Program with T-SQL
  • Improve query performance

Exam 70-462: Administering Microsoft SQL Server 2012/2014 Databases

After completing this course, students will be able to:

  • Plan and install SQL Server.
  • Describes the system databases, the physical structure of databases and the most common configuration options related to them.
  • Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
  • Create SQL Server Backups.
  • Restore SQL Server databases.
  • Use the import/export wizards and explain how they relate to SSIS.
  • Work with SQL Server security models, logins and users.
  • Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
  • Work with permissions and the assignment of permissions.
  • Work with SQL Server Audit.
  • Work with SQL Server Agent, jobs and job history.
  • Implement SQL Server agent security, proxy accounts and credentials.
  • Configure database mail, alerts and notifications.
  • Create database maintenance plans.
  • Work with SQL Profiler and SQL Trace stored procedures.
  • Introduce DMVs and the configuration of data collection.
  • Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
  • Troubleshoot SQL Server databases.

Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

 After completing this course, students will be able to:

  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Design and implement a data warehouse.
  • Implement Data Flow in an SSIS Package.
  • Implement Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an SSIS solution that supports incremental data warehouse loads and changing data.
  • Integrate cloud data into a data warehouse ecosystem infrastructure.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enforce data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and Configure SSIS packages.
  • Describe how information workers can consume data from the data warehouse.

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

 

Days 1-3: Querying Microsoft SQL Server 2012/2014

Exam: 70-461

Days 3-6: Administering Microsoft SQL Server 2012/2014 Databases

Exam: 70-462

Days 7-8: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Exam:  70-463

Note:  Daily schedule might be changes according to materials requirements to ensure that the objectives of the course are met.

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, one retake exam voucher (if required)
  • Breakfast & Lunch

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

LOCATION START END TIME ENROLL