MCSA: SQL Server 2012 (Database Administration) consists of three modules- 70-461; 70-462 and 70-463. This course provides trainee with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. Module 1: 70-461 is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. Module 2: 70-462 focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Module 3: 70-463 focuses on teaching individuals how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
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; the individuals who administer and maintain SQL Server databases; the individuals who develop applications that deliver content from SQL Server databases and those who need to fulfill a Business Intelligence Developer role.
Upon completion of the course student will able to know:
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 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, 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.
Implement reporting solutions by using SQL Server Reporting Services.
Implementing multidimensional databases by using SQL Server Analysis Services.
Implement an SSIS solution that supports incremental data warehouse loads and changing data.
Describe how information workers can consume data from the data warehouse.
Course modules are:
70-461: Querying Microsoft SQL Server 2012.
70-462: Administering Microsoft SQL Server 2012 Databases.
70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.