• Blog
  • Reviews
  • Contact Us
  • Locations
1-844-BOOTCAMP
or 1-941-218-0007
certification camps logo
  • HOME
  • BOOTCAMPS
  • CERTIFICATIONS
    • Microsoft 365
      • MCA Microsoft 365 Security Administrator
      • MCA Modern Desktop Administrator (Windows 10)
      • MCA Microsoft 365 Teamwork Administrator
      • MCA Microsoft 365 Messaging Administrator
      • MCE Microsoft 365 Enterprise Administrator
    • SQL Server
      • MCSA SQL 2016 Database Administration
      • MCSA SQL 2016 Database Development
      • MCSA SQL 2016 Business Intelligence Development
      • MCSA SQL 2016 BI Reporting
      • MTA Database SQL Server
    • Windows Server
      • MCSA Windows Server 2016
      • MCSA Windows 2016 UPGRADE
      • MCSE Core Infrastructure (Security)
      • MTA IT Infrastructure Windows Server
    • Microsoft Azure
      • MCA Azure Administrator
      • MCA Azure Developer
      • MCE Azure Solutions Architect
      • MCE Microsoft Azure DevOps
    • Windows Client
      • MCA Microsoft 365 Modern Desktop Administrator (Windows 10)
    • Exchange Server
      • MCSE Productivity – Exchange 2016
    • Office 365
      • MCE Microsoft 365 Enterprise Administrator (Office 365)
    • Sharepoint Server
      • MCSE Productivity SharePoint 2016 Administrator
    • System Center
      • MCS System Center Configuration Manager v1702 (SCCM)
    • Visual Studio
      • MCSA Web Applications
      • MCP Programming in C#
      • MTA Intro To Programming
    • Information Security
      • EC-Council Certified Ethical Hacker (CEH)
    • CompTia
      • CompTia A+ Essentials
      • CompTia Network +
      • CompTia Security +
  • TECHNICAL TRAINING
  • SCHEDULE
  • DOD 8140
Home > Technical Training > 20764: Administering a SQL Database Infrastructure
SQL SERVER TECHNICAL TRAINING

20764: Administering a SQL Database Infrastructure

Certifications:

  • MCSA: SQL 2016 Database Administration
Length: 6 days
Request More Information
$4995.00
COST:

Delivery Formats:


Exams Included & Administered During Camp:

70-764: Administering a SQL Database Infrastructure

 

Schedule:

  • 01.06.2020 - 01.11.2020
    Register Get Quote
  • 02.03.2020 - 02.08.2020
    Register Get Quote
  • 03.02.2020 - 03.07.2020
    Register Get Quote
  • 03.23.2020 - 03.28.2020
    Register Get Quote
  • 04.20.2020 - 04.25.2020
    Register Get Quote
  • 05.11.2020 - 05.16.2020
    Register Get Quote
  • 06.01.2020 - 06.06.2020
    Register Get Quote

What's Included

  • Airfare To/From Sarasota or TampaAirfare - Your Location To Tampa, FL*
  • 4 Microsoft Test Vouchers1 Microsoft Test Vouchers
  • Microsoft Training Books2 Microsoft Official Courses
  • 12 Nights of Lodging6 Nights of Lodging
  • 2 Retake Vouchers (If needed)1 Retake Voucher (per exam, if needed)
  • Microsoft Study Labs & SimulationsMicrosoft Study Labs & Simulations
  • Ground TransportationGround Transportation
  • Onsite Prometric Testing CenterOnsite Pearson Vue Test Center
  • Instructor Led Classroom TrainingInstructor Led Classroom Training
  • Course Description
  • Microsoft Gold Learning Partner
  • Facilities

This camp is offered as part of the MCSA SQL 2016 Database Administration boot camp.

The Microsoft Official MCSA SQL 2016 Database Administration certification boot camp is a 6 day comprehensive deep dive into the SQL Server covering topics such as database installation, maintenance and configuration. This instructor led live face to face training program will teach you the skills needed to support an SQL 2016 environment.

