CS 186: Introduction to Database Systems (Spring 2015, UC Berkeley): Lecture 15

CS 186: Introduction to Database Systems

CS 186: Introduction to Database Systems (Spring 2015, UC Berkeley). Instructor: Professor Joseph Hellerstein. Introduction to Database Systems - Access methods and file systems to facilitate data access. Hierarchical, network, relational, and object-oriented data models. Query languages for models. Embedding query languages in programming languages. Database services including protection, integrity control, and alternative views of data. High-level interfaces including application generators, browsers, and report writers. Introduction to transaction processing. Database system implementation to be done as term project.

Lecture 15 - Relational Query Optimization I

Go to the Course Home or watch other lectures:

Lecture 01 - Introduction

Lecture 02 - Sorting and Hashing

Lecture 03 - Single-Table Queries

Lecture 04 - Join Algorithms

Lecture 05 - Sorting Data: Disks and Files

Lecture 06 - File Organizations and Indexing

Lecture 07 - Tree-Structured Indexes

Lecture 08 - Relational Algebra

Lecture 09 - SQL: The Query Language

Lecture 10 - SQL: Constraints, SQL Embedded in Other Languages