Presto Open Source SQL Engine for Massive Scale Data Lakehouses
Explore Presto's capabilities for fast, scalable SQL analytics across diverse data sources. Learn how major companies leverage it and see a demo on AWS. Discover Presto's open-source success and future enhancements.
Analyzing 33 Million Bike Trips with BigQuery
Explore NYC bike share trends using BigQuery to analyze 33 million trips. Learn to query, visualize, and interpret data for insights on popular routes and rider demographics.
Data Cleansing With SQL And R
Learn data cleansing techniques using SQL and R to prepare and correct data efficiently, focusing on tidy data concepts and practical tools for simplifying research and analysis.
Analyzing StackExchange Data with Azure Data Lake
Gain insights from StackExchange data using Azure Data Lake Store & Analytics. Learn to analyze 150+ GB of data and visualize findings with Power BI, leveraging SQL and C# skills for big data analysis.
Probing the Mysteries of Saturn’s E-Ring with PostgreSQL
Explore Saturn's E-Ring using PostgreSQL for data analysis, including flyby speed calculation and chemistry analysis, to prepare for future space missions and potential life discovery.
Analyzing StackExchange with Azure Data Lake
Explore big data analysis using Azure Data Lake to gain insights from StackExchange data dumps. Learn to leverage SQL and C# skills for efficient data processing and visualization with Power BI.
Four Languages from Forty Years Ago
Explore SQL, Prolog, ML, and Smalltalk from the 1970s, uncovering their unique philosophies and deriving practical principles applicable to modern programming paradigms.
Serverless SQL Pipelines
Explore serverless SQL options across cloud platforms, comparing AWS and Google services. Learn architectural patterns for data lake pipelines and emerging serverless solutions.
Four Languages from Forty Years Ago
Explore SQL, Prolog, ML, and Smalltalk from the 1970s, uncovering their unique philosophies and extracting practical principles relevant to modern programming paradigms.
Getting Started with Cosmos DB - EF Core
Explore Cosmos DB integration with Entity Framework Core, covering setup, features, and practical implementation through demos and code examples.
LanceDB: An Open-Source Serverless Vector Database in Rust
Explore LanceDB, an open-source serverless vector database in Rust. Learn its history, applications in text-to-image recommendations, vector indexing challenges, and in-process database capabilities.
Debugging SQL Queries: Understanding Execution Plans and Query Flow
Explore SQL query debugging techniques, including execution plans and ChatGPT integration. Learn to identify flaws, understand query flow, and optimize performance for more efficient database operations.
Using WebAssembly for In-Database Machine Learning
Explore in-database machine learning with WebAssembly. Learn installation, implementation, deployment, and execution steps for efficient ML integration in databases.
Driving the Future of PostgreSQL Adoption
Explore strategies for accelerating PostgreSQL adoption and shaping its future in the database landscape.
Introduction to BigQuery: Features, Architecture, and Usage
Explore BigQuery's serverless data warehouse capabilities, featuring SQL querying, cross-cloud functionality, and built-in BI and ML tools for efficient data analysis.
Big Data is Dead - The End of an Era and the Future of Data Analytics
Explore why the Big Data era is ending and learn to focus on data utilization for better decision-making, drawing insights from industry analysis and expert experience.
A Case Study in API Cost of Running Analytics in the Cloud at Scale with an Open-Source Data Stack
Explore cloud analytics cost optimization through Uber's case study, examining I/O strategies and performance-cost trade-offs in cloud-native environments versus traditional HDFS deployments.
Python Backend Developer Skills and Learning Path - 2024 Guide
Discover the essential skills, tools, and knowledge required to become a successful Python backend developer, from core language concepts to deployment strategies.
Database Schemas in the Wild - Learning from a Large Corpus of Relational Database Schemas
Explore the insights from GitSchemas, a vast collection of 150k+ database schemas extracted from SQL scripts, revealing patterns in real-world database design and constraints across 1M+ tables.
Shredding Deeply Nested JSON for Efficient Analytics in DuckDB
Discover how DuckDB efficiently processes nested JSON data through vectorized analytics, enabling direct reading of JSON files as tables with automatic schema detection for powerful data analysis.
LingoDB: An Open Compilation and Optimization Framework for Sustainable Data Processing
Discover how LingoDB's open-source framework enables efficient data processing through flexible architecture, cross-domain optimizations, and seamless adaptation to modern hardware capabilities.