WE ARE HERE(follow link)

Week

Date

SU #

Study Unit and Content

General Information   Textbook Slides etc.

Comments

Intro & Semester 1 Recap - Databases

PC: First Class: Monday 25 July @ 11:00 (E6-B15) 

VC and Distance: First Class: Online Class: Wednesday 27 July @ 8:00:

Slides and Class Recording under VC and Distance Students

Transaction Management and Concurrency Control (1)

Chapter 10 (p483-506)

Study Outcomes

Textbook Slides: https://efundi.nwu.ac.za/access/content/group/1cb76596-f887-4012-959a-57ed0848c189/Textbook%20slides-1/CMPG321_2021_SU1-CH10.pptx

Google Drive Slides: Slides Available on Google Drive

Additional:

1) VC and Distance: Zoom class @ 7:30 (done) - next class is Friday @ 9:30 in the Walvis (Wale) lab.

PC: Class: Monday 01 August @ 11:00 (E6-B15) 

Transaction Management and Concurrency Control (2)

Chapter 10 (p483-506)

Study Outcomes

Textbook Slides: Please see week 2

Additional:

VC and Distance: Zoom class: Wednesday: 7:30  - done

PC: Honours Information session - Wednesday 10 August @ 09:30 (E6-B15) -done

VC & PC: Class: Friday 12 August @ 09:30   - done

SQL Fundamentals (1&2)

Chapter 7 (244-318)

Study Outcomes

Textbook slides: SQL Chapter 7

Additional:

PC: Class: Monday 15 August @ 11:00 (B6-B15) 

Oracle SQL Testing Environment:  Environment Link  /  YouTube Link

---000---

VC & Distance:  

1) Please see VC and Distance students tab for class recording and slides used.

2) Please note : No physical class -  Friday Class (19 August ) I will be available via Zoom: Done

To Do:

1) Quiz 1

2) Project Deliverable 1

3) Homework 1 is out (Please see under Test and Quizzes)

SQL Fundamentals (2&3)

Chapter 8 (359-419)

Study Outcomes

Textbook Slides: Please see class specific pages

Additional:

PC: Monday 22 August @ 11:00 - Online class (See Potch tab for Zoom link) - Done.
PC: Friday 26 August @ 09:30 (F13-G18) - Non-compulsory contact class.

VC: Online class - done.-->For Friday's non-compulsory physical class:

The question to ponder about: What to do with empty fields in a dataset? 

Some resources found on the internet that may help to understand SQL better:

1) Learn SQL

2) SQL Optimization

Distributed Database Systems (1) 

Chapter 12 (p.553-583)

Study Outcomes

Textbook Slides: Chapter 12: DDBMS

Additional:

PC: Class: Monday 29 August @ 11:00 (E6-B15)  - Done
PC: Class: Friday 02 September @ 09:30 (F13-G18) [Casual Day]

VC & Distance:

Wednesday @ 7:30:  Done 

Friday: No physical class - zoom link open for any queries, questions, and/or discussions.

Distributed Database Systems (2)

Chapter 12 (p.553-583)

Study Outcomes

Textbook Slides

Additional:

PC: Class: Monday 05 September @ 11:00 (E6-B15) 

VC & Distance: Class Wednesday 7 September @ 7:30 Online: 

Please remember to do the student T&L Experience survey  -

 - Links for VC and Distance posted on Week 7

Big Data and NoSQL

Chapter 14 (p.657-686)

Study Outcomes

Textbook Slides: Bid Data & NoSQL

Additional:

PC: Class: Monday 12 September @ 11:00 (E6-B15) 

PC: Online: Friday 16 September @ 09:30 - Online (See Potch tab for Zoom link)

VC & Distance: Online: Friday starting @ 9:30: https://zoom.us/j/84393606

BI and Data Warehousing (1)

Chapter 13 (589-644)

Study Outcomes

Textbook Slides:Data Warehousing and BI

Additional:

PC: Class: Monday 19 September @ 11:00 (E6-B15) - done

PC: 22 September @ 11:15 (E9-G03) - Guest lecture and recruitment - Instasense Company

PC: Friday 23 September - No Class

VC & Distance: Wednesday 21 Sept @ 7:30: done

Semester Test

Additional:

PC: Class: Monday 26 September @ 11:00 (E6-B15) - Non-compulsory

VC & Distance: Online Class @ 7:30: class will focus on semester test - done

A rough guide (and video) about the semester test: https://youtu.be/QU5cvjncWg4

SEMESTER TEST: Chapters 10, 12, 14 & SQL (Ch 7 & 8)

Who? PC; VC and Distance

When?  Friday 30 September 14:00-21:00 (75 minutes--> 60 Marks)

Where and How? ONLINE

> > Tests & Quizzes - Semestertest_2022 < <

RESES

RESES

DB Performance Tuning (1 & 2)

Chapter 11 (p515-538)

Study Outcomes

Textbook Slides: Chapter 11_Database Performance Tuning

Additional:

PC: Monday 17 October - No Class
PC: Class: Friday 21 October @ 09:30 (F13-G18)

VC & Distance: Online:

Wednesday starting @ 7:30: https://zoom.us/j/84393606 -

Friday - No formal class - will be in my office (and online) for any assessment and marking queries

DB Admin & Security

Chapter 16 (p.734-776)

Study Outcomes

Textbook Slides

Additional:

PC: Class: Monday 24 October @ 11:00 (E6-B15)
PC: Friday 28 October @ 09:30 - Available in my office for any queries, questions, and/or discussions.

VC & Distance: Online:

Wednesday: Youtube class: https://youtu.be/MRHTxjj4FlA

Friday class: Loadshedding edition,  starting @ 9:30: https://zoom.us/j/84393606 (normal class time)

Project and Revision

We are here...can you believe it!

PC: Class: Monday 31 October @ 11:00 (E6-B15) - Informal / optional

VC & Distance: Last Class! :-( - will talk about exam; exam papers and answer any questions you may have - https://youtu.be/BNawqGqahM4