Search

You can find the results of your search below.

Matching pagenames:

Fulltext results:

sched
15 Hits, Last modified:
====== Weekly Schedule ====== * Week 1: Aug 30, First class * Week 2: Sep 6, Labor Day (no class) * [[week3|Week 3]]: Sep 13, first queries of the CAP database * [[week4|Week 4]]: Sep 20, nested queries * [
week3
3 Hits, Last modified:
====== Week 3 ====== Welcome back!! \\ \\ Querying the CAP Database on our postgres server: * //with... er in class) \\ \\ **Reading assignment for next week:** \\ * zyBook Chapter 4: Structured Query Lan... activities (active reading) \\ \\ **HW for next week:** \\ * Nested queries * Starter script: {{
week4
3 Hits, Last modified:
====== Week 4 ====== ===== Nested Queries ===== Querying the CAP Database ((with thanks to Alan Labous... utions to queries **Reading assignment for next week:** \\ * zyBook Chapter 3: Database Design **HW for next week:** \\ * Querying the CAP database using joins
week5
3 Hits, Last modified:
====== Week 5 ====== ===== Join Queries ===== {{:courses:cs311-2021:joy-of-joins.png?nolink|}} Queryi... s to queries **Reading assignment for this/next week:** \\ * zyBook Chapter 3: Database Design **HW for next week:** \\ * Brainstorm final project ideas * Wha
resources
2 Hits, Last modified:
* [[https://towardsdatascience.com/a-complete-15-week-curriculum-to-master-sql-for-data-science-999e690033e4|A Complete 15 Week Curriculum to Master SQL for Data Science]] *
week6
2 Hits, Last modified:
====== Week 6 ====== ~~NOTOC~~ ===== Data Normalization ===== From the 5 Rules of Data Normalization ... n: at the team level, predictions ===== For next week ===== * what database project would you like t
top
1 Hits, Last modified:
nderstanding. Moreover, since we only meet once a week, missing a class means going two weeks without at
week10
1 Hits, Last modified:
====== Week 10 ====== ===== Importing Data into Tables from CSV files ===== Here's a reference on how