- Exam 70-458 – Objective 1 – Manage Data
- Exam 70-458 – Objective 2 – Implement Security
- Exam 70-458 – Objective 3 – Implement high availability
- Exam 70-458 – Objective 4 – Design and implement a data warehouse
- Exam 70-458 – Objective 5 – Extract and transform data
- Exam 70-458 – Objective 6 – Load data
- Exam 70-458 – Objective 7 – Configure and deploy SSIS solutions
- Exam 70-458 – Objective 8 – Build Data Quality solutions
Manage logins and server roles
- Configure server security (http://msdn.microsoft.com/en-us/library/bb283235.aspx)
- Secure the SQL Server using Windows Account/SQL Server accounts, server roles
- Server-Level Roles (http://msdn.microsoft.com/en-us/library/ms188659.aspx)
- Create log in accounts (http://msdn.microsoft.com/en-us/library/aa337562.aspx)
- Manage access to the server, SQL Server instance, and databases
- Database Roles (http://msdn.microsoft.com/en-us/library/ms189121.aspx)
- Create and maintain user-defined server roles (http://msdn.microsoft.com/en-us/library/ee677627.aspx)
- Manage certificate logins
- CREATE LOGIN Example D (http://msdn.microsoft.com/en-us/library/ms189751(v=sql.120).aspx)
Manage database permissions
- Configure database security
- Database level permissions
- Database Roles (http://msdn.microsoft.com/en-us/library/ms189121.aspx)
- Protect objects from being modified
Manage users and database roles
- Create access to server/database with least privilege
- Manage security roles for users and administrators
- Create database user accounts
- Contained logins
Troubleshoot security
- Manage certificates and keys (http://msdn.microsoft.com/en-us/library/bb895327.aspx)
- Endpoints (http://msdn.microsoft.com/en-us/library/ms181591(v=sql.120).aspx)