About This Course

<p><strong><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="color:#333333">Course Overview</span></span></span></span></strong></p> <p style="text-align:justify"><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-family:"Cambria",serif"><span style="color:#333333">This is a detailed Training Course that will help you understand all about database administration and become a Database Administrator. You will get a clear understanding about installation, functioning and authentication types in MS SQL servers. This Course also covers managing, maintaining and securing of databases, and automation of MS SQL Server.</span></span></span></span></span></p> <p style="text-align:justify"><strong><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-family:"Cambria",serif"><span style="color:#333333">Who Should Attend</span></span></span></span></span></strong></p> <p style="text-align:justify"><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-family:"Cambria",serif"><span style="color:#333333">Software and IT professionals, SQL Developers and Administrators, Database server professionals, those aspiring for a career in SQL Server DBA.</span></span></span></span></span></p> <p style="text-align:justify"><strong><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="color:#333333">Course Objectives</span></span></span></span></strong></p> <p style="text-align:justify"><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-family:"Cambria",serif"><span style="color:#333333">At the end of the course, participants will be able to: Learn the roles and responsibilities of SQL Server DBA, Understand the various SQL server tools available, Learning Query Design and Query Performance Tuning, Disaster Recovery and High Availability solutions, DBA creation, modification and file addition, Learn SQL Server security authentication measures, The importance of Backups and restorations, Job monitoring and SQL Server Agent Clustering, Creation of users and logins.</span></span></span></span></span></p> <p style="text-align:justify"><strong><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="color:#333333">Prerequisites</span></span></span></span></strong></p> <p style="text-align:justify"><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-family:"Cambria",serif"><span style="color:#333333">You don’t need any specific skills to take this Training Course. Having a basic knowledge of SQL and database can help.</span></span></span></span></span></p>

• Learning Objectives

• Find a new position involving
  Data modeling.
• Expanded responsibilities as part of
  an existing role.
• Ready to begin working on real-world
  data modeling projects.

• Other Instructors

• Eleanor Fant Instructor
• Lauren Stamps Teacher
• Jonquil Von Associate