Institute of
Business and Technology

iBtech Logo | Institute of Business & Technology

Business & Technology

Institute of Business & Technology

Course Status
Availability
Course Duration
Timing
Course ID
Exam Number
Registration Open
Weekdays – Weekends
3 Days, 21 Hours
9:00 AM – 04:00 PM
20764
70-764

Administering a SQL Database Infrastructure

After completing this course, students will be able to:

  • Authenticate and authorize users
  • Assign server and database roles
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup and Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data
  • Must have knowledge of the Microsoft Windows operating system.
  • Must have knowledge of relational databases.
  • Some experience with database design

You have made the
best choice!

Students | IT Health, and Business Courses | iBtech Toronto & Mississauga

Book Your Seat Today

Request Information

Request Information