Administering a SQL Database Infrastructure

****실습자료가 필요하신 분은 본 과정에 댓글 달아주시거나 아카데미 파트로 메일 주시면, 메일로 전달해 드립니다.

Audience
Candidates who attend this course typically are IT professionals 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.
• Individuals who develop applications that deliver content from SQL Server databases.

Prerequisites
Before attending this course, students must have:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of relational databases.
• Working knowledge of Transact-SQL.
• Some experience with database design.

Objectives
After completing this course, students will be able to:

• Authenticate and authorize users
• Assign server and database roles
• Authorize users to access resources
• Protect data with encryption and auditing
• Describe recovery models and backup strategies
• Backup SQL Server databases
• Restore SQL Server databases