Microsoft SQL 2019 – Big Data
- Caption
- Certificate
- Dedicated Tutors
- 41 Videos
- 7.6 Hours
- 75 Test Questions
Course Description
Microsoft SQL 2019: Big Data
The Microsoft SQL Server 2019: Big Data course is designed for professionals who want to leverage SQL Server 2019's capabilities for handling and analyzing large-scale data sets. This course explores the integration of SQL Server with big data technologies, focusing on how to work with large volumes of data efficiently. Participants will learn how to configure, manage, and analyze big data using SQL Server's built-in tools and features, including the integration of Hadoop and Spark.Key Features:
- Big Data Architecture: Understand the architecture of SQL Server 2019's big data capabilities, including its integration with Hadoop Distributed File System (HDFS) and Apache Spark.
- Data Virtualization: Learn how to use SQL Server's PolyBase feature to query and integrate data from various sources, including Hadoop and other external data stores, as if it were part of a single database.
- Big Data Clusters: Explore the setup, configuration, and management of SQL Server Big Data Clusters, including deploying and scaling clusters and integrating them with other data processing tools.
- Data Ingestion and Preparation: Discover techniques for ingesting and preparing large data sets for analysis, including using data lakes and staging data for further processing.
- Advanced Analytics with Apache Spark: Gain insights into using Apache Spark with SQL Server to perform advanced analytics, including machine learning and large-scale data processing.
- Performance Tuning and Optimization: Learn strategies for optimizing the performance of big data queries and operations, including tuning data storage and processing workflows.
- Security and Data Governance: Understand best practices for securing big data environments, managing access controls, and ensuring data governance and compliance.
- Data Visualization and Reporting: Explore tools and techniques for visualizing and reporting on big data, including integration with Power BI for interactive dashboards and insights.
This course equips professionals with the knowledge and skills needed to manage and analyze large-scale data using SQL Server 2019, enabling them to harness the power of big data technologies to drive informed business decisions.
Proudly Display Your Achievement
Upon completion of your training, you will receive a personalized certificate of completion to help validate your new skills.
Step-by-Step Courses List
Module 1: What are Big Data Clusters?
- 1 Introduction
- 2 Linux, PolyBase, and Active Directory
- 3 Scenarios
Module 2: Big Data Cluster Architecture
- 1 Introduction
- 2 Docker
- 3 Kubernetes
- 4 Hadoop and Spark
- 5 Components
- 6 Endpoints
Module 3: Deployment of Big Data Clusters
- 1 Introduction
- 2 Install Prerequisites
- 3 Deploy Kubernetes
- 4 Deploy BDC
- 5 Monitor and Verify Deployment
Module 4: Loading and Querying Data in Big Data Clusters
- 1 Introduction
- 2 HDFS with Curl
- 3 Loading Data with T-SQL
- 4 Virtualizing Data
- 5 Restoring a Database
Module 5: Working with Spark in Big Data Clusters
- 1 Introduction
- 2 What is Spark
- 3 Submitting Spark Jobs
- 4 Running Spark Jobs via Notebooks
- 5 Transforming CSV
- 6 Spark-SQL
- 7 Spark to SQL ETL
Module 6: Machine Learning on Big Data Clusters
- 1 Introduction
- 2 Machine Learning Services
- 3 Using MLeap
- 4 Using Python
- 5 Using R
Module 7: Create and Consume Big Data Cluster Apps
- 1 Introduction
- 2 Deploying, Running, Consuming, and Monitoring an App
- 3 Python Example - Deploy with azdata and Monitoring
- 4 R Example - Deploy with VS Code and Consume with Postman
- 5 MLeap Example - Create a yaml file
- 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
Reviews
You must be logged in to post a review.
What is Included
-
Professional Certification
Exam-focused prep and certification guidance aligned to your learning path.
-
ATS-Optimized Resume
Build a resume that highlights your new skills for recruiters and hiring systems.
-
Mock Interviews
Practice real interview scenarios with structured feedback from career coaches.
-
LinkedIn Optimization
Polish your profile so employers discover your credentials and achievements.
-
Job Placement Support
Career guidance and placement resources on eligible programs.
-
Practical Labs
Hands-on labs and exercises to reinforce concepts from your courses.
The course provided clear explanations and strong practical examples that helped me improve my Microsoft skills.
A well-organized course that strengthened both my theoretical and practical knowledge.
This course enhanced my understanding and boosted my confidence for the exam.
Excellent training with easy-to-follow modules and helpful demonstrations.
Great instructor-led content with practical exercises that made learning easier.
The course provided clear explanations and strong practical examples that helped me improve my Microsoft skills.
Very informative and well-organized content for professionals.
Very informative and well-organized content for professionals.
Detailed lessons and great support materials for exam preparation.
Detailed lessons and great support materials for exam preparation.
The course gave me hands-on skills in database design and analysis.