Administering a SQL Database Infrastructure

BITTS International Career College > Certificate > Administering a SQL Database Infrastructure
BITTS logo
Department
Information Technology
Semester
Continuous
Method
Online
Duration
39 Hours

Gain hands-on experience to pass the Microsoft MCSA SQL Server 70-764 certification exam with the Administering a SQL Database Infrastructure course and lab. The lab is cloud-based, device-enabled, and can be easily integrated with an LMS. Interactive chapters comprehensively cover Microsoft MCSA 70-764 certification exam objectives and provide knowledge and skills required to configure data access and auditing; manage backup and restore of the database; manage and monitor SQL Server instance; and manage high availability and disaster recovery.

students at BITTS

The Microsoft MCSA Administering a SQL Database Infrastructure certification is globally recognized credential for validating Querying Microsoft SQL Server knowledge.

Quick Application Form

Entry requirements

  • High School Diploma or Equivalent
  • Age must be 18 years or above
  • English Proficiency

Course structure and modules

  • Introduction
  • Configure Encryption
  • Configure Data Access and Permission
  • Configure Auditing
  • Develop a Backup Strategy
  • Manage Database
  • Alert Data for Failed Backups
  • Restore Data
  • Manage Database Integrity
  • Database Activity
  • Query Store
  • Manage Indexes
  • SQL Server Instances
  • Implement Log Shipping and Configure Cluster
  • Availability Group

Career opportunities

  • SQL Analyst
  • SQL Developer
  • SQL Server Database Administrator