Microsoft SQL – SQL Big Data



Discover one of SQL Server’s most useful features, SQL Big Data Clusters, by delving into its depths with this Microsoft SQL – SQL Big Data course. In order to construct a whole artificial intelligence (AI) and machine learning (ML) platform within the SQL Server database engine, you will completely investigate data virtualization and lakes in this section.

  • 7  Training Hours
  • 41 Videos
  • 8  Topics
  • 75 Practice Questions
SKU: 601956327137 Category:

Introducing the game-changing SQL Big Data course! Get ready to unlock the full potential of SQL Server and revolutionize your data analysis skills.

In this dynamic and exhilarating course, you will dive deep into the world of SQL Big Data Clusters—the cutting-edge feature that will take your data management abilities to new heights. Brace yourself for a transformative journey through the realm of artificial intelligence (AI) and machine learning (ML) within the SQL Server database engine.

Prepare to be amazed as you harness the incredible power of data virtualization and data lakes. With SQL Big Data Clusters, you’ll seamlessly merge vast volumes of streaming data with your existing data stores, bringing together the best of both worlds. Imagine streaming real-time data from Apache Spark while effortlessly executing Transact-SQL queries to access additional corporate data from your SQL Server database. The possibilities are boundless!

This course goes above and beyond to equip you with everything you need to become a SQL Big Data Clusters virtuoso. Uncover the architectural foundations of this revolutionary technology, comprising Kubernetes, Spark, HDFS, and SQL Server on Linux. Gain invaluable insights as you learn to configure and deploy Big Data Clusters with confidence and finesse.

But that’s not all—prepare to dazzle the world with your newfound skills! By mastering SQL Big Data Clusters, you’ll seamlessly combine disparate data sources into a single, comprehensive view. Empower your business intelligence efforts and propel your machine learning analyses to unprecedented heights.

As an added bonus, this course provides an opportunity to demonstrate your expertise with an optional certification exam. Showcase your mastery of SQL Big Data Clusters to employers and colleagues alike, setting yourself apart as a sought-after data professional.

Don’t miss this chance to embark on a thrilling learning adventure. Join us now and be at the forefront of the SQL Server revolution. Unleash the true potential of your data with SQL Big Data Clusters—where innovation meets limitless possibilities!

Optional Certification Exam: Upon successful completion of the course, you have the opportunity to take the certification exam, validating your proficiency in SQL Big Data Clusters. Stand out from the crowd and showcase your expertise to potential employers. The exam covers essential concepts, practical skills, and best practices in SQL Big Data Clusters, further cementing your status as a leading data professional.

  • What a Big Data Cluster is
  • How to deploy BDC
  • How to analyze large volumes of data directly from SQL Server
  • How to analyze large volumes of data via Apache Spark
  • How to manage data stored in HDFS from SQL Server as if it were relational data
  • How to implement advanced analytics solutions through machine learning
  • How to expose different data sources as a single logical source using data virtualization

For data engineers, data scientists, data architects, and database administrators who want to use data virtualization and big data analytics in their environments, this Microsoft SQL – SQL Big Data course is designed.

Course Outline:

Module 1: What are Big Data Clusters?
1.1 Introduction
1.2 Linux, PolyBase, and Active Directory
1.3 Scenarios

Module 2: Big Data Cluster Architecture
2.1 Introduction
2.2 Docker
2.3 Kubernetes
2.4 Hadoop and Spark
2.5 Components
2.6 Endpoints

Module 3: Deployment of Big Data Clusters
3.1 Introduction
3.2 Install Prerequisites
3.3 Deploy Kubernetes
3.4 Deploy BDC
3.5 Monitor and Verify Deployment

Module 4: Loading and Querying Data in Big Data Clusters
4.1 Introduction
4.2 HDFS with Curl
4.3 Loading Data with T-SQL
4.4 Virtualizing Data
4.5 Restoring a Database

Module 5: Working with Spark in Big Data Clusters
5.1 Introduction
5.2 What is Spark
5.3 Submitting Spark Jobs
5.4 Running Spark Jobs via Notebooks
5.5 Transforming CSV
5.6 Spark-SQL
5.7 Spark to SQL ETL

Module 6: Machine Learning on Big Data Clusters
6.1 Introduction
6.2 Machine Learning Services
6.3 Using MLeap
6.4 Using Python
6.5 Using R

Module 7: Create and Consume Big Data Cluster Apps
7.1 Introduction
7.2 Deploying, Running, Consuming, and Monitoring an App
7.3 Python Example – Deploy with azdata and Monitoring
7.4 R Example – Deploy with VS Code and Consume with Postman
7.5 MLeap Example – Create a yaml file
7.6 SSIS Example – Implement scheduled execution of a DB backup

Module 8: Maintenance of Big Data Clusters
8.1 Introduction
8.2 Monitoring
8.3 Managing and Automation
8.4 Course Wrap Up

Frequently Asked Questions About Microsoft SQL – SQL Big Data

What is the main focus of the Microsoft SQL – SQL Big Data course?

The primary focus of the Microsoft SQL – SQL Big Data course is to explore the capabilities of SQL Server’s Big Data Clusters. This course delves into data virtualization and data lakes, which enable the creation of a powerful AI and ML platform within the SQL Server database engine.

Who is this course suitable for?

This course is designed for individuals working in data engineering, data science, data architecture, and database administration roles. It is particularly beneficial for professionals seeking to implement data virtualization and big data analytics in their environments.

What will I learn from this course?

By taking this course, you will gain a comprehensive understanding of various topics related to SQL Big Data. These include the fundamentals of Big Data Clusters, their deployment and management, analysis of large data volumes using SQL Server and Apache Spark, implementation of advanced analytics solutions through machine learning, and leveraging data virtualization to unify different data sources.

Who will be my instructor for this course?

James Ring-Howell, a highly experienced Microsoft Certified Trainer and Developer with over 40 years of industry expertise, will be your instructor for this course. He has developed applications for various industries and has been teaching technology courses for more than 20 years.

What does the course structure look like?

The course is structured into 8 modules, each focusing on a specific aspect of SQL Big Data Clusters. It begins with an introduction to Big Data Clusters and their architecture, progresses to cover deployment, data loading and querying, working with Apache Spark, machine learning integration, creating and utilizing Big Data Cluster Apps, and concludes with maintenance tasks for Big Data Clusters.

How long is the course and what materials are provided?

The course consists of approximately 7 hours of training material, delivered through 41 videos across 8 topics. Additionally, you will have access to 75 practice questions to reinforce your understanding of the concepts presented in the course.

Your Training Instructor

James Ring-Howell

Microsoft Certified Trainer | Microsoft Certified Developer | Database Expert

James is a full-stack developer with over 40 years of experience. He has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. James has also been teaching technology courses for over 20 years. In addition to his extensive background in technology, he has also worked as a professional opera singer.