Python and SQL: Better Together, Powered by DuckDB
Explore DuckDB: A powerful database system integrating seamlessly with Python, offering efficient data processing and easy-to-use SQL capabilities for data scientists and analysts.
Speed is Not All You Need for Data Processing
Exploring data processing frameworks beyond Pandas, challenging assumptions about speed, and emphasizing practical considerations for choosing tools that best serve data practitioners.
Connecting to SQL Databases from VS Code - Creating and Modifying Databases
Learn to connect SQL databases in VS Code using Azure and SQLTools extensions. Create, modify, and interact with databases using Python and SQLAlchemy in this hands-on tutorial.
Sorting and Aggregation Algorithms in Database Systems - Lecture 11
Explore sorting and aggregation algorithms in database systems, featuring insights on dbt from Drew Banin. Gain practical knowledge on efficient data processing techniques.
Modern SQL - Lecture 2
Explore advanced SQL concepts and techniques for efficient database management and querying in modern systems.
Relational Model and Algebra - Lecture 1
Explore relational models and algebra in database systems. Learn fundamental concepts and operations for efficient data management and querying.
Zero to Document Hero
Explore document databases, MongoDB, and their integration with .NET. Learn key differences from relational databases and discover innovative use cases for NoSQL solutions.
An (In-)Complete Guide to C++ Object Lifetimes
Comprehensive exploration of C++ object lifetimes, covering creation, destruction, temporary extensions, memory management, unions, and related concepts, with insights from the standard and proposals.
No More Raw SQL - SQLAlchemy, ORMs and Asyncio
Learn to simplify database management using SQLAlchemy's ORM system and asyncio extension. Discover how to leverage these tools for efficient data synchronization in async services.
Fall in Love with Data Transformation - Using DBT for Effective Data Workflows
Master data transformation with DBT, exploring its integration with SQL and Python. Learn fundamental use cases and workflows to streamline data processes and enhance efficiency in modern data engineering practices.
Continuous Integration and Delivery for Databases
Explore strategies for safe and effective database changes in continuous integration and delivery, covering tools, migrations, and real-world scenarios for both SQL and NoSQL databases.
Kùzu - A Fast, Scalable Graph Database for Analytical Workloads
Discover how to build and analyze knowledge graphs using Kùzu, an open-source graph database. Learn practical implementations, from data transformation to running Cypher queries and training graph neural networks for advanced RAG systems.
Query Planning and Optimization in Database Systems - Lecture 15
Dive into advanced database concepts focusing on query planning strategies, optimization techniques, and execution methods for improved database system performance.
User-Defined Functions in Relational Databases - Challenges and Promising Solutions Based on YeSQL
Explore the challenges and solutions of User-Defined Functions in relational databases, focusing on YeSQL's innovative approach to seamlessly integrate Python UDFs with enhanced performance and functionality.
Tensor Query Processing - Accelerating Database Analytics with AI Hardware
Discover how Microsoft's framework compiles SQL to tensor abstractions, enabling efficient database analytics on GPUs and exploring the fusion of SQL with machine learning capabilities.
Query Execution and ClickHouse Database Systems - Part 2
Dive into advanced query execution concepts and ClickHouse database architecture, covering optimization techniques, processing strategies, and real-world database system implementations.
Advanced SQL Techniques for Data Science
Expand SQL knowledge with complex conditions, functions, joins, and data engineering concepts. Learn from Facebook's Data Engineering Manager in this advanced session.
BigQuery: Google's Cloud Data Warehouse - Lecture 24
Explore Google BigQuery's architecture, query processing, and optimization techniques with insights from a leading database systems expert.
Embedded Database Logic - Lecture 24
Explore embedded database logic concepts, including stored procedures, user-defined functions, and triggers. Learn implementation techniques and their impact on DBMS architecture.
DuckDB Internals - Advanced Database Systems - Lecture 22
Explore DuckDB's architecture, design principles, and internal workings with guest lecturer Mark Raasveldt. Gain insights into advanced database systems and their implementation.
Amazon Redshift Internals - Lecture 24
Explore Amazon Redshift's architecture, design principles, and performance optimizations with insights from a guest lecturer and former CMU PhD graduate.