Menu
EUR
Nieuw: Microsoft Copilot-trainingen voor uw team. Direct starten
ETL Testing Training
€277,09 €229,00
In shopping cart
ETL Testing Training
(0)
ETL Testing Training

ETL Testing Training

€277,09 €229,00 Incl. tax Excl. tax
In stock

Learn ETL Testing, data validation, SQL testing, data quality, and ETL process testing. Develop practical skills in data warehouse testing through online e-learning. Read more.

Make a choice
ETL Testing Training
165383956
In stock
165383956
€277,09 €229,00
  • Officieel testcentrum
    Microsoft, Certiport en Pearson VUE
  • Bekroonde e-learning
    Met proefexamens en 24/7 hulp van Sanne
  • ISO 9001 & 27001 werkwijze
    2.500+ organisaties gingen u voor
  • Microsoft Certified Trainers
    Incompany op maat, met gratis nulmeting

Product description

ETL Testing E-Learning Training

Develop advanced software security skills with the DevSecOps Practitioner E-Learning Training. Learn to integrate security into CI/CD pipelines, application testing, containers, Kubernetes, and Infrastructure as Code (IaC). This training includes 8 e-learning modules and a final assessment, covering secrets management, Compliance as Code, runtime threat detection, and continuous risk management.

The DevSecOps Practitioner Training develops practical skills in integrating security throughout the software development lifecycle. Learn to secure software delivery pipelines, automate security testing, protect cloud-native applications, and implement continuous compliance and governance.

This LearningKit with more than 11 hours of learning is divided into three tracks:

Course Outcome

1. Secure CI/CD Pipelines

Introduction to ETL and Data Warehousing

Course: 1 Hour, 4 Minutes

  • Course Overview
  • ETL Core Concepts and Terms
  • ETL vs. ELT Approach Selection
  • Cloud vs. On-Premises ETL Solutions
  • ETL Role in Enterprise Data Ecosystems
  • Common Data Source Types
  • Data Warehouse Architecture Components
  • ETL Tools and Architecture
  • ETL vs. Database Testing Differences
  • Data Quality Impact on ETL
  • ETL Security Core Principles
  • Course Summary

Fundamentals of ETL Testing

Course: 1 Hour, 28 Minutes

  • Course Overview
  • Data Flows in Tableau Prep
  • Exploring Sample Flows in Tableau Prep Builder
  • Designing a Data Cleaning Workflow and Filtering Null Values
  • Removing and Replacing Null Values
  • Using Data Roles and Splitting Columns in Tableau
  • Refining a Tableau Flow and Exporting Cleaned Data
  • Designing a Flow and Applying Cleaning Steps in Tableau Prep
  • Executing Data Transformations in Tableau Prep Builder
  • Using Data Filters and Implementing Value Constraints
  • Experimenting with Data Roles in Error Detection and Correction
  • Applying Data Roles for Validating Geographic Fields
  • Using Aggregation Summarization Steps in Tableau Prep
  • Crafting and Verifying Calculated Fields in Tableau Prep
  • Course Summary

ETL Testing Using SQL

Course: 39 Minutes

  • Course Overview
  • SQL Queries for ETL Validation
  • Advanced SQL Functions for Data Comparison
  • Comparing Source and Target Datasets
  • Extracting and Validating Data for Accuracy
  • Validating Simple Data Transformations
  • Generating Basic ETL Test Reports
  • Troubleshooting Data Mismatches
  • Course Summary

2. Container, Kubernetes, and IaC Securi

ETL Testing Essentials: Fundamental Testing Techniques

Course: 1 Hour, 32 Minutes

  • Course Overview
  • Introduction to ETL Testing
  • Potential Issues in Extract, Transform, and Load Phases
  • ETL Test Design Techniques
  • Workflow and Orchestration Testing
  • SQL Validation
  • Error Handling and Recovery Testing
  • Change Impact Testing
  • Performance and Scalability Testing
  • Resource Utilization Monitoring
  • Data Quality Validation
  • Security and Compliance Testing
  • PII Detection and Classification
  • Course Summary

