Goals
- Describe the main administration tasks and database tools
- Install and configure SQL Server 2014
- Configure SQL Server databases and storage
- Monitor SQL Server
- Audit data access and encrypt data
Program
Overview of Database Administration
Introduction to the SQL Server Platform
Database Management Tools and Techniques
Practical Workshops:
- Using SQL Server Administrative Tools
- Describe the SQL Server Platform
- Describe Common Database Administration Tasks
- Use SQL Server Administration Tools
Plan the installation of SQL server
Install SQL Server 2014
Configure the post-installation
Practical Workshops:
- Installing SQL Server 2014
- Planning a SQL Server 2014 installation
- Install SQL Server 2014
- Perform post-installation configuration tasks
Introduction to Data Storage with SQL Server
Manage Storage for User Databases
Manage Storage for Database Users
Move Database Files
Configure Buffer Pool Extension
Practical workshops:
- Storage database management
- Describe how SQL server data stores
- Manage system database storage
- Manage user database storage
- Move database files
- Configure the expanding the buffer pool
Understand SQL Server recovery models
Plan a backup strategy
Back up databases and transaction logs
Use backup options
Ensure backup reliability
Practical Workshops:
- Backing up SQL Server databases
- Describe how the database transaction logs function, and how they affect database recovery
- Plan a backup strategy for a SQL Server database
- Back up the databases data and transaction logs
- Make one copy only, compressed, and encrypted backups
- Maximize backup reliability
Understanding the
Restore Process Restoring Databases
Advanced Restore Scenarios
Working with Point-in-Time Restore
Practical Workshops:
- Explain the restore process
- Restore databases
- Perform advanced restore operations
- Perform on-time recovery
Introduction to Data Transfer
Importing and Exporting Data from Tables
Copying and Moving a Database
Practical workshops:
- Describe the tools and techniques of data transfer
- Copy or move a database
Duration
5 days
Price
£ 2135
Audience
Database administrators
Prerequisites
Have taken course 20461
Basic knowledge of Windows operating system
Basic knowledge of TSQL language
Knowledge of relational databases
Reference
BAS1117-F
Introduction to Monitoring SQL Server
Dynamic Management Views and Functions
Performance Monitor
Practical Workshops:
- Describe considerations for SQL Server monitoring and use Activity Monitor
- Use dynamic management views and functions to monitor SQL Server
- Use Performance Monitor to monitor SQL Server
Trace SQL Server Workload Activity
Use Traces
Practical Workshops:
- Tracing SQL Server Workload Activity
- Using Traces
Introduction to SQL Server Security
Managing Server Security
Managing Users at the Database Level
Managing Permissions
Practical Workshops:
- Describe fundamental security concepts in SQL Server security architecture
- Manage server level security
- Manage database level security directors
- Manage database permissions
Audit data access in SQL Server Implement SQL Server Audit
Database encryption
Practical Workshops:
- Describe audit data access options
- Implement SQL Server auditing
- Manage SQL Server data verification
- Implement Transparent Data Encryption
Ensure database integrity
Maintain index
Automate database maintenance
Practical Workshops:
- Ensure database integrity using DBCC CHECKDB
- Maintain indexes
- Configure database maintenance plans
Automate SQL Server Management
Implement SQL Server Agent Jobs
Manage SQL Server Agent Jobs
Manage Job Context Step Security Contexts
Manage Jobs on Multiple Servers
Practical workshops:
- Describe the methods to automate the management of SQL Server
- Create jobs, types of work stages and schedules
- Manage SQL Server Agent tasks
- Configure job security contexts
- Configure master and target servers
Monitor SQL Server errors
Configure database messaging
Configure operators, alerts and notifications
Practical workshops:
- Configure the Mail database
- Monitor SQL Server errors
- Configure operators, alerts and notifications
Sessions
Contact us for more informations about session date