Sale!

Training for Database Administrator (DBA)

$49.00

This course is designed for experienced database professionals who want to learn about the latest features in SQL Server 2014, and how to administer a SQL Server database.

Training for Database Administrator (DBA)

Course Overview:

This course is designed for experienced database professionals who want to learn about the latest features in SQL Server 2014, and how to administer a SQL Server database. The course covers topics such as installing and configuring SQL Server, managing databases and data storage, administering SQL Server security, backing up and restoring databases, and troubleshooting commonSQL Server issues.

Learning Objectives:

Upon successful completion of this course, students will be able to:

– Install and configure SQL Server 2014.

– Manage databases and data storage in SQL Server 2014.

– Administer SQL Server security.

– Backup and restore databases in SQL Server 2014.

– Troubleshoot common SQL Server issues.

Curriculum:

Module 1: SQL Server Installation and Configuration

– Installing SQL Server

– Configuring SQL Server

Module 2: Managing Databases and Data Storage

– Creating and Configuring Databases

– Managing Database Files

– Automating Database Management

Module 3: Administering SQL Server Security

– Authentication and Authorization in SQL Server

– SQL Server Security Best Practices

Module 4: Backup and Recovery in SQL Server

– Backing Up SQL Server Databases

– Restoring SQL Server Databases

Module 5: Troubleshooting SQL Server Issues

– Resolving Service-Related Issues

– Resolving Hardware and Software Issues

– Monitoring SQL Server Performance

Prerequisites:

– Experience working with relational databases

– Familiarity with the basic features of SQL Server