• Blog
  • Reviews
  • Contact Us
  • Locations
1-844-BOOTCAMP
or 1-941-218-0007
Certification Camps
  • BOOTCAMPS
    • Microsoft 365 Enterprise
      • MCE Microsoft 365 Administrator Expert
      • MCE Microsoft 365 Enterprise Administrator
      • MCA Microsoft 365 Comm Sys Engineer
      • MCA Microsoft 365 Endpoint Administrator
      • MCA Microsoft 365 Messaging Administrator
      • MCA Microsoft 365 Modern Desktop
      • MCA Microsoft 365 Teams Administrator
    • Microsoft Azure Admin
      • MCE Azure Solutions Architect
      • MCE Azure DevOps Engineer
      • MCA Azure Administrator
      • MCA Azure Security Engineer
      • MCA Windows Server Hybrid Administrator
    • Microsoft Azure Data
      • MCA Azure Database Administrator
      • MCA Azure Data Engineer
      • MCA Azure Data Analyst Power BI
    • Microsoft Power Platform
      • MCE Microsoft Power Platform Combo
      • MCE Power Platform Solution Architect
      • MCA Power Platform Functional Consultant
      • MCA Power Platform Developer
    • Microsoft Developer
      • MCE Azure DevOps Engineer
      • MCA Azure Developer
      • MCA Power Platform Developer
      • MCA Microsoft 365 Developer
    • Microsoft Security
      • MCE Cyber Security Architect Expert
      • MCA Identity & Access Admin
      • MCA Information Protection Admin
      • MCA Security Operations Analyst
    • Microsoft MCE Combo Classes
      • MCA/MCE MS 365 Endpoint & Admin Expert
      • MCA/MCE MS Azure Admin & Architect
      • MCA/MCE MS SecOps & Cyber Security Architect
      • MCA/MCE Power Platform Consult & Architect
    • Amazon Web Services
      • Architecting on AWS Accelerator
      • AWS Cloud Prac Solutions & Architect Associate
      • AWS Certified Developer Associate
      • AWS Certified DevOps Engineer Professional
    • CompTia
      • CompTia A+ Essentials
      • CompTIA Cloud+
      • CompTIA CySA+ (Cyber Security Analyst+)
      • CompTia Network+
      • CompTia Security+
    • Information Security
      • EC-Council Certified Ethical Hacker (CEH)
      • (ISC)² CISSP
    • Cisco
      • Cisco CCNP Routing and Switching
      • Cisco CCNA
  • Find Training
    • Training By Job Role
      • Developer
      • Administrator
      • Architect
      • Data Engineer
      • DevOps
      • Security
    • Vendors
      • Microsoft
      • Amazon
      • Cisco
      • CompTIA
      • Ec-Council
    • Microsoft Technical
      • Azure
      • Microsoft 365
      • Power Platform
      • Security
      • Messaging
      • Modern Desktop
      • Windows Server
      • SQL Server
    • Click here to find your course
  • SCHEDULE
  • Role Based Certifications
  • Pay an Invoice
Home > Technical Training
SQL SERVER TECHNICAL TRAINING

20765: Provisioning SQL Databases

$3,995 CLASSROOM LIVE
Price includes: Instructor Led Class, Official Courseware, Labs and Exams

Certifications

  • MCSA: SQL 2016 Database Administration

Course Delivery

This course is available in the following formats:

Classroom Live
Duration:
5 days
Remote Classroom Live
Duration:
5 days
Request More Information

Please note - Exams & Certification will no longer be available after Jan 31st, 2021 

What's Included

  • Airfare To/From Sarasota or TampaAirfare To/From Sarasota or Tampa
  • Microsoft Training Books2 Microsoft Official Courses
  • 12 Nights of Lodging5 Nights of Lodging
  • Microsoft Study Labs & SimulationsMicrosoft Study Labs & Simulations
  • Ground TransportationGround Transportation
  • Instructor Led Classroom TrainingInstructor Led Classroom Training
  • Course Description
  • Microsoft Gold Learning Partner
  • Certification Camps Campus

Please note - Exams & Certification will no longer be available after Jan 31st, 2021. Certification Camps will continue to offer this as a "training only" 5 day event after Jan 31st, 2021. 

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.

The SQL boot camp incorporates Microsoft Official Courses

20764 Administering a SQL Database Infrastructure
20765 Provisioning SQL Databases

While attending this training program - if your goal is to learn how to use SQL Server 2016 - you've found the right place. This course is a hybrid of actual hands on learning.

Click MCSA SQL 2016 Database Administration to download course outline.

Skills Gained:

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)
Provision, migrate and manage databases in the cloud

Certification Camps has developed a comprehensive training / delivery format which focuses on learning beyond the core content accessible to any Microsoft training provider. Our program incorporates interactive demonstrations with explanations which go beyond the content of the book. 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.

CERTIFICATION CAMPS FACILITIES

CAMPUS - Certification Camps invested $150,000 into a complete training center construction build out. Larger classrooms, no sound transference between training rooms, new desk / executive leather chairs & great common areas.

CLASSROOM SERVERS - Students work on a dedicated Dell 8500 / 8700 with an Intel i7 (4th generation), minimum of 16GB memory (Most with 32 GB) and most 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.

NEAR BY AMENITIES - Many shops, restaurants and grocery options are available within walking distance. Additionally - the hotel provided scheduled shuttle services. Restaurants like 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.

Popular Bootcamps
Azure Administrator
Microsoft 365 Enterprise Administrator
Windows Server Hybrid Administrator
Azure Solutions Architect
Architecting on AWS Accelerator

About

  • About Us
  • Blog
  • Contact Us
  • Reviews

Bootcamps

  • Amazon Web Services
  • Microsoft 365 Enterprise
  • Microsoft Azure Admin
  • Microsoft Developer
  • Microsoft Power Platform
  • Microsoft Security
  • Windows Server
  • Windows Client

Vendors

  • Amazon
  • Cisco
  • CompTia
  • Ec-Council
  • Microsoft

Job Role

  • Administrator
  • Architect
  • Data Engineer
  • Developer
  • DevOps
  • Security

Registration

  • More Info
  • Pay Invoice
  • Register for a Bootcamp

Copyright © 2023 Certification Camps. All rights reserved.

  • Terms & Conditions
  • Privacy Policy