ETL Testing Essentials: Test Automation

Course: 1 Hour, 16 Minutes

  • Course Overview
  • ETL Test Design
  • CI/CD for ETL Pipelines
  • Data Management in ETL Tests
  • Types of Data
  • ETL Testing Components
  • ETL Testing Tools
  • ETL Test Output Reporting
  • Execution Metadata in ETL Test Outputs
  • Lineage and Aggregate Data Quality Scores
  • Course Summary

ETL Testing Essentials: Advanced ETL Testing - Data Warehouses

Course: 1 Hour, 15 Minutes

  • Course Overview
  • Data Warehouses in ETL Pipelines
  • ETL Testing in Data Warehouses
  • Dimensional Model and Schema Testing
  • Testing Schema Integrity and SCDs
  • Validating Star and Snowflake Schemas
  • Aggregation and Calculation Testing
  • Data Quality Validation
  • Data Lineage and Metadata
  • User Acceptance Testing (UAT)
  • Performance and Optimization Testing
  • Course Summary

ETL Testing Essentials: Testing and Validating ETL Pipelines

Course: 1 Hour, 9 Minutes

  • Course Overview
  • Configuring a Cloud Storage Source and BigQuery Destination
  • Running an ETL Pipeline Using Prebuilt Templates and Dataflow Jobs
  • Running Dataform Assertions to Validate Data in BigQuery
  • Loading Invalid Data and Debugging Test Failures
  • Fixing ETL Pipelines and Verifying Fixes
  • Configuring an Inspect Template and De-Identification Template
  • Running a Masking Pipeline for Sensitive Data
  • Running Dataform Assertions to Verify Security and Compliance
  • Course Summary

3. Secrets Management and Compliance

Advanced ETL Testing: Big Data ETL Testing

Course: 1 Hour, 16 Minutes

  • Course Overview
  • Distributed Architectures for Big Data
  • Apache Spark-Based ETL Testing
  • Testing in Apache Spark
  • NoSQL Data Validation
  • NoSQL ETL Testing
  • Data Lake Architectures
  • Data Lake ETL Testing
  • Stream Processing Validation
  • Course Summary

Advanced ETL Testing: Cloud-Based ETL Testing

Course: 1 Hour, 24 Minutes

  • Course Overview
  • Distributed Architectures for Big Data
  • Apache Spark-Based ETL Testing
  • Testing in Apache Spark
  • NoSQL Data Validation
  • NoSQL ETL Testing
  • Data Lake Architectures
  • Data Lake ETL Testing
  • Stream Processing Validation
  • Course Summary

Advanced ETL Testing: Advanced Techniques in ETL Testing

Course: 55 Minutes

  • Course Overview
  • Risk-Based Testing
  • Metrics and KPIs for Enterprise Data
  • Validating Data Integration and Migration
  • Data Governance for ETL Pipelines
  • Auditing and Logging ETL Pipelines
  • Compliance Validation
  • Course Summary

Advanced ETL Testing: ETL Testing for Modern Data Architectures

Course: 1 Hour

  • Course Overview
  • Testing Microservices-Based Architectures
  • ETL Testing for Microservices Architectures
  • Data Mesh Architecture
  • ETL Testing for Data Mesh
  • Validating Data for ML Models
  • Testing AI-Powered Data Pipelines
  • Anomaly Detection in ETL Pipelines
  • Course Summary

Advanced ETL Testing: Performing Advanced ETL Tests

Course: 1 Hour, 11 Minutes

  • Course Overview
  • Setting Up the Python Environment and gcloud CLI for Pipeline Testing
  • Initializing and Exploring a dbt Project
  • Writing dbt Tests for Testing Data in BigQuery
  • Running a Basic Pipeline and Running dbt Tests
  • Writing Unit Tests and Verifying Warehouse Data with dbt
  • Committing Project Changes to GitHub
  • Creating a CI/CD Workflow on GitHub Actions
  • Running CI/CD on GitHub Actions
  • Course Summary

