MCSA SQL 2012 / 2014 Certification
9 days
The MCSA SQL Server 2012 /2014 certification boot camp is a 9 day comprehensive deep dive into the SQL Server covering topics such as writing queries, administration and data warehousing. This instructor led face to face training camp will teach you the skills needed to support a SQL 2012 / 2014 environment.
Schedule
TBA
Course Description
The MCSA SQL boot camp incorporates Microsoft Official Courses –
20461 Querying Microsoft SQL Server
20462 Administering Microsoft SQL Server Databases
20463 Implementing a Data Warehouse with Microsoft SQL Server
While attending this training program – you take three exams to test and certify for the Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 official certification. If your goal is to learn how to use SQL Server 2012 and pass the certification exams (70-461, 70-462 & 70-463) – you’ve found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives. Click CertificationCamps – Microsoft SQL 2012 MCSA 9 Day to download complete course outline.
Topics covered in this boot camp:
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
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
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
