MCSA: SQL 2016 Data Engineering with Azure
Exams Included & Administered During Camp:
70-775: Perform Data Engineering on Microsoft HD Insight
70-776: Engineering Data with Microsoft Cloud Services
- Airfare - Your Location To Tampa, FL*
- 2 Microsoft Test Vouchers
- 2 Microsoft Official Courses
- 6 Nights of Lodging
- 1 Retake Voucher (per exam, if needed)
- Microsoft Study Labs & Simulations
- Ground Transportation
- Onsite Pearson Vue Test Center
- Instructor Led Classroom Training
The Microsoft Official MCSA SQL 2016 Data Engineering with Azure certification boot camp is a 6 day comprehensive deep dive into the SQL Server covering topics such as how to process Big Data using Azure tools and services including Azure Stream Analytics, Azure Data Lake, Azure SQL Data Warehouse and Azure Data Factory. Additionally - the bootcamp will give students the ability plan and implement big data workflows on HDInsight. This instructor led live face to face training program will teach you the skills needed to support an SQL 2016 Azure environment.
The SQL boot camp incorporates Microsoft Official Courses -
20775 Performing Data Engineering on Microsoft HD Insight
20776 Engineering Data with Microsoft Cloud Services
While attending this training program - you take two exams to test and certify for the official Microsoft Certified Solutions Associate (MCSA) SQL Data Engineering with Azure certification. If your goal is to learn how to use SQL Server 2016 and pass the certification exams (70-775 / 70-776) - you've found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives.
Topics covered in this boot camp:
Deploy HDInsight Clusters.
Authorizing Users to Access Resources.
Loading Data into HDInsight.
Implement Batch Solutions.
Design Batch ETL Solutions for Big Data with Spark
Analyze Data with Spark SQL.
Analyze Data with Hive and Phoenix.
Describe Stream Analytics.
Implement Spark Streaming Using the DStream API.
Develop Big Data Real-Time Processing Solutions with Apache Storm.
Build Solutions that use Kafka and HBase.
Describe common architectures for processing big data using Azure tools and services.
Describe how to use Azure Stream Analytics to design and implement stream processing over large-scale data.
Describe how to include custom functions and incorporate machine learning activities into an Azure Stream Analytics job.
Describe how to use Azure Data Lake Store as a large-scale repository of data files.
Describe how to use Azure Data Lake Analytics to examine and process data held in Azure Data Lake Store.
Describe how to create and deploy custom functions and operations, integrate with Python and R, and protect and optimize jobs.
Describe how to use Azure SQL Data Warehouse to create a repository that can support large-scale analytical processing over data at rest.
Describe how to use Azure SQL Data Warehouse to perform analytical processing, how to maintain performance, and how to protect the data.
Describe how to use Azure Data Factory to import, transform, and transfer data between repositories and services.
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.
During Camp - While attending camp - you will work hands on with an industry leading "real world experienced" Microsoft Certified Trainer.