CSE 344 - Calendar

CSE 344

Calendar

Date

Topic/Slides/Materials

Homework/Quiz

Week 1

Mon Jan 4

Introduction (2.1-2.3) slides demo video

Wed Jan 6

SQL Basics and Joins (6.1-6.2) slides video

Thu Jan 7

Section - SQLite slides

Fri Jan 8

SQL Aggregates (6.1-6.2) slides video

Week 2

Mon Jan 11

SQL Agg. + Joins (6.1-6.2) slides video

HW1 - SQLite

Wed Jan 13

SQL Subqueries (6.3) slides video

Thu Jan 14

Section - SQL Practice slides worksheet solutions

Fri Jan 15

Relational Algebra (2.4, 5.1-5.2) slides video

Quiz 1 (Basic SQL)

Week 3

Mon Jan 18

Martin Luther King Jr. Day

Wed Jan 20

RA cont. (2.4, 5.1-5.2) slides video

Thu Jan 21

Section - Relational Algebra slides worksheet solutions

HW2 - SQL Practice

Fri Jan 22

ER Diagrams (4.1-4.6) slides video

Week 4

Mon Jan 25

Design Theory (3.1-3.5) slides video

Wed Jan 27

Serializability (18.1-18.2) slides video

Thu Jan 28

Section - Design Theory AA AB AC slides worksheet solutions

Fri Jan 29

Locks (18.3-18.4) slides video

Quiz 2 (Adv. SQL & RA)

Week 5

Mon Feb 1

Isolation Levels (18.4.1-3) slides video

HW3 - Azure SQL (extended) (NO LATE DAYS)

Wed Feb 3

Cost Estimation (8.3-8.4) slides video

Thu Feb 4

Section - Transactions AE AA AB slides supplement worksheet solutions

Fri Feb 5

Tuning and Indexing (15.6) slides video

HW4 - Design Practice

Week 6

Mon Feb 8

Tuning and Indexing cont. (15.6) slides video

Wed Feb 10

Parallel Processing (20.1) slides video

Thu Feb 11

Section - Performance AA AB AC slides supplement worksheet solutions

HW5 - Java App milestone (NO LATE DAYS)

Fri Feb 12

MapReduce and Spark (20.2) slides video

Quiz 3 (Design, Transactions, and Perf.)

Week 7

Mon Feb 15

Presidents' Day

Wed Feb 17

NoSQL Fundamentals slides video

Thu Feb 18

Section - Parallel Processing AA AB AC slides worksheet solutions

HW5 - Java App

Fri Feb 19

Semi-Structured Data (guest lecture Andrew Guterman) slides video

Week 8

Mon Feb 22

SQL++ slides video

Wed Feb 24

SQL++ cont. slides video

Thu Feb 25

Section - SQL++ AA AB AC slides worksheet solutions

HW6 - Spark

Fri Feb 26

Stream Fundamentals slides video

Week 9

Mon Mar 1

Stream Timing slides video

Wed Mar 3

Stream Watermarks slides video

Thu Mar 4

Section - Streaming AA AC

HW7 - AsterixDB

Fri Mar 5

Stream Programming slides video

Quiz 4 (Parallel Proc. & SQL++)

Week 10

Mon Mar 8

Class Canceled (OH still available)

Wed Mar 10

Data Governance streams governance video

Thu Mar 11

Section - Office Hours

HW8 - Streams

Fri Mar 12

Database Management slides video

Quiz 5 (Streams)

Finals Week

Happy Spring Break!

Page updated

Report abuse