MCSE Data Mgmt & Analytics (MCSA SQL 2016 Admin + MCSA SQL 2016 Developer) – 11 Days

The Microsoft Official MCSE Data Mgmt & Analytics combines the MCSA SQL 2016 Database Administration & MCSA SQL 2016 Database Development certification boot camps into a combined 11 day complete MCSE certification program. This camp is comprehensive deep dive into the SQL Server covering topics such as database installation, maintenance, configuration, writing queries, subqueries, expressions, operators, stored procedures, functions and XML data. 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 -

20761 Querying Data with Transact-SQL
20762 Developing SQL Databases
20764 Administering a SQL Database Infrastructure
20765 Provisioning SQL Databases

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 MCSA SQL 2016 Database Administration to download course outline.

Topics covered in this boot camp:

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

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 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 your typical book & PowerPoint presentation found at any local training center.

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.

CERTIFICATION CAMPS DIFFERENCE

Certification Camps provides an in-depth hands on learning environment. Our instructors teach using demonstrations and explain concepts beyond the scope of the courseware. The best instructors are contracted from all across the US.  These professionals are real world consultants who actually implement these technologies. Certification Camps knows our clients work in the "real world" and it only makes sense to have an instructor with the experience in the real world.

Facilities - Many of our competitors over-crowd classrooms by placing 2 to 3 students per desk and 20+ students per instructor. Often these companies "extend" the life of very old equipment with slow performance on the software used today. Our average class size is 8 students. Our facilities have the best equipment with the most comfortable, focused environment for learning.

Instructors - Our CEO, Chester Flake holds one of the rarest Microsoft Certifications - the Microsoft Certified Learning Consultant (MCLC) Certification.  This certification reflects a commitment to make sure our instructors are also actively engaged in real world consulting projects. Students expect a professional who can answer questions and demonstrate the technology.

Face to Face Training - We believe the best way to interact and learn is face to face training.  Many of our competitors which offer local training are simply providing students with headphones/mic to attend class with an instructor at a remote location.

Test Pass - We offer a free retake voucher (if needed) for each of the exams required for certification. Any training center offering a "100% pass guarantee" would have to use unethical practices or unlimited test vouchers (which is not likely or practical).

Distractions - Students often look for a "local" training center so they can be close to home and work. Boot camp requires a tremendous time commitment during the program.  Long class hours combined with self study each evening. The goal of boot camp is to achieve certification in a fraction of the time. We strongly recommend students attend camp away from home and work in a focused, distraction free environment.

Boot Camp - Boot camp is an accelerated training focused on teaching technology and testing students on the official exams. Most training providers "added" boot camps to the existing standard training classes they offer.  These training centers think a boot camp is just a regular class where you send the student home with a voucher on the last day.  Certification Camps  administers exams throughout the camp. Equally important - not every trainer can teach a boot camp and not all courseware is designed for boot camp format.  Our trainers know the boot camp format and our courseware is designed for accelerated learning.

Florida - Certification Camps has one of the most scenic locations boasting some of the best weather in US. We believe students should have a comfortable and inviting atmosphere while attending these otherwise intense programs. We place our location, facilities and amenities up against that any competitor.