20764 Administering a SQL Database Infrastructure

Are you ready to learn how to administer a SQL Server database? This course from Network Technology Academy will equip you with the skills you need to manage databases with confidence. In this course, you’ll learn the ins and outs of database administration and gain hands-on experience automating, backing up, restoring and troubleshooting SQL Server. With expert guidance from Network Technology Academy’ certified instructors, you’ll master the modern database techniques companies are desperately seeking out.

Once you complete this course, you’ll have the skills required to manage key elements of SQL Server database administration, including user management, data backup, automation and security monitoring. This course empowers you to:

  • Authenticate and authorize users
  • Assign server and database roles
  • Backup and restore SQL Server databases
  • Protect data with encryption and auditing
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Administer SQL Server using PowerShell
  • Monitor and troubleshoot a SQL Server infrastructure
  • Import and export data
 

Course Outline
1 - SQL SERVER SECURITY
  • Authenticate Connections to SQL Server
  • Authorize Logins to Access Databases Across Servers
  • Understand Partially Contained Databases
  • Lab: Authenticating Users
2 - ASSIGNING SERVERS & DATABASE ROLES
  • Work with Server Roles and Fixed Database Roles
  • Create User-Defined Database Roles
  • Lab: Assigning Server and Database Roles
3 - AUTHORIZING USERS TO ACCESS RESOURCES
  • Provide User Access to Objects
  • Approve Users to Execute Code
  • Configure Permissions at the Schema Level
  • Lab: Authorizing Users to Access Resources
4 - PROTECTING DATA WITH ENCRYPTION AND AUDITING
  • Learn the Options for Auditing Data Access in SQL Server
  • Implement and Manage SQL Server Audits
  • Protect Data with Encryption
  • Lab: Using Auditing and Encryption
5 - RECOVERY MODELS AND BACKUP STRATEGIES
  • Deploy Secure Backup Strategies
  • Understand SQL Server Transaction Login
  • Plan a SQL Server Backup Strategy
  • Lab: Understanding SQL Server Recovery Models
6 - BACKING UP SQL SERVER DATABASES
  • Back up Databases and Transaction Logs
  • Manage Database Backups
  • Deploy Different Backup Options
  • Lab: Backing up SQL Server Databases
7 - RESTORING SQL SERVER 2016 DATABASES
  • Learn About the Restore Process
  • Work with Point-in-Time Recovery
  • Restore System Databases and Individual Files
  • Lab: Restoring SQL Server User Databases
8 - AUTOMATING SQL SERVER MANAGEMENT
  • Automate SQL Server Management
  • Explore the SQL Server Agent
  • Manage SQL Server Agent Jobs
  • Understand Multi-Server Management
  • Lab: Automating SQL Server Management
9 - CONFIGURING SECURITY FOR SQL SERVER AGENT
  • Maintain SQL Server Agent Security
  • Configure Credentials and Proxy Accounts
  • Lab: Configuring Security for SQL Server Agent
10 - MONITORING SQL SERVER WITH ALERTS & NOTIFICATIONS
  • Create Settings for Database Mail
  • Monitor SQL Server Errors
  • Work with Operators, Alerts and Notifications
  • Learn How Alerts Work in Azure SQL Database
  • Lab: Monitoring SQL Server with Alerts and Notifications
11 - INTRODUCTION TO MANAGING SQL SERVER BY USING POWERSHELL
  • Configure and Administer SQL Server Using PowerShell
  • Maintain the SQL Server Environment Using PowerShell
  • Manage Azure SQL Server Databases Using PowerShell
  • Lab: Administering SQL Server Using PowerShell
12 - TRACING ACCESS TO SQL SERVER WITH EXTENDED EVENTS
  • Capture Activity Using SQL Server Profiler
  • Improve Performance with the Database Engine Tuning Advisor
  • Work with Tracing Options
  • Perform Distributed Replays
  • Monitor Locks
  • Lab: Tracing Access to SQL Server
13 - MONITORING SQL SERVER
  • Oversee SQL Server Activity
  • Capture and Manage Performance Data
  • Analyze Collected Performance Data
  • Assess SQL Server Utility
  • Lab: Monitoring SQL Server
14 - TROUBLESHOOTING SQL SERVER
  • Learn the SQL Server Troubleshooting Methodology
  • Fix Service Related Issues
  • Resolve Login and Connectivity Issues
  • Troubleshoot Other Common Issues
  • Lab: Troubleshooting Common Issues
15 - IMPORTING AND EXPORTING DATA
  • Transfer Data to and from SQL Server
  • Import and Export Table Data
  • Apply BCP and BULK INSERT to Import Data
  • Deploy and Upgrade Data-Tier Applications
  • Lab: Importing and Exporting Data

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

This course is SATV-Eligible
All class times shown are in Pacific Standard Time (PST)

Contact Us For Price

Course Length: 5 Days

1. Choose a Date | 2. Click Enroll Now
Need Help Picking the Right Course? Give us a call! 781-388-0026
Awaiting product image

Description

Once you complete this course, you’ll have the skills required to manage key elements of SQL Server database administration, including user management, data backup, automation and security monitoring.

This course empowers you to:

  • Authenticate and authorize users
  • Assign server and database roles
  • Backup and restore SQL Server databases
  • Protect data with encryption and auditing
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Administer SQL Server using PowerShell
  • Monitor and troubleshoot a SQL Server infrastructure
  • Import and export data

 

Reviews

There are no reviews yet.

Be the first to review “20764 Administering a SQL Database Infrastructure”

Your email address will not be published. Required fields are marked *

Related products

© Copyright - Network Technology Academy
20762 Developing SQL Databases 20765 Provisioning SQL Databases