Create Google BigQuery Tables via the Python SDK Use Google Cloud's Python SDK to insert large datasets into Google BigQuery, enjoy the benefits of schema detection, and manipulating data programmatically.
Scrape Structured Data with Python and Extruct Supercharge your scraper to extract quality page metadata by parsing JSON-LD data via Python's extruct library.
Simplify BigQuery ETL jobs using SQLAlchemy Extract and move data between BigQuery and relational databases using PyBigQuery: a connector for SQLAlchemy.
Using Amazon Redshift as your Data Warehouse Get the most out of Redshift by performance tuning your cluster and learning how to query your data optimally.
Join and Aggregate PySpark DataFrames Perform SQL-like joins and aggregations on your PySpark DataFrames.
Working with PySpark RDDs Working with Spark's original data structure API: Resilient Distributed Datasets.
Manage Data Pipelines with Apache Airflow Use Apache Airflow to build and monitor better data pipelines.
Structured Streaming in PySpark Become familiar with building a structured stream in PySpark using the Databricks interface.
Becoming Familiar with Apache Kafka and Message Queues Getting to know Apache Kafka: a horizontally scalable event streaming platform. Learn what makes Kafka critical to high-volume low-latency data pipelines.
Cleaning PySpark DataFrames Easy DataFrame cleaning techniques ranging from dropping rows to selecting important data.
Transforming PySpark DataFrames Apply transformations to PySpark DataFrames such as creating new columns, filtering rows, or modifying string & number values.
Learning Apache Spark with PySpark & Databricks Get started with Apache Spark in part 1 of our series, where we leverage Databricks and PySpark.
Building an ETL Pipeline: From JIRA's REST API to SQL Build a pipeline which extracts raw data from the JIRA's Cloud API, transforms it, and loads the data into a SQL database.
Working With GraphQL Fragments and Mutations Make your GraphQL queries more dynamic with Fragments, plus get started with Mutations.
Building a Client For Your GraphQL API Now that we have an understanding of GraphQL queries and API setup, it's time to get that data.
Welcome to SQL: Modifying Databases and Tables Brush up on SQL fundamentals such as creating tables, schemas, and views.
From CSVs to Tables: Infer Data Types From Raw Spreadsheets The quest to never explicitly set a table schema ever again.
Psycopg2: PostgreSQL & Python the Old Fashioned Way Connect to a PostgreSQL database and execute queries in Python using the Psycopg2 library.
Databases in Python Made Easy with SQLAlchemy Leverage the iconic SQLAlchemy Python library to effortlessly handle database connections and queries in software.
MongoDB Stitch Serverless Functions A crash course in MongoDB Stitch serverless functions: the bread and butter of MongoDB Cloud.
Scraping Data on the Web with BeautifulSoup Use Python's BeautifulSoup library to assist in the honest act of systematically stealing data without permission.
Create a REST API Endpoint Using AWS Lambda Create an AWS Lambda function to pull records from a database.
