Transform Data: SQL Window Functions
Master the advanced SQL techniques that separate proficient data engineers from the experts. This course transforms your ability to reshape complex data structures and compute sophisticated analytical metrics that power enterprise data pipelines. This Short Course was created to help data management and engineering professionals accomplish seamless data transformation and advanced analytical computations. By completing this course, you'll be able to confidently normalize wide-format data structures, implement complex window functions for time-series analysis, and optimize data pipeline perfo
Skills you'll learn
We may earn a commission if you enroll through our links — it never affects the price you pay.
Similar courses
Data Cleaning, Transformation, and Manipulation
In Data Cleaning, Transformation, and Manipulation, you’ll learn to turn messy data into analysis- and modeling-ready datasets using Python (pandas) and SQL. This is a skill-based path organized around real workplace tasks. Each module mirrors responsibilities you see in job descriptions and focuses on the exact steps you’ll perform on the job. You’ll begin with a quick skills check, then personalize your journey: double down on new topics, or skip what you already know. For each skill, you’ll review concise lessons curated from expert instructors with explanations and demos for filtering and
All levels
Data Engineering with Delta Lake on Databricks
Build production-ready data pipelines using Delta Live Tables and the Medallion Architecture on Databricks. This hands-on course teaches you to design, implement, and monitor ETL workflows that transform raw data into reliable, business-ready datasets through a structured bronze-silver-gold layering pattern. This course is primarily aimed at first- and second-year undergraduates interested in engineering or science, along with professionals with an interest in programming. You will start by mastering DLT fundamentals — declarative pipeline syntax in both SQL and Python, streaming ingestion w
All levels
Advanced Swift Techniques for iOS & Networking
In this course, you will master advanced networking techniques and Swift programming strategies for iOS development. You'll explore how to efficiently fetch and manage network data, build dynamic and interactive graphs using Swift Charts, and implement powerful data pipelines with Combine. These skills are crucial for developing data-driven, high-performance iOS applications. Throughout the course, you'll gain hands-on experience with real-world challenges like managing network data asynchronously and visualizing it with Swift Charts. By mastering these advanced techniques, you'll be able to
All levels
Shipping Rust
Take a Rust crate from a "works on my machine" laptop build to a production-grade artifact that ships through a gate no one can bypass. The course walks through a real 3-crate ETL workspace — etl-core, etl-cli, and etl-bench — built around clap derive macros, a tuned `[profile.release]`, and a multi-stage Dockerfile that drops a 1.8 GB rust:latest image to a 6 MB scratch+musl container with no shell to attack. You then wire pmat, bashrs, forjar, and pv onto the standard fmt + clippy + test + 100% coverage + audit + deny stack — because a green build badge is misleading when an agent wrote half
All levels