mS SQL server - administration

In MS SQL Server - Administration training course, Delegates will learn the skills required to maintain a Microsoft SQL Server database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent.

  • Basic knowledge of Microsoft Windows operations systems and its core functionality
  • Working knowledge of Transact-SQL and relational databases
  • Experience with database design

  • Database professionals who administer and maintain SQL Server databases including database maintenance
  • Database professionals who work in environments where databases play a key role in their primary job responsibilities or develop applications that deliver content from SQL Server databases

By attending MS SQL Server - Administration workshop, Delegates will learn:

  • Core database administration tasks and tools
  • Install and configure SQL Server
  • 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 AGENDA

  • Implement and Manage SQL Server Agent Jobs
  • Manage Job Step Security Contexts
  • Manage Job on Multiple Servers
  • Monitor SQL Server Errors
  • Configure Database Mail
  • Configure Operators, Alerts, and Notifications
  • Ensure Database Integrity
  • Maintain Indexes
  • Automate Routine Database Maintenance
  • Trace SQL Server Workload Activity and Use Traces
  • Introduction to SQL Server Security
  • Manage Server-Level Security and Database-Level Principals
  • Manage Database Permissions
  • Audit Data Access in SQL Server
  • Implement SQL Server Audit
  • Encrypt Databases
  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor
  • Transferring Data
  • Import and Export Table Data
  • Copy or Move a Database
  • Restore Process and Databases Restoration
  • Advanced Restore Scenarios
  • Point-in-Tim Recovery
  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques
  • Plan SQL Server Installation
  • Install SQL Server and Post-Installation Configuration
  • Introduction to Data Storage with SQL Server
  • Manage Storage for System Databases and User Databases
  • Move Database Files
  • Configure the Buffer Pool Extension
  • SQL Server Recovery Models
  • Plan a Backup Strategy
  • Backup Databases and Transaction Logs
  • Backup Options and Backup Reliability