0

(

ratings

)

1

students

Created by:

Profile Photo

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

24151

Students

Profile Photo
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.