Overview
5 Days $4,050 or FREE WITH SATVs (?)
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. This is a Microsoft Official Course (MOC).
- Database Administration Overview
- Introduction to the SQL Server Platform
- Database Management Tools and Techniques
- Using SQL Server Management Studio
- Using the sqlcmd Utility
- Using Windows PowerShell with SQL Server
After completing this module, students will be able to:
- Describe the SQL Server Platform.
- Describe common database administration tasks.
- Use SQL Server administration tools.
- Planning SQL Server Installation
- Installing SQL Server 2014
- Post-Installation Configuration
- Preparing to Install SQL Server
- Installing SQL Server
- Performing Post-Installation Configuration
After completing this module, students will be able to:
- Plan a SQL Server 2014 installation.
- Install SQL Server 2014.
- Perform post-installation configuration tasks.
- Introduction to Data Storage with SQL Server
- Managing Storage for System Databases
- Managing Storage for User Databases
- Moving Database Files
- Configuring the Buffer Pool Extension
- Configuring tempdb Storage
- Creating Databases
- Attaching a Database
After completing this module, students will be able to:
- Describe how SQL Server stores data.
- Manage storage for system databases.
- Manage storage for user databases.
- Move database files.
- Configure the buffer pool extension.
- Understanding SQL Server Recovery Models
- Planning a Backup Strategy
- Backing up Databases and Transaction Logs
- Using Backup Options
- Ensuring Backup Reliability
- Backing Up Database
- Performing Database, Differential, and Transaction Log Backups
- Performing a Partial Backup
After completing this module, students will be able to:
- Describe how database transaction logs function, and how they affect database recovery.
- Plan a backup strategy for a SQL Server database.
- Back up databases and transactions logs.
- Perform copy-only, compressed, and encrypted backups.
- Maximize backup reliability.
- Understanding the Restore Process
- Restoring Databases
- Advanced Restore Scenarios
- Working with Point-in-Time Recovery
- Restoring a Database Backup
- Restoring Database, Differential, and Transaction Log Backups
- Performing a Piecemeal Restore
After completing this module, students will be able to:
- Explain the restore process.
- Restore databases.
- Perform advanced restore operations.
- Perform a point-in-time recovery.
- Introduction to Transferring Data
- Importing and Exporting Table Data
- Copying or Moving a Database
- Using the SQL Server Import and Export Wizard
- Using the bcp Utility
- Using the BULK INSERT Statement
- Using the OPENROWSET Function
After completing this module, students will be able to:
- Describe tools and techniques for transferring data.
- Import and export data.
- Copy or move a database.
- Introduction to Monitoring SQL Server
- Dynamic Management Views and Functions
- Performance Monitor
- Collecting Baseline Metrics
- Monitoring a Workload
After completing this module, students will be able to:
- Describe considerations for monitoring SQL Server and use Activity Monitor.
- Use dynamic management views and functions to monitor SQL Server.
- Use Performance Monitor to monitor SQL Server.
- Tracing SQL Server Workload Activity
- Using Traces
- Capturing a Trace in SQL Server Profiler
- Generating Database Tuning Recommendations
- Using SQL Trace
After completing this module, students will be able to:
- Trace activity in SQL Server.
- Use captured traces to test, troubleshoot, and optimize database performance.
- Introduction to SQL Server Security
- Managing Server-Level Security
- Managing Database-Level Principals
- Managing Database Permissions
- Managing Server-Level Security
- Managing Database-Level Security
- Testing Database Access
After completing this module, students will be able to:
- Describe core security concepts in the SQL Server security architecture.
- Manage server-level security.
- Manage database-level security principals.
- Manage database permissions.
- Auditing Data Access in SQL Server
- Implementing SQL Server Audit
- Encrypting Databases
- Implementing Auditing
- Implementing Transparent Database Encryption
After completing this module, students will be able to:
- Describe options for auditing data access.
- Implement SQL Server audit.
- Manage SQL Server audit.
- Implement Transparent Data Encryption.
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
- Managing Database Integrity
- Managing Index Fragmentation
- Implementing a Maintenance Plan
After completing this module, students will be able to:
- Ensure database integrity by using DBCC CHECKDB.
- Maintain indexes.
- Configure Database Maintenance Plans.
- Automating SQL Server Management
- Implementing SQL Server Agent Jobs
- Managing SQL Server Agent Jobs
- Managing Job Step Security Contexts
- Managing Jobs on Multiple Servers
- Creating a Job
- Scheduling a Job
- Configuring Job Step Security Contexts
After completing this module, students will be able to:
- Describe methods for automating SQL Server management.
- Create jobs, job step types, and schedules.
- Manage SQL Server Agent jobs.
- Configure job security contexts.
- Configure master and target servers.
- Monitoring SQL Server Errors
- Configuring Database Mail
- Configuring Operators, Alerts, and Notifications
- Configuring Database Mail
- Implementing Operators and Notifications
- Implementing Alerts
After completing this module, students will be able to:
- Configure Database Mail.
- Monitor SQL Server errors.
- Configure operators, alerts, and notifications.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.
Students who attend this training can meet the prerequisites by attending the following courses, 20461: Querying Microsoft SQL Server 2014, or obtaining equivalent knowledge and skills.
Instructors
Adam Keats
With over 24 years of real-world and training experience, Adam is ...
Newton Godoy
With over 17 years of in-class training experience and over 16 ...