Systems Design

Schemas

Data models

DB systems

Select-From-Where

Joins

Set operators

Subqueries

Grouping

Aggregations

Nested queries

Sorting algorithm

Building Indices

Query Optimization

IO Model

Database index

CS 145 Data Management and Data Systems Stanford University Fall 2022 This course primarily focuses on the utilization of databases in applications, scaling for large datasets, and effective data systems design. It explores relational data models, SQL, and schema design, concluding with a hands-on SQL+Python project. The course requires CS 103 and CS 107 or equivalent as prerequisites. This course covers how to use databases in applications, first principles on how to scale for large data sets and how to design good data systems.

A few key topics:

— Introduction to relational data model, relational database engines, and SQL.

— How to scale systems for large data sets on servers and server clusters

— How to design good schemas based on dependencies, normal forms so we build and evolve good applications. This will include indexes, views and transactions.

The class will culminate in a hands-on programming project in SQL+Python — a key part of the course — where you will query, visualize and predict from terabytes of data on [BigQuery](https://cloud.google.com/bigquery/), a popular cloud database part of Google Cloud Platform.  CS 103 and CS 107 (or equivalent) 

CS 145 Data Management and Data Systems

Database Systems

Systems design

Systems Design

1 courses cover this concept

CS 145 Data Management and Data Systems