1-844-BOOTCAMP
or 1-941-218-0007
20762: Developing SQL Databases
Exam Pass Guarantee
SQL SERVER TECHNICAL TRAINING

20762: Developing SQL Databases

Transform Your Career In 5 days
View Pricing Download Course Details
Syllabus

Course Description

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.

20762: Developing SQL Databases

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.

What's Included

Every SQL Server Boot Camp Comes With

Live Training
Accelerated Live Training by Certified Trainers
Exam Voucher
Exam voucher
Exam Pass Guarantee
One Retake Voucher Per exam, if Needed
Satisfaction Guarantee
Re-sit Your Class at no Additional Charge up to 6 Months
Practice Exams
Vetted and Monthly Updated Practice Exam Resources
Extended Access
90-day Extended Access to Boot Camps Components
How it Works

How Does the Certification Camps Boot Camps Work?

Start your learning immediately with access to content as soon as your registration is processed.
1
Step 1
Before the Boot Camp
Start learning now. Once your registration is processed, you will receive access to materials. Prepare for your live boot camp, identify knowledge gaps to maximize your boot camp experience.
2
Step 2
During the Boot Camp
Attend instructor led live training at our facility in Florida or online (same class, same instructor, same interaction). In person or online – you are actively engaged with the instructor and other students participating in presentations, labs, hands on demonstrations and other learning tools. Students take the certification exam(s) while attending the camp.
3
Step 3
After the Boot Camp
Continue to access your student lab environment for 90 days after your camp is over. In the event you need to defer your exams or would like to re-sit the training – you have up to 6 months after the camp is complete.
Popular Bootcamps

Students Also Like

No related bootcamps found.

Guaranteed Results

The Certification Camps Difference

Expert Instructors
We guarantee you’ll pass your exam or you can retake the class for free.
Guaranteed Classes
Our classes run as scheduled, no cancellations, ensuring you can plan ahead.
High Exam Pass Rate
95% of our students pass their certification exams on first attempt.
20+ Years Experience
With over 20 years in training, we’ve helped thousands achieve certification success.
Your Questions Answered
What is the difference between a bootcamp and a traditional class?
+
At Certification Camps, we offer instructor-led, accelerated training programs—commonly referred to as “bootcamps.” Unlike traditional classroom courses that span weeks or months, our bootcamps are designed to deliver intensive, focused learning in a much shorter timeframe. This means students can master key technologies and prepare for certification in just a few days, without sacrificing quality or depth of instruction.
My company is paying for training. Can I get a quote for approval and an invoice?
+
Yes! You can use the “Generate a Quote” button on our website to receive an instant, formal quote for approval. Once you’re ready and complete registration, an invoice will be sent to you automatically.
Are these bootcamps the official vendor certified courses?
+
Yes – Certification Camps is a certified training partner for all vendors on our website, all training materials are official courseware (no third-party courseware).
Are exams administered while attending the training?
+
Yes – if you attend in person – the exams are administered at our training facility by Pearson Vue. If you are attending online – you have the option to take the exam online or we will provide you with a voucher to take the exam at a local Pearson Vue test center.
Are these courses instructor led live training events?
+
Yes – every bootcamp regardless of in person (at our Florida training center) or online are the same instructor led live training events. You see the instructor, interact with the instructor, view the instructors screen – the instructor is able to assist with labs, answer questions – completely the same experience if you attend online or in-person.
Are your instructor’s vendor certified?
+
Yes – every instructor is certified by the related vendor. For example – every instructor delivering our Microsoft bootcamps are Microsoft Certified Trainers (MCT), every instructor delivering Amazon AWS are Amazon Authorized Instructors (AAI).
Can I attend your instructor led live courses in Florida?
+
Yes – regardless of where you are located – you can attend any of our bootcamp from our facility in Sarasota, FL. In addition to the training – we offer an add on optional domestic travel option which includes up to $500 in airfare and lodging starting the day of the camp and checking out on the final day of camp.