| Date | Lecture title | Additional material | Assigned reading from course references | Deadlines |
|---|---|---|---|---|
| Lecture 0 | Introduction to QTM 250 | Module A Preface, Module 0 Slides |
||
| Lecture 1 | Prerequisites for cloud | Computer Literacy Codelab | ||
| Lecture 2 | Spreadsheet Basics | Introduction To Visualizations, Sheets Basics |
||
| Lecture 3 | So, What’s the Cloud Anyway? | Module 1 slides | ||
| Lecture 4 | Filtering and grouping data | Basic Descriptive Statistics, Filtering and Grouping |
Test yourself quiz 1 | |
| Lecture 5 | Google Cloud Platform (GCP) | Module 2 slides | ||
| Lecture 6 | Pivot tables and joining data | Module B Preface, Importing and Exporting data, Scatter Plots and Correlation, Regression, Manipulating Data |
||
| Lecture 7 | Compute options in Google Cloud | Module 3 slides | HW 1 | |
| Lecture 8 | Introduction to Biq Query | Module C Preface, Introduction |
Test yourself quiz 2 | |
| Lecture 9 | Storage in the Google cloud | Module 4 slides | ||
| Lecture 10 | SQL Part I | Selecting, Filtering |
||
| Lecture 11 | There’s an API for That! | Module 5 slides | ||
| Lecture 12 | SQL Part II | Sorting, Aggregating |
Test yourself quiz 3 | |
| Lecture 13 | You Can’t Secure the Cloud, Right? | Module 6 slides | ||
| Lecture 14 | SQL Part III | Ifs and Cases Joining |
HW 2 | |
| Lecture 15 | Introduction to APIs via curl and jq |
Data on bestselling books via the Times API | ||
| Lecture 16 | It Helps to Network | Module 7 slides | Test yourself quiz 4 | |
| Lecture 17 | Datastudio and dashboarding | |||
| Lecture 18 | Cloud automation and management tools | Module 8 slides | ||
| Lecture 19 | API requests in Python | Requests and Dictionaries | ||
| Lecture 20 | Managed big data services in the cloud | Module 9 slides | Test yourself quiz 5 | |
| Lecture 21 | Machine Learning APIs | Using Machine Learning APIs | HW 3 | |
| Lecture 22 | Introduction to machine learning in the cloud | Module 10 slides | ||
| Lecture 23 | Strings and Lists in Python | Strings and Lists | ||
| Lecture 24 | Advanced visualization tools | Examples of Bokeh and Datashader | Test yourself quiz 6 | |
| Lecture 25 | Statistics in Python | Regression example | ||
| Lecture 26 | Course assessment and Google Cloud skill badges | HW 4 |