Concept
SQL
Related lectures (81)
Data Wrangling with Hadoop
Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Views: Simplifying SQL Queries
Explores views in SQL, covering creation, materialization, maintenance, cube building, and top-k queries optimizations.
Views: SQL Queries Simplification
Explores how views simplify query writing and are key in data warehouses.
Relational Model: Basics
Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Query Optimization: Execution Models
Explores Run-Length Encoding, Query optimization, and Execution models for efficient query processing.
CS422 Project: Iterator Model (Volcano)
Covers the CS422 project on the iterator model and relational operators.
Data Streams and Approximation
Explores data stream management, real-time analytics, data stream models, and processing challenges.
Handling Data: Intro to Pandas
Introduces the fundamentals of handling data, emphasizing the importance of Pandas and data modeling for effective analysis.
Approximate Query Processing: BlinkDB
Introduces BlinkDB, a framework for approximate query processing using data samples to provide fast answers.
Static Analysis for Amy: Introduction to AST-based Analysis
Introduces AST-based analysis and its benefits over testing, covering its applications, rule implementations, and limitations.