1
CS 186: Introduction to Database Systems (Spring 2015, UC Berkeley). Instructor: Professor Joseph Hellerstein.
FREE
This course includes
Hours of videos
777 years, 8 months
Units & Quizzes
28
Unlimited Lifetime access
Access on mobile app
Certificate of Completion
ntroduction 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.
Course Currilcum
- Lecture 01 – Introduction Unlimited
- Lecture 02 – Sorting and Hashing Unlimited
- Lecture 03 – Single-Table Queries Unlimited
- Lecture 04 – Join Algorithms Unlimited
- Lecture 05 – Sorting Data: Disks and Files Unlimited
- Lecture 06 – File Organizations and Indexing Unlimited
- Lecture 07 – Tree-Structured Indexes Unlimited
- Lecture 08 – Relational Algebra Unlimited
- Lecture 09 – SQL: The Query Language Unlimited
- Lecture 10 – SQL: Constraints, SQL Embedded in Other Languages Unlimited
- Lecture 11 – SQL (Cont.), Entity-Relationship Diagrams and the Relational Model Unlimited
- Lecture 12 – Entity-Relationship Diagrams and the Relational Model (Cont.) Unlimited
- Lecture 13 – Functional Dependencies and Schema Refinement Unlimited
- Lecture 14 – Functional Dependencies and Schema Refinement Unlimited
- Lecture 15 – Relational Query Optimization I Unlimited
- Lecture 16 – Relational Query Optimization II Unlimited
- Lecture 17 – Elementary IR: Scalable Boolean Text Search Unlimited
- Lecture 18 – Ranking and Crawling, Data Visualization Unlimited
- Lecture 19 – Data Visualization (Cont.), Transactions and Concurrency Control Unlimited
- Lecture 20 – Transactions and Concurrency Control (Cont.) Unlimited
- Lecture 21 – Big Data Analytics Systems (Guest Lecture by Reynold Xin) Unlimited
- Lecture 22 – Advanced Topics in Concurrency Control Unlimited
- Lecture 23 – Advanced Topics in Concurrency Control (Cont.), Crash Recovery Unlimited
- Lecture 24 – A Perspective on Data Science (Guest Lecture by Tye Rattenbury) Unlimited
- Lecture 25 – Crash Recovery (Cont.) Unlimited
- Lecture 26 – Crash Recovery Wrap-up; Distributed Data, Replication and NoSQL Unlimited
- Lecture 27 – Review I Unlimited
- Lecture 28 – Review II Unlimited
