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 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.
Installing SQL Server 2014
Working with Databases
SQL Server 2014 Recovery Models
Backup of SQL Server 2014 Databases
Restoring SQL Server 2014 Databases
Importing and Exporting Data
Authenticating and Authorizing Users
Assigning Server and Database Roles
Authorizing Users to Access Resources
Protecting Data by Using Encryption and Auditing
Automating SQL Server 2014 Management
Configuring Security for SQL Server Agent
Monitoring SQL Server 2014 by Using Alerts and Notifications
Performing Ongoing Database Maintenance
Tracing Access to SQL Server 2014
Monitoring SQL Server 2014