Shopping Cart  [0]

Call 800.698.5501

MCSA SQL 2016 Database Administration Boot Camp - Training Camp

MCSA Certification Training
TrainingCamp Twitter Feed

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. This program will teach you the skills needed to support an SQL 2016 environment, and pass the required Microsoft exams.

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

This comprehensive training focuses on learning beyond the core content of standard Microsoft courses. Our program incorporates interactive demonstrations with exam foucused explanations using Training Camp's award-winning comprehensive exam preparation best practices.

In addition to our public course schedule , we can also offer Private Group Training with Microsoft exams hosted at any location in the world, with no student minimum number.

Enrollment Information

Training Pricing View Pricing
Training Pricing Course Schedule

SQL16-MCSADA

Duration: 6 days
Exam Voucher: Included
Testing: Delivered On-Site
GI Bill Eligible: ≤ 100% of Fees
GSA Catalog: GS-02F-0044T

Other Delivery Formats

Hosted  Boot Camp Private Group Training
Microsof Certification Training

Official Microsoft Training Includes:
  • Official Microsoft Courseware
  • Hands-On Labs
  • SATV Redemption Options
  • Education Guarantee

  • Training Camp Exclusive Boot Camp Add-ons:
  • Official Exam Testing Onsite During Class
  • Practice Exams/Evening Review Sessions
  • Hotel/Travel Packages
  • Pre-Class Self-Paced Video Access
  • Training on your terms.

    Training Camp offers the full spectrum of learning [delivery] options - providing our customers with end-to-end solutions to assist in achieving education goals.


    Instructor-Led Boot Camp
    Check out our dates and locations for this MCSA SQL 2016 Database Admin Certification Boot Camp.


    Microsoft SATV
    These benefits may cover up to 100% of tuition & courseware, plus other training-related costs as well.


    Group Training
    We offer Microsoft training with onsite exam delivery options to support your team training requirements.



    Microsoft Winner
    As a Microsoft Gold Partner, Training Camp has successfully delivered hands-on, Microsoft database training for Microsoft Certification since 1999. Training Camp pioneered the first exam-focused Microsoft "Exam Prep" Boot Camps, and has since successfully certified thousands of professionals.

    Microsoft Instructors
    Experienced Microsoft MCT & MCSE Certified Instructors

    Our instructors are well-versed in accelerated learning concepts and exam preparation. During our MCSA SQL 2016 Database Admin boot camp, the experience of working with thousands of exam takers give our team unique insight into the learning requirements needed for success. This program delivery accommodates every student's learning needs through individualized instruction, lab partner and group exercises, independent study, self-testing, and question/answer drills.



    MICROSOFT Certification Practice Tests
    Detailed Practice Exams/Evening Review Sessions
    *Training Camp Exclusive Feature

    Our MCSA SQL 2016 Database Admin Certification Boot Camp training boot camp includes custom practice exams - representative of the actual exam questions from Microsoft. During our evening review sessions we drill down on these questions, which is the key to Microsoft exam preparation.


    Microsoft Exam
    Onsite Exams/Retake Vouchers
    *Training Camp Exclusive Feature

    We host the official MCSA SQL 2016 Database Admin 70-764 & 70-765 exams during the class for our students. These exams are delivered at our site - with Pearson VUE/Microsoft approval - not at 'local' testing centers that are subject to seat availability. With our award winning exam prep, , you will be ready to take on this required Microsoft SQL 2016 admin track of exams. Our goal is for students to leave class with knowledge & certification.


    MCSA Server 2016 Course Outline

    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)