SQL Sever DBA

   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.
• Any Programming Language is an advantage.
• No prior SQL Server experience is presumed.

OBJECTIVE:

 AT THE END OF COURSE PARTICIPANTS WILL BE

• 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 SQL Server 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.
• 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.
• Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.

DELIVERY APPROACH:

• Instructor led online training
• Knowledge Transfer will happen with respect to proposed content with suitable demos.
• Blend of theory and hands on with assignment based approach is adopted
• This course aims to provide participants with the solid experience and know-how to do SQL Server 2005 & 2008,R2,and 2012 Administration.
• This course has been developed for real-world scenarios,   for Production Server and Development environments with explaining real time issues. See below for detailed syllabus.