MCSA SQL

Africa College of Technology > Courses > Technical Support > MCSA SQL
Categories:

  Overview

This 5 day course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

  Admission Requirements

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

 

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.

Available Exams and Certifications

This course will help you you prepare for the Exam 70-764. CLICK HERE to learn more about this exam.

This course contributes towards earning your MCSA: SQL 2016 Database Administration. CLICK HERE to learn more.

 Course Outcomes

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
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructurE
  • Troubleshoot a SQL Server infrastructure
  • Import and export data

Related Courses

Enquire Now

MCSA BI

Africact
  Overview This 5 day course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.   Admission Requirements In addition to their…
0
Enquire Now

MCSA CLOUD

Africact
  Overview This course is intended for students who have experience building ASP.NET and C# applications.  Students will also have experience with the Microsoft Azure platform and a basic understanding of the services offered. This course offers students the opportunity to take an existing ASP.NET MVC application and expand its functionality…
0
Enquire Now

MCSA SERVER

Africact
  Overview Get hands-on instruction and practice installing and configuring Windows Server 2012, including Windows Server 2012 R2, in this five-day Microsoft Official Course. This course is part one in a series of three courses that provides the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in…
0
Enquire Now

COMPTIA N+

Africact
  Target Audience CompTIA Network+ This course is intended for IT professionals with a basic knowledge of computer hardware, software, and operating systems who wish to increase their knowledge and understanding of networking concepts and acquire the required skills to prepare for a career in network support or administration, or…
0
Enquire Now

COMPTIA A+

Africact
  Introduction The accelerated CompTIA A+ Bootcamp course is an industry standard IT certification course for delegates who wish to establish a career in Information technology. The course takes delegates through computer hardware components, the fundamentals of networking, operating systems, network security, as well as troubleshooting software, hardware and networks.…
0

Leave a Reply

Your email address will not be published. Required fields are marked *