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.
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.
Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills: 20461: Querying Microsoft SQL Server 2014 (MOC20461)
Klassikaal en Maatwerk
In deze training worden de volgende onderwerpen behandeld:
Module 1: Installing SQL Server 2014
Module 2: Working with Databases
Module 3: SQL Server 2014 Recovery Models
Module 4: Backup of SQL Server 2014 Databases
Module 5: Restoring SQL Server 2014 Databases
Module 6: Importing and Exporting Data
Module 7: Authenticating and Authorizing Users
Module 8: Assigning Server and Database Roles
Module 9: Authorizing Users to Access Resources
Module 10: Protecting Data by Using Encryption and Auditing
Module 11: Automating SQL Server 2014 Management
Module 12: Configuring Security for SQL Server Agent
Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications
Module 14: Performing Ongoing Database Maintenance
Module 15: Tracing Access to SQL Server 2014
Module 16: Monitoring SQL Server 2014