Facebook Instagram Linkedin Trustpilot

MCSA SQL ADMIN (70-764)

This course will teach you about encryption-related tools and processes used in SQL Server 2016, including cell-level, backup, and connection encryption. In addition, this course covers the Always Encrypted feature, Transparent Data Encryption, and troubleshooting. This course covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Microsoft SQL Server 2016: Encryption

Microsoft SQL Server 2016: Data Access and Permissions

Microsoft SQL Server 2016: Auditing

Microsoft SQL Server 2016: Backing Up Databases

Microsoft SQL Server 2016: Restoring Databases

Microsoft SQL Server 2016: Managing Database Integrity

Microsoft SQL Server 2016: Monitoring Database Activity and Queries

Microsoft SQL Server 2016: Monitoring SQL Server Instances

Microsoft SQL Server 2016: Managing Indexes and Statistics

Microsoft SQL Server 2016: High Availability and Disaster Recovery

Course Fee: £119 / €119 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. 

Meet your Instructor:

Aaron Sampson
Instructor: Technology and Developer

Meet your Mentor:

Carl Mullin
Mentor: Business/Technology and Developer

  • 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

Quick View Of Our Platform:

OR

GET STARTED FROM £49.00 PER MONTH - UNLIMITED ACCESS TO FULL IT LIBRARY

Choose a plan. Complete the 3 step enrolment process, start training today!

GET STARTED FROM £49.00 PER MONTH - UNLIMITED ACCESS TO FULL IT LIBRARY

Choose a plan. Complete the 3 step enrolment process, start training today!

Unlimited access to all courses£49

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

Unlimited access to all courses£65

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

Unlimited access to all courses£79

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

REQUEST A FREE 5 DAY TRIAL, NO CREDIT CARD REQUIRED!

This course will teach you about encryption-related tools and processes used in SQL Server 2016, including cell-level, backup, and connection encryption. In addition, this course covers the Always Encrypted feature, Transparent Data Encryption, and troubleshooting. This course covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Microsoft SQL Server 2016: Encryption

Microsoft SQL Server 2016: Data Access and Permissions

Microsoft SQL Server 2016: Auditing

Microsoft SQL Server 2016: Backing Up Databases

Microsoft SQL Server 2016: Restoring Databases

Microsoft SQL Server 2016: Managing Database Integrity

Microsoft SQL Server 2016: Monitoring Database Activity and Queries

Microsoft SQL Server 2016: Monitoring SQL Server Instances

Microsoft SQL Server 2016: Managing Indexes and Statistics

Microsoft SQL Server 2016: High Availability and Disaster Recovery

Course Fee: £119 / €119 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

Quick View Of Our Platform:

OR

GET STARTED FROM £49.00 PER MONTH - UNLIMITED ACCESS TO FULL IT LIBRARY

Choose a plan. Complete the 3 step enrolment process, start training today!

GET STARTED FROM £49.00 PER MONTH - UNLIMITED ACCESS TO FULL IT LIBRARY

Choose a plan. Complete the 3 step enrolment process, start training today!

Unlimited access to all courses£49

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

Unlimited access to all courses£65

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

Unlimited access to all courses£79

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

REQUEST A FREE 5 DAY TRIAL, NO CREDIT CARD REQUIRED!

Your Quick Course Guide

Certification: MCSA SQL 2016 Database Admin: Database Infrastructure

Study Time: 12 Months to complete 20 hours eg study 1 hour per day to complete your course in 1 month |study Full Time or Part Time

Vendor: Microsoft

Provider: IT Academy

Student support: One-on-One Mentoring

Pre-requisite: MTA Database Fundamentals

Assessment: 70-764

Resources: Laptop, Tablet or Smartphone & Internet Connection

Expertise Level: Intermediate

Salary Indicator

SALARY PROJECTION

Average
salary after
completing

Junior
£23k
Average Salary
You can earn
£32k
Senior
£46k

High

Source: Payscale

£32k

You can earn an average
of £32,000 a year

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

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 [email protected]

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: