0
(
ratings
)
1
students
Created by:
Last updated:
September 26, 2023
Duration:
Unlimited Duration
FREE
This course includes:
Unlimited Duration
Badge on Completion
Certificate of completion
Unlimited Duration
Description
CS 186: Introduction to Database Systems (Spring 2015, UC Berkeley). Instructor: Professor Joseph Hellerstein.
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 Curriculum
- 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
About the instructor
5
5
Instructor Rating
6
Reviews
4637
Courses
24154
Students
OpenCoursa
We are an educational and skills marketplace to accommodate the needs of skills enhancement and free equal education across the globe to the millions. We are bringing courses and trainings every single day for our users. We welcome everyone woth all ages, all background to learn. There is so much available to learn and deliver to the people.
