SQL Server 2012 Administration SSDP-002
| Course Name: | SQL Server 2012 Administration |
| Course Number: | SSDP-002 |
| Category: | Information Technology & Computers |
| Description | SQL Server 2012 Administration provids the necessary knowledge to administer a SQL Server instance.
The course uses a lecture-demo-group exercise approach to examine topics that include database maintenance, backup strategies and types of backups, security and regulatory compliance, disaster recovery, database restore strategies, design and performance improvement, cloud computing for the database administrator and more. Assignments and a final exam comprise your grade. You will find SQL Server 2012 Administration useful if you are considering a career as a database administrator or are currently an IT professional curious about what SQL Server is about and how to manage it. It will also be useful if you are a non-SQL server administrator using ORACLE, Sybase or DB2 and are interested in SQL Server. This offering will prepare for you Microsoft exams 70-462 (Administering Microsoft SQL Server 2012 Databases) and 70-465 (Designing Database Solutions for Microsoft SQL Server 2012). It will also give you the knowledge and confidence to: • Plan and install SQL; • Configure and manage SQL Server instance and other server components; • Manage access users' logins and roles; • Import and export data; • Design and implement a database security plan; • Maintain indexes; • Install and maintain databases; • Resolve concurrency problems; • Back up and restore databases. |
| Associated Programs | |
| Pre-requisities |
Requires the following prerequisite(s):
SSDP-001 - SQL Server 2012 Development Or permission of department |