Overview What You Will Learn Curriculum Instructor

Course Overview

Data is the lifeblood of any organization and Azure Synapse Analytics is the flagship data offering in Microsoft’s cloud, combining data warehousing with dedicated SQL pools, on-demand and ad hoc querying with the serverless SQL pool, and data transformation with Apache Spark pools.   With all of this functionality across various integrated products, Azure Synapse Analytics has a broad surface area.   If you want to secure your data while still enabling data scientists and business analysts to deliver data-driven insights, this is the course for you!

In this course, you will gain an understanding of the core functionality behind Azure Synapse Analytics, including the three types of data pools and ETL orchestration with Synapse Pipelines.   You will understand how your company can make use of Synapse Analytics and then how to lock it down so that only the right people can access data relevant to them.  You will learn the best practices for securing Azure Synapse Analytics, covering everything from network and storage-level security up to controlling who sees which individual rows of data.

If you want to design, implement, and secure your Azure Synapse Analytics data warehouse, this course will give you the foundation you need for success.

The necessary resources for this course are in the "Resources" section of Video 1.1. You can also access them through this direct link - https://github.com/ec-council-learning/Securing-Your-Data-Warehouse-with-Azure-Synapse-Analytics

What You Will Learn

  • Azure Synapse Analytics includes and using each of the components to deliver a data warehousing experience
  • Implementing network and storage security practices to create a safe foundation for Synapse
  • Creating a data warehouse with dedicated SQL pools
  • including creating tables
  • loading data
  • and locking down access to data
  • The serverless SQL pool and how to use it for ad hoc query analysis
  • and ways to create a secure environment for your users
  • Where Spark pools and Synapse Pipelines fit into the equation and how to improve your security posture when using them
  • Tools available in and around Azure Synapse Analytics to protect against data exfiltration
  • alert on potential threats or vulnerabilities
  • and enhance data security

Program Curriculum

  • An Overview of the Business Case
  • Meet the Personas
  • What’s in Azure Synapse Analytics?
  • $7 Million Cybersecurity Scholarship by EC-Council
  • Chapter 1 Quiz

  • Deploy the Source Data
  • Review Existing Customer Data
  • Build an Architecture from the Ground Up
  • Data Collection and Regulatory Compliance
  • High Availability and Disaster Recovery Options
  • Chapter 2 Quiz

  • Deploy Azure Synapse Analytics Resources
  • Network Security Groups
  • Configure the Network
  • Create Synapse Pools and Linked Services
  • Set Permissions and Assign Security Roles
  • Chapter 3 Quiz

  • Create Tables and Load Data
  • Encrypt and Mask Data
  • Use Role-based Access Controls to Assign Permissions
  • Implement Row-level Security
  • Perform Data Discovery and Classification
  • Chapter 4 Quiz

  • Query Data from the Serverless SQL Pool
  • Structure Data with PolyBase External Objects
  • Securely Access Stored Data with SAS Tokens
  • Implement Row-level Security
  • Chapter 5 Quiz

  • Interact with Spark via Notebook
  • Authorization and Lake Databases
  • Import Python Libraries
  • Control Storage Account Permissions
  • Loading Data from Cosmos DB via Synapse Link
  • Chapter 6 Quiz

  • What are Synapse Pipelines?
  • Build an ELT Pipeline
  • Span Virtual Networks with Pipelines
  • Connect to Remote Data Using Integration Runtimes
  • Secure Synapse Pipelines
  • Chapter 7 Quiz

  • Advanced Threat Protection
  • Review Vulnerability Assessment Findings
  • Create Rules with Azure Policy
  • Protect Against Data Exfiltration
  • Use Customer-managed Keys
  • Chapter 8 Quiz
Load more modules

Instructor

Kevin Feasel

Kevin Feasel is a Microsoft Data Platform MVP out of Durham, North Carolina, where he runs a Predictive Analytics team for a major e-commerce company. Kevin has developed and delivered training across the breadth of Azure Synapse Analytics, with a focus on delivering great solutions which fit business needs while maintaining a strong security posture and respecting the customer’s privacy. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

