270 Hours/Mentor SupportedThe MCSA: #SQL Server 2012 course aims to prepare students to sit for certain certification exams. These certification exams include Microsoft 70-461 Querying Microsoft SQL Server, Microsoft 70-462 Administering Microsoft SQL Server 2012 Databases, and Microsoft 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012. Students should be aware that the cost of this course does not also cover the cost of the certification exam. Students will learn about database integrity, how to create and modify constraints, SQL 2012 strategies, how to use SQL Server Reporting Services B, and user-defined functions (UDFs).
This course is comprised of ten modules. The modules include subjects such as Designing Database Solutions, SQL Server Security, Implementing Business Intelligence and Reporting, and Policy-Based Management & Backup and Restoration. Within each main subject module are sub-modules, which will focus on different areas. Students should strive to understand these areas in order to fully comprehend the material involved in each subject.
By enrolling in this course, participants are expressing their interest in advancing their knowledge in certain technological environments. Students will need to have Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463) in order to fully participate in this course.
By the end of this course, you will be able to:
- Identify and maintain database integrity
- Create and modify constraints
- Identify and alter user-defined functions (UDFs)
- Identify and understand indexing strategies for SQL 2012
- Understand reporting solutions by using SQL Server Reporting Services B