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.
React Suspense in GraphQL with Apollo Client
Explore cutting-edge techniques for building responsive apps by combining GraphQL and React Suspense, enhancing both developer and user experiences.
Data Cleaning with MATLAB - nanoHUB Tech Talk
Learn essential techniques for data cleaning in MATLAB, including handling missing values, removing outliers, and formatting data for analysis. Enhance your research and data processing skills.
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.
Multilingual Programming and Project Structure for Collaboration
Explore multilingual programming and project structures for effective collaboration. Learn to choose the right language for each problem and implement best practices in data science and MLOps.
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.
Discrete Distributions in R - Lecture 6
Master discrete distributions through hands-on practice in R, exploring probability concepts and statistical analysis techniques for working with categorical data.
Introduction to Statistics: Independent and Identically Distributed Random Variables - Lecture 12
Explore fundamental statistical concepts including iid random variables, sample realizations, and the Central Limit Theorem while practicing implementations in R programming.
Confidence Intervals and Hypothesis Testing with R Examples - Lecture 16
Master statistical analysis through confidence intervals and hypothesis testing, with practical R programming examples for real-world data interpretation and decision-making.
Linear Regression and Parameter Estimation in R - Lecture 17
Master linear regression techniques in R while exploring parameter estimation and random variable estimators through hands-on statistical analysis and practical applications.
Machine Learning Fundamentals - Probability and Random Variables - Lecture 3
Dive into fundamental concepts of data science, covering probability theory, random variables, and exploratory data analysis through hands-on projects and interactive lectures.
Expressive Compile Time Parsers in Modern C++
Explore compile-time parsers in C++, from C++11 to C++23. Learn techniques for expressive APIs, zero-overhead code, and advanced features like compile-time regex and reflection.
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.