Bryan Cafferky Courses

Data Lakehouse - An Introduction

Explore the Data Lakehouse concept, its comparison to traditional SQL warehouses, and its significance in modern data architecture.

• YouTube
• 25 minutes
• On-Demand
• Free Video

Databricks - How to Use Workflows

Learn to orchestrate and schedule complex multi-task processes using Databricks workflows, a powerful extension to the Jobs service that utilizes DAG architecture for efficient data processing and automation.

• YouTube
• 22 minutes
• On-Demand
• Free Video

Hot Technologies in Data Analytics - What You Need to Learn

Discover essential emerging technologies in Data Analytics and learn how to evaluate them for your career advancement.

• YouTube
• 24 minutes
• On-Demand
• Free Video

Calling REST API's with Python - Talkwalker

Learn to make REST API calls to Talkwalker using Python and save results to SQLite. Covers API documentation, demo, master table creation, and upsert operations.

• YouTube
• 25 minutes
• On-Demand
• Free Video

Databricks Fast Lanes - Better Performance and Lower Costs

Optimize SQL Endpoints with Databricks Fast Lanes for improved performance and cost-efficiency in analytics and data warehouse workloads.

• YouTube
• 21 minutes
• On-Demand
• Free Video

Master Databricks and Apache Spark - SparkR Usage - Lesson 35

Explore SparkR for integrating R with Databricks and Apache Spark, covering architecture, APIs, libraries, and practical examples of data manipulation and analysis.

• YouTube
• 31 minutes
• On-Demand
• Free Video

Master Databricks and Apache Spark - Introduction

Learn the fundamentals of Databricks and Apache Spark, exploring scale-up vs. scale-out concepts and laying the groundwork for mastering these powerful data processing tools.

• YouTube
• 32 minutes
• On-Demand
• Free Video

Master SQL with Python: Maintaining Data in Oracle Using Merge - Lesson 14

Learn to maintain current data in Oracle using Merge statements, integrating with pandas for efficient data updates, inserts, and deletions in Python.

• YouTube
• 29 minutes
• On-Demand
• Free Video

Master SQL with Python: Maintaining Data in SQL Server Using Merge - Lesson 13

Learn to efficiently update SQL Server tables using the Merge statement and pandas integration, ensuring data stays current for analysis. Covers inserting, updating, and deleting rows with practical demonstrations.

• YouTube
• 23 minutes
• On-Demand
• Free Video

Master SQL with Python: Maintaining Data in PostgreSQL Using Upsert - Lesson 12

Learn efficient data maintenance in PostgreSQL using Upsert. Master inserting, updating, and deleting rows to keep your data current and optimize your data analysis workflow.

• YouTube
• 31 minutes
• On-Demand
• Free Video

Master Databricks and Apache Spark Step by Step - PySpark Using RDDs

Explore PySpark and RDDs in Databricks: Learn about lazy evaluation, transformations, and actions while analyzing data using Resilient Distributed Datasets.

• YouTube
• 21 minutes
• On-Demand
• Free Video

Using SQL Window Functions in Databricks and Apache Spark - Lesson 16

Learn to leverage Spark SQL window functions for advanced data engineering on Databricks, including cumulative totals, ranking, and aggregations alongside detail rows, enhancing your data manipulation capabilities.

• YouTube
• 24 minutes
• On-Demand
• Free Video

Using SQL Views in Databricks and Apache Spark - Lesson 12

Learn to create and utilize SQL views in Databricks for efficient data analysis and pipeline reuse. Explore common table expressions, aggregations, and case statements for advanced querying techniques.

• YouTube
• 28 minutes
• On-Demand
• Free Video

Understanding Spark SQL - Lesson 6

Explore Spark SQL's powerful features for data engineering, including query optimizations and support for Python, R, and Scala, enhancing parallel processing performance.

• YouTube
• 27 minutes
• On-Demand
• Free Video

Using the Data Science Process - Lesson 5

Explore the data science process from project inception to completion, covering key steps for successful implementation in Databricks and Apache Spark projects.

• YouTube
• 41 minutes
• On-Demand
• Free Video