Microsoft SQL Server 2012-2014 Bootcamp 15 days

Code: SQLServer Admin Bootcamp MCSA
Course duration: 15 days

Microsoft SQL Server 2012-2014 Bootcamp 15 days

This MCITP boot camp training includes 120 hours of intense training lectures, hands on labs, Microsoft Official Courseware, test prep material for the exam and lunch.
Level 300 training

20461-Querying Microsoft SQL Server (5 days) 70-461

About this Course

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Audience Profile

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

At Course Completion

After completing this course, students will be able to:

· Describe the basic architecture and concepts of Microsoft SQL Server 2014.

· Understand the similarities and differences between Transact-SQL and other computer languages.

· Write SELECT queries

· Query multiple tables

· Sort and filter data

· Describe the use of data types in SQL Server

· Modify data using Transact-SQL

· Use built-in functions

· Group and aggregate data

· Use subqueries

· Use table expressions

· Use set operators

· Use window ranking, offset and aggregate functions

· Implement pivoting and grouping sets

· Execute stored procedures

· Program with T-SQL

· Implement error handling

· Implement transactions

20462-Administering Microsoft SQL Server Databases (5 days) 70-462

About this Course

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Audience Profile

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.

At Course Completion

After completing this course, students will be able to:

· Describe core database administration tasks and tools.

· Install and configure SQL Server 2014.

· Configure SQL Server databases and storage.

· Plan and implement a backup strategy.

· Restore databases from backups.

· Import and export data.

· Monitor SQL Server.

· Trace SQL Server activity.

· Manage SQL Server security.

· Audit data access and encrypt data.

· Perform ongoing database maintenance.

· Automate SQL Server maintenance with SQL Server Agent Jobs.

· Configure Database Mail, alerts and notifications.

20463-Implementing a Data Warehouse with Microsoft SQL Server (5 days) 70-463

About this Course

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Audience Profile

This course is intended for database professionals who need to create and support a data warehousing solution. Primary responsibilities include:

· Implementing a data warehouse.

· Developing SSIS packages for data extraction, transformation, and loading.

· Enforcing data integrity by using Master Data Services.

· Cleansing data by using Data Quality Services.

At Course Completion

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 ETL solution that supports incremental data extraction.

· Implement an ETL solution that supports incremental data loading.

· 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 BI solutions can consume data from the data warehouse.

Guaranteed to Run

2018-03-20 09:00 to 2018-03-23 17:00
Palm Beach County Florida (Instructor-Led)
2018-03-19 09:00 to 2018-03-23 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2018-03-01 09:00 to 2018-03-02 17:00
Palm Beach County Florida (Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review