Programm
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.
Ziele
- Installing SQL Server 2014
- Introduction to the SQL Server Platform
- SQL Server Services and Configuration Options
- Considerations for Installing SQL Server
- Installing SQL Server 2014
- Installing SQL Server 2014
- Working with Databases
- Overview of SQL Server Databases
- Creating Databases
- Using Database Files and Filegroups
- Moving Database Files
- Buffer Pool Extension
- Creating and Configuring Databases
- SQL Server 2014 Recovery Models
- Backup Strategies
- Understanding SQL Server Transaction Logging
- Planning a SQL Server Backup Strategy
- Understanding SQL Server Recovery Models
- Backup of SQL Server 2014 Databases
- Backing up Databases and Transaction Logs
- Managing Database Backups
- Working with Backup Options
- Backing Up SQL Server Databases
- Restoring SQL Server 2014 Databases
- Understanding the Restore Process
- Restoring Databases
- Working with Point-in-Time Recovery
- Restoring System Databases and Individual Files
- 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
- Importing and Exporting Data
- Authenticating and Authorizing Users
- Authenticating Connections to SQL Server
- Authorizing Logins to Access Databases
- Authorization Across Servers
- Partially Contained Databases
- Authenticating Users
- Assigning Server and Database Roles
- Working with Server Roles
- Working with Fixed Database Roles
- Creating User-defined Database Roles
- 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
- 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
- Using Auditing and Encryption
- Automating SQL Server 2014 Management
- Automating SQL Server Management
- Working with SQL Server Agent
- Managing SQL Server Agent Jobs
- Multi-Server Management
- Automating SQL Server Management
- Configuring Security for SQL Server Agent
- Understanding SQL Server Agent Security
- Configuring Credentials
- Configuring Proxy Server Accounts
- Configuring Security for SQL Server Agent
- Monitoring SQL Server 2014 by Using Alerts and Notifications
- Configuring Database Mail
- Monitoring SQL Server Errors
- Configuring Operators, Alerts, and Notifications
- Monitoring SQL Server by Using Alerts and Notifications
- Performing Ongoing Database Maintenance
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
- Performing Ongoing Database Maintenance
- Tracing Access to SQL Server 2014
- Capturing Activity by Using SQL Server Profiler
- Improving Performance by Using the Database Engine Tuning Advisor
- Working with Tracing Options
- Distributed Replay
- Monitoring Locks
- Tracing Access to SQL Server
- Monitoring SQL Server 2014
- Monitoring Activity
- Capturing and Managing Performance Data
- Analyzing Collected Performance Data
- SQL Server Utility
- Monitoring SQL Server
Voraussetzungen
This course requires that you meet the following prerequisites:
- 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.