Microsoft SQL – SQL Big Data

Take an extra 30% off this course! No coupon needed; auto applies in cart.

$39.00

Sale Ends Soon

  • 00Days
  • 00Hours
  • 00Minutes
  • 00Seconds

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.

7  Training Hours
41 Videos
8  Topics
75 Practice Questions

Course Description

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.

Your Training Instructor

James Ring-Howell

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.

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

$39.00

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.

Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.
Monthly All-Access Subscription
$39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

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!

$49.00

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.

$49.00

In this course you will learn logical table design, indexing and query plans. This course focuses on the creation of database objects including views, stored procedures, parameters and functions. Common aspects of procedure coding such as indexes, concurrency, error handling, and triggers are also covered in this course. This course will also teach you how to optimize indexes, ensure data integrity, implement views, stored procedures and functions as well as manage transactions and locks.

$9.00

This Learn HTML course is designed for beginner level individuals who are interested in learning how to build a page for a website. Our comprehensive training course dives into all areas of HTML writing & editing so that by the end, you will be an expert in coding with HTML!

UNLOCK

25% OFF

Sign up for updates, discounts, and more.