About This Bootcamp
Length: 9 days
The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014 certification shows that you have the primary set of SQL Server skills that are relevant across multiple solution areas in a business environment. The MCSA: SQL Server 2012/2014 certification is a prerequisite for earning the MCSE: Data Platform or Business Intelligence certification.
The primary goal of this course is to help each student pass the exams required to earn the MCSA SQL Server 2012/2014 certification. To do this, your knowledgeable instructor will blend hands-on labs with lecture and practice exams to prepare you to pass each exam. The practice exams identify knowledge gaps that the instructor will fill with customized, hands-on labs and tailored lectures.
Required Exams
To earn the certification, students must pass the following exam(s):
70-461: Querying Microsoft SQL Server 2012-2014/70-462: Administering SQL Server 2014 Databases/70-463: Implementing a Data Warehouse with SQL Server 2014
Course Objectives
After completing this course, students will have the knowledge 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
- 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.
Who should take this bootcamp.
The MCSA SQL Server 2012/2014 certification is for IT professionals either looking to get their first job in Microsoft Database technology or to document their existing skill sets. This boot camp is intended for students seeking to earn the MCSA SQL Server 2012/2014 certification and who need an expert instructor to guide them throughout the training and exam preparation process.
