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

MATRIC REWRITE

  Overview We offer the following subjects: MATHS ,LIFE SCIENCE ,PHYSICS,ACCOUNTS,MATHS LIT,BUSINESS STUDIES ,GEOGRAPHY,ENGLISH/ISIZULU   Admission Requirements      Course Outcomes  
0
Enquire Now

MCSA BI

  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

  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

  Overview What is involved Earning an MCSA: Windows Server 2016 certification qualifies you for a position as a network or computer systems administrator or as a computer network specialist, and it is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE). STEP 1 – SKILLS…
0
Enquire Now

COMPTIA N+

  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