- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft SQL – SQL Big Data
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.
Included In This Course
Included In This Course
7 Training Hours
41 On-demand Videos
Closed Captions
8 Topics
75 Prep Questions
Certificate of Completion
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.
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​​.
Proudly DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Course Outline
Microsoft SQL Server - Big Data Course Content
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
Your Training Instructor
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.
$49.00
OR
Subscribe To All-Access
Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.
$49.00 $14.99 Monthly
Microsoft SQL – SQL Big Data
Microsoft SQL – SQL Big Data
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
7 Days Free - $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
Master the skills to become a Microsoft Certified Solutions Associate with our 70-462 Administering SQL Server course. Enroll now and start your journey!
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.
$49.00
Master JavaScript Fundamentals and build powerful web applications with our comprehensive online training. Start now!
If you’re ready to dive into Java Programming, this JavaScript Fundamentals online training course is for you! You’ll start with the basics and work your way up to advanced levels. Not only will you get a comprehensive introduction to object-oriented programming, but also learn many other core Java features in detail. Don’t miss out on this opportunity – sign up now and make strides in mastering Java today!
$49.00
Boost your career with our comprehensive Microsoft 70-487 online course on developing Azure and web services.
In this Microsoft 70-487 course you will learn how to access data, query and manipulate data by using the entity framework, create and consume web API-based services, design and implement web services, and deploy in Microsoft Azure and Web Services.
I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.
The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.
The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!
This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.