ETL Testing E-Learning Training
Ontwikkel geavanceerde vaardigheden in softwarebeveiliging met de DevSecOps Practitioner E-Learning Training. Leer beveiliging integreren in CI/CD-pipelines, applicatietests, containers, Kubernetes en Infrastructure as Code (IaC). Deze training bevat 8 e-learningmodules en een eindtoets en behandelt daarnaast secrets management, Compliance as Code, runtime threat detection en continu risicobeheer.
De DevSecOps Practitioner Training leert u hoe u beveiliging integreert in de volledige softwareontwikkelcyclus. U ontwikkelt praktische kennis van veilige softwarelevering, geautomatiseerde beveiligingstests, cloud-native security en continue compliance.
Deze LearningKit met meer dan 14 leeruren is verdeeld in drie sporen:
Cursusinhoud
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
Voor wie?
DevOps Engineers, DevSecOps Professionals, Security Engineers, softwareontwikkelaars, Cloud Engineers, IT-beveiligingsspecialisten en IT-professionals die beveiliging willen integreren in moderne softwareontwikkeling.
Voorkennis
Basiskennis van DevOps, CI/CD, softwareontwikkeling, cloudomgevingen en cybersecurity wordt aanbevolen. De cursusbeschrijving vermeldt geen formele toelatingseisen.
Start de DevSecOps Practitioner E-Learning Training bij OEM Office Elearning Menu en ontwikkel uw vaardigheden in veilige softwareontwikkeling, cloud-native security en geautomatiseerde compliance.