SQL Sever DBA

About this course:

SQL Server is a Microsoft product used to manage and store information. Technically, SQL Server is a “relational database management system” (RDMS). Broken apart, this term means two things. First, that data stored inside SQL Server will be housed in a “relational database”, and second, that SQL Server is an entire “management system”, not just a database. SQL itself stands for Structured Query Language. This is the language used to manage and administer the database server.

Prerequisites:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design.

1. Introduction to DBA
2. SQL Server Installation
3. SQL Server Environment
4. Security in SQL Server
5. DBA practical Usage
6. Objects Level Maintenance
7. Disaster Recovery Planning
8. Automation
9. High Availability
10. Replication
11. Monitoring The Database System
12. Upgrading To SQL Server 2012
13. Business Intelligence Administration
14. Third Party Tools
15. Build Data Quality Solutions