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.