Join over 1 Million professionals from the most renowned Companies in the world!

certificate

Empower Your Learning with Our Flexible Plans

Invest in your future with our flexible subscription plans. Whether you're just starting out or looking to enhance your expertise, there's a plan tailored to meet your needs. Gain access to in-demand skills and courses for your continuous learning needs.

Monthly Plans
Annual Plans
Save 20% with our annual plans!

Pro

Ideal for continuous learning, offering extensive resources with 600+ courses and diverse Learning Paths to enhance your skills.

$ 499.00
Billed annually or $59.00 billed monthly
Get Started Now
Start your 7-day trial for $1

What is included

  • 700+ Premium Short Courses
  • 50+ Structured Learning Paths
  • Validation of Completion with all courses and learning paths
  • New Courses added every month
Early Access Offer

Pro +

Experience immersive learning with Practice Labs, CTF Challenges, and exclusive EC-Council certifications for comprehensive skill-building.

$ 599.00
Billed annually or $69.00 billed monthly
Get Started Now
Start your 7-day trial for $1

Everything in Pro and

  • 800+ Practice Lab exercises with guided instructions
  • 150+ CTF Challenges with detailed walkthroughs
  • New Practice Labs and Challenges added every month
  • 3 Official EC-Council Essentials Certifications¹ (retails at $897!)
    Exclusive Bonus with Annual Plans

¹This plan includes Digital Forensics Essentials (DFE), Ethical Hacking Essentials (EHE), and Network Defense Essentials (NDE) certifications. No other EC-Council certifications are included.

Related Courses

  • AWS Certified Security Specialty - Cert Prep

    AWS Certified Security Specialty - Cert Prep

    Short Course

    AWS Certified Security Specialty - Cert Prep

    Cloud Security

    Everything that you need to know to pass the Amazon Web Servi...

    $49.99

    Intermediate

    5 hr 48 m

  • Azure Kubernetes Service - Deploy ElasticStack (ELK)

    Azure Kubernetes Service - Deploy ElasticStack (ELK)

    Short Course

    Azure Kubernetes Service - Deploy ElasticStack (ELK)

    Cloud Security

    Learn Kubernetes fundamentals right from scratch

    $49.99

    Intermediate

    4 hr 0 m

  • Containers and Kubernetes on Azure

    Containers and Kubernetes on Azure

    Short Course

    Containers and Kubernetes on Azure

    Cloud Security

    Containerize your applications with Containers and Kubernetes...

    $49.99

    Beginner

    1 hr 30 m

  • Introduction to Azure Cloud Security Tools and Services

    Introduction to Azure Cloud Security Tools and Services

    Short Course

    Introduction to Azure Cloud Security Tools and Services

    Cloud Security

    Explore the Microsoft Azure Cloud Platform and gain an unders...

    $49.99

    Beginner

    1 hr 39 m

  • AZ 900 - Basics of Cloud Computing

    AZ 900 - Basics of Cloud Computing

    Short Course

    AZ 900 - Basics of Cloud Computing

    Cloud Security

    Everything you need to know about Cloud Computing with Azure

    $49.99

    Beginner

    1 hr 0 m

  • Entra ID and Entra Domain Services

    Entra ID and Entra Domain Services

    Short Course

    Entra ID and Entra Domain Services

    Cloud Security

    Learn how Entra ID (Azure Active Directory), On-Premises AD a...

    $49.99

    Intermediate

    4 hr 0 m

  • Introduction to Cloud Computing

    Introduction to Cloud Computing

    Short Course

    Introduction to Cloud Computing

    Cloud Security

    Learn about evolution of cloud and cloud models

    $49.99

    Beginner

    2 hr 0 m

  • Serverless Computing on AWS with Lambda, API Gateway, S3 and DynamoDB

    Serverless Computing on AWS with Lambda, API Gateway, S3 and DynamoDB

    Short Course

    Serverless Computing on AWS with Lambda, API Gateway, S3 and D...

    Cloud Security

    Master serverless computing technologies on AWS while develop...

    $59.99

    Intermediate

    4 hr 0 m

1 8