SQL Server for Database Administrators

Rating:
1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
Loading...
Please Log in or register to rate

SQL Server for Database Administrators

DB-208

This course teaches the administration and maintenance aspects of Microsoft SQL Server. It covers all the roles performed by administrative DBAs, such as installation, security and availability. In each topic, the students will learn about the relevant tools and features within SQL Server as well as the best practices for using them. Throughout the course the students will practice each topic learned.

The course is based on SQL Server 2014, but it is relevant also for SQL Server 2005/2008/2012.

Audience

The course is intended for database administrators who are (already or going to be) responsible for one or more SQL Server instances. It is also suitable for IT professionals or support engineers who are required to perform database administration activities.

Students should be familiar with relational database concepts, the syntax of Transact-SQL and Windows basics.

Course Objectives
  • Be familiar with SQL Server architecture
  • Learn how to efficiently administer and maintain SQL Server instances
  • Learn how to properly install and configure a SQL Server instance
  • Be able to plan and implement a disaster recovery solution
  • Acquire the knowledge of monitoring and troubleshooting using SQL Server tools
  • Learn how to manage security with SQL Server
  • Discover high availability solutions within SQL Server
  • Acquire the knowledge of transferring data using SQL Server tools
Course Topics
  • Course Introduction
  • Introduction to Microsoft SQL Server
  • Installing a SQL Server Instance
  • Managing Databases
  • Backup and Recovery
  • SQL Server Security
  • Using Encryption
  • Monitoring and Troubleshooting
  • Automation in SQL Server
  • Using a Standby Server
  • Implementing Replication
  • Transferring Data with SQL Server
  • Summary
© Copyright - Skilit - Site by Dweb