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 PER MONTH - UNLIMITED ACCESS TO 7,000+ COURSES
Choose a plan. Complete the 3 step enrolment process, start training today!
GET STARTED FROM £49 PER MONTH - UNLIMITED ACCESS TO 7,000+ COURSES
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
CERTIFICATES
BUY NOWUnlimited access to 7,000+ courses£65
FULL IT SKILLS LIBRARY
ONE-ON-ONE MENTOR
PRACTICE LABS
E-BOOKS
MOBILE COMPATIBLE
CERTIFICATES
BUY NOWUnlimited access to 7,000+ courses£79
FULL IT SKILLS LIBRARY
ONE-ON-ONE MENTOR
PRACTICE LABS
E-BOOKS
MOBILE COMPATIBLE
CERTIFICATES
BUY NOWREQUEST 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!
ProfessionalUnlimited access to all courses£49
FULL IT SKILLS LIBRARY
ONE-ON-ONE MENTOR
PRACTICE LABS
E-BOOKS
MOBILE COMPATIBLE
CERTIFICATE
BUY NOWProfessionalUnlimited access to all courses£65
FULL IT SKILLS LIBRARY
ONE-ON-ONE MENTOR
PRACTICE LABS
E-BOOKS
MOBILE COMPATIBLE
CERTIFICATE
BUY NOWProfessionalUnlimited access to all courses£79
FULL IT SKILLS LIBRARY
ONE-ON-ONE MENTOR
PRACTICE LABS
E-BOOKS
MOBILE COMPATIBLE
CERTIFICATE
BUY NOWREQUEST 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
High
£32k
You can earn an average
of £32,000 a year
What’s Included

- 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?
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:















