Get in Touch

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.
 35 Hours

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories