Course Outline
Databricks Platform and Lakehouse Fundamentals
- Overview of the Databricks Lakehouse architecture and its core components
- Strategies for organizing workspaces and catalogs to support governance requirements
Databricks Workspace and Notebooks
- Navigating the workspace environment and utilizing notebook-based development tools
- Structuring code within reusable notebooks to enhance maintainability for government applications
Apache Spark Architecture and Execution
- An examination of the Spark runtime architecture and its execution model
- Understanding lazy evaluation and the directed acyclic graph (DAG) of jobs
PySpark DataFrames and the DataFrame API
- DataFrame abstractions and schema definitions for structured data processing
- Core DataFrame operations and the use of column expressions for data manipulation
Translating SQL to PySpark DataFrames
- Mapping standard SQL clauses to corresponding DataFrame operations
- Implementing window functions and aggregations within PySpark environments
Reading and Writing Data in Databricks
- Accessing data from common file systems and database sources
- Writing data and managing partitions within the Lakehouse architecture for efficient retrieval
Delta Lake and Table Management
- Utilizing Delta tables to ensure ACID (Atomicity, Consistency, Isolation, Durability) transactions
- Implementing time travel capabilities and schema evolution for data integrity
Data Cleaning and Transformation Patterns
- Techniques for data cleaning and type conversion to ensure data quality
- Developing reusable transformation logic to support standardized processing across government systems
User-Defined Functions and Modular Code
- Implementing Python User-Defined Functions (UDFs) and pandas UDFs for custom computations
- Modularizing procedural logic into functions to improve code organization and reusability for government workflows
Performance Tuning and Optimization
- Strategies for partitioning data and utilizing caching mechanisms
- Identifying performance bottlenecks using the Spark UI to optimize resource usage
Structured Streaming Fundamentals
- Comparing batch processing versus streaming processing models for real-time data needs
- Working with streaming DataFrames and performing basic aggregations on continuous data streams
Databricks Jobs and Workflow Orchestration
- Scheduling notebooks as automated jobs and tasks to support operational continuity
- Constructing multi-step workflows with defined dependencies to coordinate complex processes for government agencies
Unity Catalog and Data Governance
- Understanding the Unity Catalog architecture and its namespace management capabilities
- Implementing access control measures and tracking data lineage to ensure compliance and accountability
Testing, Debugging, and Production Practices
- Conducting unit testing on PySpark logic to verify functionality and reliability
- Applying debugging techniques and adhering to code quality standards suitable for production-grade government software
End-to-End Financial Services Use Cases
- Designing an end-to-end Extract, Transform, Load (ETL) pipeline tailored for banking operations
- Converting legacy SQL processes to PySpark to modernize financial data infrastructure
Migrating SQL Workloads to PySpark
- Establishing migration strategies and planning patterns for transition efforts
- Executing the incremental conversion of SQL workflows to PySpark to ensure minimal disruption for government data services
Requirements
- Demonstrated proficiency in Python programming, encompassing functions and data types.
- Comprehensive knowledge of SQL, including joins, aggregations, and subqueries.
- No prior experience with Databricks or PySpark is required for government personnel.
Audience
- Data engineers, data analysts, and other data professionals serving public sector needs.
- Teams currently migrating existing SQL-based workflows to Databricks and PySpark environments.
Testimonials (1)
I liked that it was practical. Loved to apply the theoretical knowledge with practical examples.