Administering a SQL Database Infrastructure

Teacher

Yoda

Categories

Database

Review

(0 review)

Free

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

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

Course Features

Lectures 15
Quizzes 16
Duration 15 hours
Skill level 200 Level
Language English
Students 6
Certificate No
Assessments Self

Module 30
- Lecture1.1
  
  SQL Server Security 01 hour
- Quiz1.1
  
  Knowledge Check 5 questions
- Lecture1.2
  
  Assigning Server and Database Roles 01 hour
- Quiz1.2
  
  Knowledge Check 5 questions
- Lecture1.3
  
  Authorizing Users to Access Resources 01 hour
- Quiz1.3
  
  Knowledge Check 5 questions
- Lecture1.4
  
  Protecting Data with Encryption and Auditing 01 hour
- Quiz1.4
  
  Knowledge Check 5 questions
- Lecture1.5
  
  Recovery Models and Backup Strategies 01 hour
- Quiz1.5
  
  Knowledge Check 5 questions
- Lecture1.6
  
  Backup of SQL Server Databases 01 hour
- Quiz1.6
  
  Knowledge Check 5 questions
- Lecture1.7
  
  Restoring SQL Server Databases 01 hour
- Quiz1.7
  
  Knowledge Check 5 questions
- Lecture1.8
  
  Automating SQL Server Management 01 hour
- Quiz1.8
  
  Knowledge Check 5 questions
- Lecture1.9
  
  Configuring Security for SQL Server Agent 01 hour
- Quiz1.9
  
  Knowledge Check 5 questions
- Lecture1.10
  
  Monitoring SQL Server with Alerts and Notifications 01 hour
- Quiz1.10
  
  Knowledge Check 5 questions
- Lecture1.11
  
  Introduction to Managing SQL Server by using PowerShell 01 hour
- Quiz1.11
  
  Knowledge Check 5 questions
- Lecture1.12
  
  Tracing Access to SQL Server with Extended Events 01 hour
- Quiz1.12
  
  Knowledge Check 5 questions
- Lecture1.13
  
  Monitoring SQL Server 01 hour
- Quiz1.13
  
  Knowledge Check 5 questions
- Lecture1.14
  
  Troubleshooting SQL Server 01 hour
- Quiz1.14
  
  Knowledge Check 5 questions
- Lecture1.15
  
  Importing and Exporting Data 01 hour
- Quiz1.15
  
  Knowledge Check 5 questions
Final Test 1
- Quiz2.1
  
  Administering a SQL Database Infrastructure 25 questions

Yoda

Yoda was a legendary Jedi Master and stronger than most in his connection with the Force. Small in size but wise and powerful, he trained Jedi for over 800 years, playing integral roles in the Clone Wars, the instruction of Luke Skywalker, and unlocking the path to immortality.