MCSA SQL 2012 Certification - 9 Day Training Boot Camp Classroom Live Sarasota, FL April 21, 2018

Course Overview

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

Prerequisites

The candidate works in a development environment that uses SQL Server technologies. The candidate should have at least one year of experience developing SQL objects and understanding of normalization.