• Blog
  • Reviews
  • Contact Us
  • Locations
1-844-BOOTCAMP
or 1-941-218-0007
Certification Camps
  • BOOTCAMPS
    • Microsoft 365 Enterprise
      • MCE Microsoft 365 Enterprise Administrator
      • MCA Microsoft 365 Messaging Administrator
      • MCA Microsoft 365 Security Administrator
      • MCA Microsoft 365 Teams Administrator
      • MCA Microsoft 365 Modern Desktop
    • Microsoft Azure Admin
      • MCA Azure Administrator
      • MCA Azure Security Engineer
      • MCA Windows Server Hybrid Administrator
      • MCE Azure DevOps Engineer
      • MCE Azure Solutions Architect
      • MCS Azure Virtual Desktop
    • Microsoft Azure Data
      • MCA Azure Database Administrator
      • MCA Azure Data Engineer
      • MCA Azure Data Analyst Power BI
      • MCA Power Platform Developer
      • MCA Power Platform Functional Consultant
      • MCE Power Platform Solution Architect
    • Microsoft Developer
      • MCA Azure Developer
      • MCE Azure DevOps Engineer
      • MCA Power Platform Developer
      • MCE Power Platform Solution Architect
      • MCA Microsoft 365 Developer
    • Microsoft Security
      • MCA Identity & Access Admin
      • MCA Information Protection Admin
      • MCA Security Operations Analyst
    • Combo Classes
      • Azure Admin & Azure Architect
      • Azure Developer & Azure DevOps
      • Microsoft 365 Desktop & Enterprise Admin
      • Microsoft 365 Security & Enterprise Admin
    • 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 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

20762: Developing SQL Databases

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

Certifications

  • MCSA: SQL 2016 Database Development

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
  • Facilities
  • Microsoft Gold Learning Partner

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

The Microsoft Official MCSA SQL 2016 Database Development boot camp is a 5 day comprehensive deep dive into the SQL Server developer topics such as writing queries, subqueries, expressions, operators, stored procedures, functions and XML data. Students learn how to program both on-premises and cloud based databases. This instructor led face to face training program will teach you the skills needed to support SQL 2016 developer task.

The SQL Database Development boot camp incorporates Microsoft Official Courses

20761 Querying Data with Transact-SQL
20762 Developing SQL Databases

While attending this training program - if your goal is to learn how to use SQL Server Database Development 2016.

Click MCSA SQL 2016 Database Development to download course outline.

Skills Gained:

Describe key capabilities and components of SQL Server 2016.
Describe T-SQL, sets, and predicate logic.
Write a single table SELECT statement.
Write a multi-table SELECT statement.
Write SELECT statements with filtering and sorting.
Describe how SQL Server uses data types.
Write DML statements.
Write queries that use built-in functions.
Write queries that aggregate data.
Write subqueries.
Create and implement views and table-valued functions.
Use set operators to combine query results.
Write queries that use window ranking, offset, and aggregate functions.
Transform data by implementing pivot, unpivot, rollup and cube.
Create and implement stored procedures.
Add programming constructs such as variables, conditions, and loops to T-SQL code.

Design and Implement Tables.
Describe advanced table designs
Ensure Data Integrity through Constraints.
Describe indexes, including Optimized and Columnstore indexes
Design and Implement Views.
Design and Implement Stored Procedures.
Design and Implement User Defined Functions.
Respond to data manipulation using triggers.
Design and Implement In-Memory Tables.
Implement Managed Code in SQL Server.
Store and Query XML Data.
Work with Spatial Data.
Store and Query Blobs and Text Documents.

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.

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.

About

  • About Us
  • Reviews
  • Contact Us
  • Blog

Bootcamps

  • SQL Server
  • Microsoft 365 Enterprise
  • Windows Server
  • Microsoft Azure Admin
  • Windows Client
  • Exchange Server
  • System Center
  • Microsoft Developer
  • Information Security
  • CompTia
  • Cisco

Vendors

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

Job Role

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

Registration

  • More Info
  • Register for a Bootcamp
  • Pay Invoice

Copyright © 2023 Certification Camps. All rights reserved.

  • Terms & Conditions
  • Privacy Policy