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.
Relational Model and Algebra - Introduction to Database Systems - Lecture 1
Explore relational models and algebra in database systems, covering key concepts like data models, primary keys, and algebraic operations for effective database design and querying.
Modern SQL - Lecture 2
Explore modern SQL concepts, including aggregates, group by clauses, string operations, and date/time functions. Learn advanced techniques for efficient database querying and manipulation.
OtterTune: AI-Powered Database Optimization as a Service
Explore AI-powered database optimization with OtterTune, revolutionizing performance tuning through machine learning and automation.
User-Defined Function Optimizations in Advanced Database Systems - Lecture 11
Explore advanced optimization techniques for user-defined functions in database systems, enhancing query performance and system efficiency.
DuckDB Embedded Database System - Lecture 20
Explore DuckDB's embedded database system architecture, features, and performance optimizations for analytical workloads in this advanced database systems lecture.
From Code to Cloud: Quality Kubernetes Deployments with Monokle
Master Kubernetes deployments using open-source tools. Learn to install apps, configure resources, implement OPA validation, use Kustomize overlays, and compare deployments for efficient cloud-native development.
Writing Your Own CLI Tools with PowerShell: A Case Study of SQLTop - PSHSummit 2022
Explore CLI tool creation with PowerShell through SQLTop case study. Learn challenges, user experience, system quirks, and practical techniques for efficient PowerShell-based tool development.
Discrimination is Wrong - Improving Productivity in Haskell Library Design
Explore advanced Haskell library design, optimizing discrimination techniques for O(n) operations. Dive into category theory, encodings, system-level concerns, and laziness properties.
Expressive Compile-Time Parsers in C++
Explore compile-time parsers in C++ for expressive APIs and DSLs. Learn techniques, compare libraries, and discover applications in regular expressions, parser generators, and reflection features.
A Deep Dive Into C++ Object Lifetimes
Comprehensive exploration of C++ object lifetimes, covering creation, destruction, temporary extensions, memory management, unions, and related concepts. Insights from standards, proposals, and optimizations.
Complete Web Development Course 2024 - HTML, CSS, JavaScript, ReactJS, and More
Master web development essentials: HTML, CSS, JavaScript, ReactJS, databases, PHP, and AI integration. Build interactive websites and games while learning industry-relevant skills for 2024.
SQLucid - Grounding Natural Language Database Queries with Interactive Explanations
Explore interactive techniques for translating natural language queries into SQL, featuring novel approaches for database interaction and query explanation.
History of America
Explore key events in American history, from the Revolutionary War to the rise of capitalism, through engaging episodes covering independence, conflicts, and economic shifts.
Reward Systems
Learn about reward systems, including compensation and benefits, with data analysis techniques for design and evaluation.
Better Evaluation for Text2SQL Using Apache Calcite
Discover how Apache Calcite enhances Text2SQL evaluation methods, improving query accuracy and performance in data analysis workflows.
SQL Support in Elasticsearch via Apache Calcite
Explore how Apache Calcite enables SQL support in Elasticsearch, covering implementation details and practical applications for enhanced data querying capabilities.
Using Input Numbers, Text, and Select Helpers in Home Assistant
Master input helpers in Home Assistant by learning to create and configure custom number, text, and select fields for enhanced automation control and improved smart home interface customization.
Build an AI App on Streaming Data with Azure Databricks SQL and Genie
Discover how to build AI-powered data workflows by integrating Azure Databricks SQL, Genie APIs, and Power BI for seamless data connectivity, governance, and natural language querying capabilities.
Efficient XML and JSON Parsing in Elixir - Performance Optimization Techniques
Discover how to achieve 10x faster XML parsing in Elixir through selective parsing techniques, with practical applications for JSON processing and enhanced security measures.