• duration
    6 days
  • Official Microsoft
    Exam Prep Boot Camp
  • Hands-On
    PRACTICE LABS
  • EXAM PASS
    GUARANTEED
  • TAKE OFFICIAL MICROSOFT
    EXAMS THROUGH US

This certification demonstrates your skills with database installation, maintenance, configuration, and provisioning tasks.

Our 6-Day MCSA SQL 2016 Database Administration Certification Boot Camp covers topics such as database installation, maintenance, configuration, and provisioning tasks with SQL Server 2016.

During this course you will take the following Official Microsoft exams onsite during the class:

70-764: Administering a SQL Database Infrastructure
70-765: Provisioning SQL Databases

As a Microsoft Gold Partner, Training Camp has successfully delivered hands-on, Microsoft training for Microsoft Certification since 1999. Training Camp pioneered the first exam-focused Microsoft Certification Boot Camps, and has since successfully certified thousands of IT & Networking Professionals.

What’s Included

Official Microsoft Courseware
Practice Labs (1 Year Access)
Exam Preparation Study Guide
Microsoft Exam Support
Microsoft Exam Vouchers
Retake Voucher (If needed)
Exam Pass Guarantee

training features

  • Award Winning Microsoft Courseware

  • SQL Server 2016 Lab/Exam Prep Review Sessions

  • Take Official Microsoft Exams Through Us

  • Exam Pass Guarantee

  • G.I. Bill Eligible For Up To 100% Of Fees

  • Practice Labs (12-Month Access)

  • Featured on CNN, FOX News, MSNBC, Reuters

  • 98% Student Satisfaction Rate

Microsoft Gold Certified Partner for Learning Solutions

Training Camp is an Microsoft Gold Certified Partner for Learning Solutions , the highest level of Microsoft partnership. This elite status gives us the advantage of direct access to the latest updates on Microsoft training, certification exams, and a stamp of approval for potential clients on the quality training we provide

  • Microsoft MCSA Exam Experts

    Our instructors are well-versed in accelerated learning concepts and exam preparation. During our MCSA SQL 2016 Database Administration boot camp, the experience of working with thousands of exam takers give our team unique insight into the learning requirements needed for success.

  • Award Winning Microsoft Exam Prep Guide

    Our exam prep guide keeps immediate pace with advancements in exam content by incorporating feedback from our thousands of Microsoft certified alumni students. They are reviewed every 30 days to ensure all information reflects the most current updates. Relying on traditional books or externally sourced materials do not offer this advantage.

  • SQL Server Lab/Exam Prep Review Sessions

    Our accelerated MCSA SQL 2016 Database Administration training includes next-gen educational content covered in value-added evening review sessions with updated practice exam review drills - representative of the actual exam and lab sim questions delivered during the official Microsoft MCSA SQL 2016 Database Administration certification exams.

  • Practice Labs (12-Month Access)

    Available 24/7 through the Internet, this dedicated access helps start the hands-on learning process without the need to spend significant amounts of money on your own equipment to prepare for MCSA SQL 2016 Database Administration certification.

  • G.I. Bill Eligible For Up To 100% Of Fees

    Training Camp has 18+ years of experience delivering our training solutions for America's veterans and our civilian workforce. Your benefits may cover up to 100% of course tuition and exam fees, and can provide a percentage stipend for your courseware, lodging, testing and other training-related costs as well.

  • Exam Pass Guarantee

    When you decide to take one of our courses, you are placing trust in us. Our Exam Pass Guarantee was designed to help you reach your goal to pass the certification exam. If you do not pass the certification exam, you may retake this program live or online and/or enroll in our mentoring program at no additional cost.

MCSA SQL 2016 Database Administration Certification Boot Camp Outline

Our courses are boosted with Training Camp’s exam prep methodology so your course content will always be up-to-date with the most current version of the exams.

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

Provision a Database Server
Upgrade SQL Server
Configure SQL Server
Manage Databases and Files (shared)

Is MCSA SQL 2016 Database Administrationcertification right for me?

This SQL Server certification demonstrates your skills with database installation, maintenance, configuration, and provisioning tasks. Earning an MCSA: SQL 2016 Database Administration certification qualifies you for a position as a database administrator or infrastructure specialist.

Prior to attending this training program, you should have some basic network knowledge, and 2 years hands-on experience with Microsoft Server.

  • View Pricing/Schedule

    Check out dates and locations for this program

    See dates
  • PRIVATE GROUP TRAINING

    More information about bringing an event to you.

    More Information
  • Register Now

    Enroll now and start your learning adventure

    Start Here

Testimonials

I would highly recommend attending a Training Camp class to increase your knowledge on a specific subject or make yourself more marketable by validating your knowledge.
Chris Pettingill MEI
I believe self-study would have been much much harder to comprehend the information and pass the test on a first try. My colleagues who self-studied flunked the first time they took it. I passed the first time after attending the boot camp.
TS Comcast
The instructor greatly exceeded my expectations. Very detailed and explained the material in a clear way for me to actually grasp and understand the course.
Tyrel T
I left the class with a new-found confidence.
Mark N Booz Allen Hamilton
I was pleasantly surprised by Training Camp. The teacher was friendly and focused. The topic was presented in an easily understandable way. They have a high success rate. What else is there to say except thank you!
Andrew Horan
The intent of the training was to help us pass the exam, and make us familiar with the material and types of questions. The instructor did a good job of getting us ready for the exam. I passed the exam!
JA Northrop Grumman
The Training Camp was EXTREMELY helpful in making sure that the exams were passed. The instructor was incredibly knowledgeable and easy to work with.
Jonathan Youngson Spalding
Dennis Lee is possibly the best training instructor I've ever had. You can see the genuine passion for teaching and passion for the materials he teaches.
JR Microsoft
01 08