TRAINING

Enroll Now

Microsoft SQL Server DBA Training

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to maintaining a database.

TARGET AUDIENCE:

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases

COURSE OBJECTIVES:

After completing this course, students will be able to:Describe core database administration tasks and tools.Install and configure SQL Server 2012/2016.Configure SQL Server databases and storage.Plan and implement a backup strategy.Restore databases from backups.Import and export data.Monitor SQL Server.Trace SQL Server activity.Manage SQL Server security.Audit data access and encrypt data.Perform ongoing database maintenance.Automate SQL Server maintenance with SQL Server Agent Jobs.Configure Database Mail, alerts and notifications

Course Contents:

Installing SQL Server 2012

• Introduction to the SQL Server Platform
• SQL Server Services and Configuration Options
• Considerations for Installing SQL Server
• Installing SQL Server 2012
• Lab : Installing SQL Server 2012

Working with Databases

• Overview of SQL Server Databases
• Creating Databases
• Using Database Files and Filegroups
• Moving Database Files
• Buffer Pool Extension
• Lab : Creating and Configuring Databases

SQL Server 2012 Recovery Models

• Backup Strategies
• Understanding SQL Server Transaction Logging
• Planning a SQL Server Backup Strategy
• Lab : Understanding SQL Server Recovery Models

Backup of SQL Server 2012 Databases

• Backing up Databases and Transaction Logs
• Managing Database Backups
• Working with Backup Options
• Lab : Backing Up SQL Server Databases

Restoring SQL Server 2012 Databases

• Understanding the Restore Process
• Restoring Databases
• Working with Point-in-Time Recovery
• Restoring System Databases and Individual Files
• Lab : Restoring SQL Server Databases

Importing and Exporting Data

• Transferring Data To/From SQL Server
• Importing and Exporting Table Data
• Inserting Data in Bulk
• Deploying and Upgrading Data-tier Applications
• Lab : Importing and Exporting Data

Authenticating and Authorizing Users

• Authenticating Connections to SQL Server
• Authorizing Logins to Access Databases
• Authorization Across Servers
• Partially Contained Databases
• Lab : Authenticating Users

Assigning Server and Database Roles

• Working with Server Roles
• Working with Fixed Database Roles
• Creating User-defined Database Roles
• Lab : Assigning Server and Database Roles

Authorizing Users to Access Resources

• Authorizing User Access to Objects
• Authorizing Users to Execute Code
• Configuring Permissions at the Schema Level
• Lab : Authorizing Users to Access Resources

Protecting Data by Using Encryption and Auditing

• Options for Auditing Data Access in SQL Server
• Implementing SQL Server Audit
• Managing SQL Server Audit
• Protecting Data by Using Encryption
• Lab : Using Auditing and Encryption

Automating SQL Server 2012 Management

• Automating SQL Server Management
• Working with SQL Server Agent
• Managing SQL Server Agent Jobs
• Multi-Server Management
• Lab : Automating SQL Server Management

Configuring Security for SQL Server Agent

• Understanding SQL Server Agent Security
• Configuring Credentials
• Configuring Proxy Server Accounts
• Lab : Configuring Security for SQL Server Agent

Monitoring SQL Server 2012 by Using Alerts and Notifications

• Configuring Database Mail
• Monitoring SQL Server Errors
• Configuring Operators, Alerts, and Notifications
• Lab : Monitoring SQL Server by Using Alerts and Notifications

Performing Ongoing Database Maintenance

• Ensuring Database Integrity
• Maintaining Indexes
• Automating Routine Database Maintenance
• Lab : Performing Ongoing Database Maintenance

Tracing Access to SQL Server 2012

• Capturing Activity by Using SQL Server Profiler
• Improving Performance by Using the Database Engine Tuning Advisor
• Working with Tracing Options
• Distributed Replay
• Monitoring Locks
• Lab : Tracing Access to SQL Server

Monitoring SQL Server 2012

• Monitoring Activity
• Capturing and Managing Performance Data
• Analyzing Collected Performance Data
• SQL Server Utility
• Lab : Monitoring SQL Server