Who Should Attend?

DevOps Engineers, DevSecOps Professionals, Security Engineers, Software Developers, Cloud Engineers, Cybersecurity Specialists, and IT professionals interested in securing modern software delivery.

Prerequisites

Basic knowledge of DevOps, CI/CD, software development, cloud environments, and cybersecurity is recommended. No formal prerequisites are specified.

Start your DevSecOps Practitioner E-Learning Training with OEM Office Elearning Menu and develop essential skills in secure software development, cloud-native security, and automated compliance.

Specifications

Article number
165383956
SKU
165383956
Language
English
Qualifications of the Instructor
Certified
Course Format and Length
Teaching videos with subtitles, interactive elements and assignments and tests
Lesson duration
Varies per course, see the course content
Assessments
The assessment tests your knowledge and practical skills on the topics of the learning path. Available for 365 days after activation.
Online virtual labs
12 months of access to virtual labs, active from activation. Availability varies per course
Online mentor
24/7 access to an online mentor for your technical questions on the subject. Available for 365 days after activation, depending on the chosen Learning Kit.
Progress monitoring
Access to Material
365 days
Technical Requirements
Computer or mobile device, stable internet connection, web browser such as Chrome, Firefox, Safari or Edge
Support or Assistance
Helpdesk and online knowledge base 24/7
Certification
Certificate of participation in PDF format
Price and costs
Course price at no extra cost
Cancellation and withdrawal
According to our general terms and conditions
Award-winning e-learning
Tip!
Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform.

Reviews

0/5
0 stars based on 0 reviews
0 reviews
Twijfelt u welke training past?
Heeft u vragen over dit product of hulp nodig bij het bestellen? Onze AI-chatbot is 24/7 beschikbaar, of neem contact op via [email protected] of bel +31 36 760 1019
Twijfelt u welke training past?
Heeft u vragen over dit product of hulp nodig bij het bestellen? Onze AI-chatbot is 24/7 beschikbaar, of neem contact op via [email protected] of bel +31 36 760 1019

Recently viewed

LearnKit
ETL Testing Training
ETL Testing Training
Learn ETL Testing, data validation, SQL testing, data quality, and ETL process t...
€277,09 €229,00

Specifications

Article number
165383956
SKU
165383956
Language
English
Qualifications of the Instructor
Certified
Course Format and Length
Teaching videos with subtitles, interactive elements and assignments and tests
Lesson duration
Varies per course, see the course content
Assessments
The assessment tests your knowledge and practical skills on the topics of the learning path. Available for 365 days after activation.
Online virtual labs
12 months of access to virtual labs, active from activation. Availability varies per course
Online mentor
24/7 access to an online mentor for your technical questions on the subject. Available for 365 days after activation, depending on the chosen Learning Kit.
Progress monitoring
Access to Material
365 days
Technical Requirements
Computer or mobile device, stable internet connection, web browser such as Chrome, Firefox, Safari or Edge
Support or Assistance
Helpdesk and online knowledge base 24/7
Certification
Certificate of participation in PDF format
Price and costs
Course price at no extra cost
Cancellation and withdrawal
According to our general terms and conditions
Award-winning e-learning
Tip!
Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform.
0/5
0 stars based on 0 reviews
0 reviews
Choose your language
Choose your currency
€

Recently added

Total excl. VAT
€0,00
Order for another €0,00 and receive free shipping
0
Compare
Start comparison

Review ETL Testing Training

This product has been added to your cart
Wij gebruiken functionele en analytische cookies (Google Analytics). Geen persoonsgegevens voor advertenties. Kies hieronder of beheer uw voorkeuren. Manage cookies