SQL SERVER BOOTCAMP

MCSA SQL 2014 / MCSE Data Platform COMBO (2 Cert) – 14 Days

Certifications:

Request More Information
ALL-INCLUSIVE COST: What does this price include?
$8,995.00
LENGTH:
14 days
sqlserver2014logo2014060410487638

Exams Included & Administered During Camp:

70-461: Querying Microsoft SQL Server 2014

70-462: Administering a Microsoft SQL Server 2014 Database

70-463: Implementing Data Warehouses with Microsoft SQL Server 2014

70-464: Developing Microsoft SQL Server 2014 Databases

70-465: Designing Database Solutions for Microsoft SQL Server 2014

What's Included

  • Airfare To/From Sarasota or TampaAirfare - Your Location To Tampa, FL*
  • 4 Microsoft Test Vouchers5 Microsoft Test Vouchers
  • Microsoft Training BooksMicrosoft Training Books
  • 12 Nights of Lodging14 Nights of Lodging
  • 2 Retake Vouchers (If needed)5 Retake Vouchers (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
* Please contact us for pricing without lodging and transportation.

The MCSA SQL Server 2014 / MCSE Data Platform certification boot camp is a 14 day comprehensive deep dive into the SQL Server covering topics such as writing queries, administration and data warehousing. This instructor led face to face training camp will teach you the skills needed to support a SQL 2014 environment.

The MCSA SQL Server 2014 / MCSE Data Platform boot camp  incorporates Microsoft Courses -

20461 Querying Microsoft SQL Server 2012
20462 Administering Microsoft SQL Server 2012 Databases
20463 Implementing a Data Warehouse with Microsoft SQL Server 2012
20464 Developing Microsoft SQL Server 2012 Databases
20465 Designing Database Solutions for Microsoft SQL Server 2012

While attending this training program - you take five exams to test and certify for the Microsoft Certified Solutions Associate (MCSA): SQL Server 2014 / Microsoft Certified Solutions Expert (MCSE): Data Platform official certifications. If your goal is to learn how to use SQL Server 2014 and pass the certification exams (70-461, 70-462, 70-463, 70-464, & 70-465) - 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 Microsoft SQL 2014 and click MCSE Data Platform to download course outlines.

Topics covered in this boot camp:

Describe the basic architecture and concepts of Microsoft SQL Server 2014
Understand the similarities and differences between Transact-SQL and other computer languages
Write SELECT queries
Query multiple tables
Sort and filter data
Describe the use of data types in SQL Server
Modify data using Transact-SQL
Use built-in functions
Group and aggregate data
Use subqueries
Use table expressions
Use set operators
Use window ranking, offset and aggregate functions
Implement pivoting and grouping sets
Execute stored procedures
Program with T-SQL
Implement error handling
Implement transactions

Describe core database administration tasks and tools
Install and configure SQL Server 2014
Configure SQL Server databases and storage
Plan and implement a backup strategy
Restore databases from backups
Import and export data
Monitor SQL Server
Trace SQL Server activity
Manage SQL Server security
Audit data access and encrypt data
Perform ongoing database maintenance
Automate SQL Server maintenance with SQL Server Agent Jobs
Configure Database Mail, alerts and notifications

Describe data warehouse concepts and architecture considerations
Select an appropriate hardware platform for a data warehouse
Design and implement a data warehouse
Implement Data Flow in an SSIS Package
Implement Control Flow in an SSIS Package
Debug and Troubleshoot SSIS packages
Implement an ETL solution that supports incremental data extraction
Implement an ETL solution that supports incremental data loading
Implement data cleansing by using Microsoft Data Quality Services
Implement Master Data Services to enforce data integrity
Extend SSIS with custom scripts and components
Deploy and Configure SSIS packages
Describe how BI solutions can consume data from the data warehouse

Introduce the entire SQL Server platform
Cover editions, versions, basics of network listeners, and concepts of services and service accounts
Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types
Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered)
Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints
Determine appropriate single column and composite indexes strategies
Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure
Read and interpret details of common elements from execution plans
Design effective non-clustered indexes
Design and implement views
Design and implement stored procedures
Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses
Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues)
Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency
Use both traditional T-SQL error handling code and structured exception handling
Design and implement DML triggers
Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server
Store XML data and schemas in SQL Server
Perform basic queries on XML data in SQL Server
Work with the GEOGRAPHY and GEOMETRY data types
Implement and query a full-text index

Assess an existing enterprise environment
Plan and implement Policy-Based Management
Describe the considerations for consolidating workloads with SQL Server 2014
Describe considerations for including SQL Server 2014 in a private cloud
Use Microsoft Azure storage with SQL Server 2014
Implement and configure databases in Microsoft Azure SQL Database
Implement and configure databases in Microsoft Azure virtual machines
Describe high availability technologies in SQL Server 2014 and implement log shipping
Describe Windows Server Failover Clustering and Implement an AlwaysOn Failover Cluster Instance
Implement an Always On Availability Group
Plan high availability and disaster recovery solutions
Plan and implement database replication

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.

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.

Before Camp - We provide pre-study materials / pre-class remote lab access / pre-class practice test.

During Camp - While attending camp - you will work hands on with an industry leading "real world experienced" Microsoft Certified Trainer.

After Camp - After your camp is over - learning does not stop. You receive 6 months remote access (Lab on Demand) to your classroom lab environment.

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.