Joins

Schemas

Data models

DB systems

Select-From-Where

Set operators

Subqueries

Grouping

Aggregations

Nested queries

Sorting algorithm

Building Indices

Query Optimization

Systems Design

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

Histograms

Pivots

Models

P-Value

Confidence Intervals

Sample Means

Least Squares

Privacy

Bayes' theorem

Data type

Iteration 

Census

Function (computer programming)

Chance

Comparing Distributions

A/B Testing

Center and Spread

Correlation

Residuals

Classification

Conditional probability

Tables

Charts

Groups

Conditional (computer programming)

Sampling

Decisions

Causality

Normal distribution

Linear regression

Regression Inference

Classifiers

Data 8: The Foundations of Data Science UC Berkeley Fall 2022 UC Berkeley's course blends inferential thinking, computational thinking, and real-world relevance, offering students hands-on analysis of real-world datasets. It covers critical concepts in computer programming, statistical inference, privacy, and study design. Foundations of Data Science combines three perspectives: inferential thinking, computational thinking, and real-world relevance. Given data arising from some real-world phenomenon, how does one analyze that data so as to understand that phenomenon? The course teaches critical concepts and skills in computer programming and statistical inference, in conjunction with hands-on analysis of real-world datasets, including economic data, document collections, geographical data, and social networks. It also delves into social issues surrounding data analysis such as privacy and study design.  This course does not have any prerequisites beyond high-school algebra. The curriculum and format is designed specifically for students who have not previously taken statistics or computer science courses. Students with some prior experience in either statistics or computing are welcome to enroll and will find much of interest due to the innovative nature of the course. Students who have taken several statistics or computer science courses should instead take a more advanced course. Our primary text is an online book called [Computational and Inferential Thinking: The Foundations of Data Science](http://inferentialthinking.com/). This text was written for the course by the course instructors. A complete PDF of the textbook can be found in the Student Materials Google Drive.

The computing platform for the course is hosted at [data8.datahub.berkeley.edu](file:///Users/jweichert/Desktop/Data%208/data-8.github.io/fa22/data8.datahub.berkeley.edu). Students find it convenient to use their own computer for the course. If you do not have adequate access to a personal computer, we can help you borrow a machine; please contact data8@berkeley.edu.

Data 8: The Foundations of Data Science

Data Science

scikit-image

scikit-learn

pandas (software)

Jupyter Notebook

Code Complexity

Memory management

Python

List (abstract data type)

File Processing

pandas DataFrame

Data Science Libraries

Search

Images

Statistics

Indexes

Control Structures

Data structure

Data Visualization

Class (computer programming)

Algorithmic Efficiency

Ethics

p-hacking

Tree (data structure)

NumPy

String (computer science)

Computer file

Machine learning

Object (computer science)

Geospatial Data

Convolution

Algorithmic fairness

Algorithmic Privacy

CSE 163 Intermediate Data Programming University of Washington Summer 2022 This course offers an intermediate level of data programming, focusing on different data types, data science tools, code complexity, and memory management. It emphasizes the efficient use of concepts for data programming. The world has become data-driven. Domain scientists and industry increasingly rely on data analysis to drive innovation and discovery; this reliance on data is not only restricted to science or business, but also is crucial to those in government, public policy, and those wanting to be informed citizens. As the size of data continues to grow, everyone will need to use powerful tools to work with that data.

This course teaches intermediate data programming. It is a follow on to CSE142 (Computer programming I) or CSE160 (Data Programming).

The course complements CSE143, which focuses more deeply on fundamental programming concepts and the internals of data structures. In contrast, CSE163 emphasizes the efficient use of those concepts for data programming.

In this course, students will learn:

1. More advanced programming concepts than in CSE142 or CSE160 including how to write bigger programs with multiple classes and modules.
1. How to work with different types of data: tabular, text, images, geo-spatial.
1. Ecosystem of data science tools including Jupyter Notebook and various data science libraries including scikit image, scikit learn, and Pandas data frames.
1. Basic concepts related to code complexity, efficiency of different types of data structures, and memory management.  This is class is designed as the second introductory programming course that focuses on writing programs that work with data. The prerequisites for the class require students having taken CSE 142 or CSE 160 and the class has been designed to be accessible to students from either of those backgrounds. Students that have taken 143 are welcome to take this class as it will serve as a complement to the material learned in 143 with only minor overlap.

Because this course will have students coming from many different class backgrounds, the first couple of weeks will be pretty different for students depending on what classes they have taken. Here is what we expect students to see in the first weeks based on their background:

- 142: The first two weeks might go pretty fast, but will be doable since you already know all the concepts (loops, conditionals, methods) and you are just learning all the new “words” in Python to use those concepts. This might require a little bit of extra practice early in the quarter so you are familiar with translating all the ideas you have learned in 142 to this new language. The first week has been designed to be a recap of all things 142 so you don’t also have to be learning a ton of new material while learning a new language in the first week.
 - 160: The first week will just be a bit of a review for you, but the class will start covering material you haven’t seen before starting in the second week.
- 143: You are in a similar boat as the 142 students, where you know a lot of the concepts but don’t know the Python language. You’ll probably see a few things that you saw in 143 in this class, but I think the new context of processing data in a new language will still keep it new, exciting, and challenging. 

CSE 163 Intermediate Data Programming

Computer Programming

Join (SQL)

Joins

3 courses cover this concept

CS 145 Data Management and Data Systems

Data 8: The Foundations of Data Science

CSE 163 Intermediate Data Programming