20764 Administering a SQL Database Infrastructure

While attending this training program - you take two exams to test and certify for the official Microsoft Certified Solutions Associate (MCSA) SQL 2016 Database Administration certification. If your goal is to learn how to use SQL Server 2016 and pass the certification exams (70-764 / 70-765) - you've found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives. Click <a href="https://www.certificationcamps.com/wp-content/uploads/MCSA-SQL-2016-Database-Administration-1.docx">MCSA SQL 2016 Database Administration</a> to download course outline.

<strong>Topics covered in this boot camp:</strong>

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

 

Certification Camps has developed a comprehensive training / delivery format focused on learning beyond the generic book content (accessible to any Microsoft training provider). Our program incorporates interactive demonstrations and detailed real world explanations. When possible - additional content, videos, labs & demonstrations are provided to expand on advanced topics - providing additional insight and perspective.  Certification Camps training is not the typical book & PowerPoint presentation found at any local training center.

As a Microsoft Certified Partner with Gold Learning Competency - we adhere to the strict guidelines, standards and requirements to use Microsoft's exclusive curriculum. More over - our standards go beyond the "minimum requirements" set forth by Microsoft Learning.

We leverage our partnership benefits of courseware customization to build end to end technology training solutions. Students gain practical skills which can be implemented immediately.

At most training centers - learning starts on the first day of class and ends on the last day. Our boot camp training program is designed to offer resources before, during and after the training.

CERTIFICATION CAMPS FACILITIES

CAMPUS - Certification Camps built a state of the art training center with spacious classrooms, no sound transference between rooms, large individual desk, Herman Miller Aeron chairs & great common areas.

CLASSROOM SERVERS - Students work on a dedicated Dell 8700 / 8900 with an Intel i7 (6th generation), 32GB memory with 512GB SSD drives.

CAMPUS INTERNET - The campus is connected with a 300Mbs Verizon Fios Business Connection which provides complete internet (including VPN) access for students.

COMMON AREA - Unlike any training facility ever - break room with Mame Arcade, high end "kitchen" with snacks, drinks (Starbucks Coffee, 100% juices, sodas, etc) and breathtaking terrace.

LODGING - We use the Marriott Fairfield Inn & Suites Lakewood Ranch. This "upgraded" hotel offers extremely comfortable beds, great breakfast and very fast (Verizon) internet access.

NEARBY AMENITIES - Many shops, restaurants and grocery options are available within walking distance. Additionally - the hotel provided scheduled shuttle services. Restaurants like Cheesecake Factory, California Pizza Kitchen, Panera Bread, Bone Fish Grill, Ruby Tuesday's, Five Guys, Chipotle, Quiznos, Chili's and over 20 additional choices in the immediate area. All of these options are offered in a pedestrian walking village.

About

  • About Us
  • Reviews
  • Contact Us
  • Blog

Bootcamps

  • SQL Server
  • Microsoft 365
  • Windows Server
  • Microsoft Azure
  • Office 365
  • Windows 10
  • Exchange Server
  • Sharepoint Server
  • System Center
  • Visual Studio
  • Information Security
  • CompTia
  • Cisco

Certifications

  • SQL Server
  • Microsoft 365
  • Windows Server
  • Windows Client
  • Exchange Server
  • Office 365
  • Sharepoint Server
  • System Center
  • Microsoft Azure
  • Visual Studio
  • Microsoft Technology Associate
  • Information Security
  • CompTia
  • Cisco

Registration

  • More Info
  • Register for a Bootcamp
  • Pay Invoice

Technical Training

  • SQL Server
  • Microsoft 365
  • Microsoft Azure
  • Windows Server
  • Windows Client
  • Exchange Server
  • Office 365
  • Sharepoint
  • System Center
  • Visual Studio

Copyright © 2019 Certification Camps. All rights reserved.

  • Sitemap
  • On Demand Courses
  • Terms & Conditions
  • Privacy Policy