Overview

Dive into the depths of SQL Server with this Microsoft SQL – SQL Big Data course and discover one of its most invaluable tools, SQL Big Data Clusters. Here, you will fully explore data virtualization and lakes in order to build a complete artificial intelligence (AI) and machine learning (ML) platform directly within the SQL Server database engine. Dive into the depths of SQL Server with this Microsoft SQL – SQL Big Data course and discover one of its most invaluable tools, SQL Big Data Clusters. Here, you will fully explore data virtualization and lakes in order to build a complete artificial intelligence (AI) and machine learning (ML) platform directly within the SQL Server database engine. This sql server administration course offers students a comprehensive understanding of how to maintain and optimize a Microsoft SQL Server 2019 database. It is specifically tailored towards individuals who want to gain knowledge on the newest features in SQL server 2016, 2017, and 2019 as well as learn about essential capabilities throughout the entire data platform. Students will emerge from this training with an extensive set of skills for managing their own MS SQL Server environment along with its databases! The Microsoft 70-764 SQL Server 2016 Administration course is designed to equip students with all the skills and knowledge necessary for them to confidently pass the Microsoft Certification Exam 70-764. By mastering this program, learners will be fully capable of administering a complete Microsoft SQL 2016 server solution – from installation through maintenance tasks. In this course you will learn how to create Business Intelligence (BI) solutions. This course will teach you how to implement a data warehouse platform to support a BI solution. You will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. In this Microsoft 70-462: Administering SQL Server Databases course you will learn how to perform installation, maintenance, and configuration tasks. This course will also teach you other responsibilities including setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. This course will provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

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.

  • 7 Traning Hours
  • 41 Videos
  • 8 Topics
  • 75 Practice Questions

This SQL Big Data course focuses on one of SQL Server  most impactful features—SQL Big Data Clusters. You will learn about data virtualization and data lakes for this complete artificial intelligence (AI) and machine learning (ML) platform within the SQL Server database engine. You will be shown how to use Big Data Clusters to combine large volumes of streaming data for analysis along with data stored in a traditional database. For instance, you can stream large volumes of data from Apache Spark in real-time while executing Transact-SQL queries to bring in relevant additional data from your corporate, SQL Server database.

About this online course

This course provides everything necessary to get started working with SQL Big Data Clusters in SQL Server . You will learn about the architectural foundations that are made up from Kubernetes, Spark, HDFS, and SQL Server on Linux. You will be shown how to configure and deploy Big Data Clusters. You will be ready to use and unveil the full potential of SQL Server : combining different types of data spread across widely disparate sources into a single view that is useful for business intelligence and machine learning analysis.

  • 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

This Microsoft SQL – SQL Big Data course is intended for data engineers, data scientists, data architects, and database administrators who want to employ data virtualization and big data analytics in their environments.

Frequently Asked Questions About Microsoft SQL – SQL Big Data

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

The course primarily focuses on SQL Big Data Clusters, an impactful feature of SQL Server. It aims to teach students about data virtualization and data lakes, which are used to build a comprehensive AI and ML platform within the SQL Server database engine.

Who is this course suitable for?

This course is perfect for data engineers, data scientists, data architects, and database administrators. It’s especially beneficial for those who want to apply data virtualization and big data analytics in their environments​.

What will I learn from this course?

The course covers a variety of topics, including understanding what a Big Data Cluster is, how to deploy and manage it, and how to analyze large volumes of data directly from SQL Server or via Apache Spark. It also shows how to implement advanced analytics solutions through machine learning, and how to expose different data sources as a single logical source using data virtualization.

Who will be my instructor for this course?

Your instructor will be James Ring-Howell, a Microsoft Certified Trainer and Developer with over 40 years of experience in the field. He has developed applications for a variety of industries and has been teaching technology courses for over 20 years.

What does the course structure look like?

The course is divided into 8 modules, each focusing on a specific aspect of Big Data Clusters. It starts with an introduction to Big Data Clusters and their architecture, then moves on to deployment, data loading and querying, working with Spark, machine learning, creating and consuming Big Data Cluster Apps, and finally maintenance of Big Data Clusters​.

How long is the course and what materials are provided?

The course includes 7 training hours, presented across 41 videos and 8 topics. Additionally, there are 75 practice questions to help reinforce your understanding of the material​​.

Course Outline

Microsoft SQL Server – Big Data 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