Facebook Instagram Linkedin Trustpilot
Online IT Training Courses through IT Academy UK CompTIA | Microsoft | Cisco | AWS | PMI | ITIL | ISTQB | Google | EC-Council | Linux | Prince2 | Oracle | ISACA | HRCI Free Course Demo
Online IT Training Courses through IT Academy UK CompTIA | Microsoft | Cisco | AWS | PMI | ITIL | ISTQB | Google | EC-Council | Linux | Prince2 | Oracle | ISACA | HRCI Free Course Demo

Meet your Instructor:

Aaron Sampson
Instructor: Technology and Developer

Meet your Mentor:

Carl Mullin
Mentor: Business/Technology and Developer

MCSA SQL Database Admin

Pass the 70-761 and 70-762 exams to earn your MCSA SQL 2016 Database Development Certification. Pass the 70-764 and 70-765 exams to earn your MCSA SQL 2016 Database Administrator Certification.

Encryption

Data Access and Permissions

Auditing

Backing Up Databases

Restoring Databases

Managing Database Integrity

Monitoring Database Activity and Queries

Monitoring SQL Server Instances

Managing Indexes and Statistics

High Availability and Disaster Recovery

Components of a SQL Server 2016 Installation

Installing and Upgrading SQL Server 2016

SQL Server Virtual Machines on Azure

SQL Server Instances and Storage Considerations

Azure SQL Database Encryption

SQL Server Performance Settings

Deploying Applications to Microsoft Azure SQL Databases

Azure Virtual Machines

Migrating Client Applications

Course Fee: £219 / €219 Incl. VAT

You will receive immediate access to your courses upon registration and course purchase. Our on-demand cloud based training courses are accessible on a computer, laptop, tablet/smartphone for a period of 12 months. You will need to obtain 70% and above to receive your Certificate. Assessments may be retaken at no additional cost. 

  • 24/7 Access, 365 Days
  • Mobile Compatible
  • 1:1 Mentor Certification exams
  • Labs - CompTIA, Cisco, CEH, CodeX
  • 3-6 Months Payment Plan
  • Excellent Student Support
  • Award Winning Training
  • 100% Pass/Course Mastery Certificate
  • Discounted CompTIA Exam Vouchers
  • 12 Months Subscription
  • Free Official Exam Preps

3-6 Month Payment Plan available.

Career Ready Education. Register Now for our award winning Cloud based training courses led by Industry Experts. 24/7 Access, Mobile Compatible, Student Support - 99% success rate!

MCSA SQL Database Admin

Pass the 70-761 and 70-762 exams to earn your MCSA SQL 2016 Database Development Certification. Pass the 70-764 and 70-765 exams to earn your MCSA SQL 2016 Database Administrator Certification.

Encryption

Data Access and Permissions

Auditing

Backing Up Databases

Restoring Databases

Managing Database Integrity

Monitoring Database Activity and Queries

Monitoring SQL Server Instances

Managing Indexes and Statistics

High Availability and Disaster Recovery

Components of a SQL Server 2016 Installation

Installing and Upgrading SQL Server 2016

SQL Server Virtual Machines on Azure

SQL Server Instances and Storage Considerations

Azure SQL Database Encryption

SQL Server Performance Settings

Deploying Applications to Microsoft Azure SQL Databases

Azure Virtual Machines

Migrating Client Applications

You will receive immediate access to your courses upon registration and course purchase. Our on-demand cloud based training courses are accessible on a computer, laptop, tablet/smartphone for a period of 12 months. You will need to obtain 70% and above to receive your Certificate. Assessments may be retaken at no additional cost. 

  • 24/7 Access, 365 Days
  • Mobile Compatible
  • 1:1 Mentor Certification exams
  • Labs - CompTIA, Cisco, CEH, CodeX
  • 3-6 Months Payment Plan
  • Excellent Student Support
  • Award Winning Training
  • 100% Pass/Course Mastery Certificate
  • Discounted CompTIA Exam Vouchers
  • 12 Months Subscription
  • Free Official Exam Preps

Course Fee: £219 / €219 Incl. VAT

3-6 Month Payment Plan available.

Career Ready Education. Register Now for our award winning Cloud based training courses led by Industry Experts. 24/7 Access, Mobile Compatible, Student Support - 99% success rate!

Your Quick Course Guide

Certification: Microsoft

Study Time: 12 Months to complete 40 hours eg Study 1 hour per day and complete your courses in 1.5 months | Full Time or Part Time

Vendor: Microsoft

Provider: IT Academy

Student support: One-on-One Mentoring

Pre-requisite: MTA Database Fundamentals is included or Database experience

Assessment: 70-764 & 70-765

Resources: Laptop, Tablet or Smartphone & Internet Connection

Expertise Level: Beginners

What’s Included

Replace-trainer-img
  • 24/7 Access, 365 Days
  • Mobile Compatible
  • 1:1 Mentor Certification exams
  • Labs - CompTIA, Cisco, CEH, CodeX
  • 3-6 Months Payment Plan
  • Excellent Student Support
  • Award Winning Training
  • 100% Pass/Course Mastery Certificate
  • Discounted CompTIA Exam Vouchers
  • 12 Months Subscription
  • Free Official Exam Preps

Testimonials

Reviews:

STARTING AN IT CAREER OR UPSKILLING?

Click here to view All Courses or call a Career Consultant on 020 7770 6431 or e-mail info@it-academy.uk

Click here to request a free 5 day Trial Course or proceed to STEP 3

Select your course here and click BUY NOW to proceed to checkout 

Register your details and arrange payment via EFT/Credit Card or PayPal

Receive your login details and start immediately

WHAT SETS US APART:

  • Official Partnerships

Partners with IT certification vendors CompTIA, Microsoft & Skillsoft who are the global leaders in online learning

  • We are IT Experts

With over 13 years experience, we have 13 000+ students graduate through IT Academy

  • Award Winning

Latest-in-Market Online Cloud Based Courses delivered via Video, Quizzes, Virtual labs & Mentoring

  • Virtual Practice Labs

Learn, Practice writing Code with instant feedback in a Live Environment

  • Live Mentoring

Free One-on-One Live Mentoring with Certified Industry Experts

  • Practice Tests

Take Practice Tests designed to mimic the actual exam

Accredited by and Partnered with: