Nicole Cook AD 350 -- Section 36555 Office: IB 2405 A
Winter 2024 Course Syllabus Please see my schedule here:
Nicole's Class/Office Schedule
email: nicole.cook@seattlecolleges.edu This is usually an On-Campus / In-Person class, however, due to the current circumstances this semester, it is an online class with Video Link

Video Lecture / Lab Tuesday 6:00 pm - 8:40 pm

Lab Support Tuesday, Wednesday and Thursday (see my schedule) 		Phone: Please use email

horizontal bar horizontal bar horizontal bar

AD 350 5.0 Units - Database Technology
Covers intermediate programming in an SQL relational database. Provides an introduction to non-relational databases as used in Cloud Computing and Big Data. The RDMS topics include views, models, stored procedures, triggers, indexing, JOINs and abstraction techniques, query construct efficiency.
Introduction to NoSQL databases: uses, terminology, indexing, storage, compute consumption, compression, and reliability.
Prereq: Acceptance into the Application Development BAS.
You will use computers to complete assignments for this class.
Section Lecture Time & Location Office Hours Time & Location Lab Time & Location
Sect# 36555
N Cook 		Tuesday 6:00 pm - 8:40 pm See My Schedule Part of Lecture


Day Topic Reading Assignment Online Quiz
Need to know INFO on quizzes 		Lab Assignment
Week 1
(1/1 - 1/5) 		The History of Database Technology Reading Assignment 1 Week 1 Quiz
ends 1/16, 11:59 pm 		Lab 1
MySQL and MySQL Workbench Install
Week 2
(1/8 - 1/12) 		Remembering your SQL Class Reading Assignment 2 Week 2 Quiz
ends 1/23, 11:59 pm 		Lab 2
Design a Database
(Part 1 of 6)
Week 3
(1/15 - 1/19) 		Beyond Your SQL Class Reading Assignment 3 Week 3 Quiz
ends 1/30, 11:59 pm 		Lab 3
Cookbot
Week 4
(1/22 - 1/26) 		SQL Stored Programs Reading Assignment 4 Week 4 Quiz
ends 2/6, 11:59 pm 		Lab 4
Write a Stored Program
(Part 2 of 6)
Week 5
(1/29 - 2/2) 		SQL Issues and Exceptions Reading Assignment 5 Week 5 Quiz
ends 2/13, 11:59 pm 		Lab 5
Lookup Tables
(Part 3 of 6)
Week 6
(2/5 - 2/9) 		Big Data - Hadoop Reading Assignment 6 Week 6 Quiz
ends 2/20, 11:59 pm 		Lab 6
Hadoop NoSQL
(Part 4 of 6)
Week 7
(2/12 - 2/16) 		Sharding & NoSQL Reading Assignment 7 Week 7 Quiz
ends 2/27, 11:59 pm 		Lab 7
Amazon NoSQL
(Part 5 of 6) Deja-Vu
Week 8
(2/19 - 2/23) 		Document Databases Reading Assignment 8 Week 8 Quiz
ends 3/5, 11:59 pm 		Lab 8
JSON / MondoDB
(Part 6 of 6)
Week 9
(2/26 - 3/1) 		Data Models Part 1 Reading Assignment 9 Week 9 Quiz
ends 3/12, 5:00 pm 		Labs 9 & 10
The Big Lab --
Building A Database
Week 10
(3/4 - 3/8) 		Data Models Part 2 NONE NONE
Week 11
(3/11 - 3/15) 		The Future and Presentations NONE NONE
Week 12
(3/18 - 3/22) 		Final Exam NONE NONE NONE
Note: 5:00 pm on Friday, March 15th is the deadline for submitting all homework and any active online quizzes. No other late submissions will be accepted!!
Final Exam Info: Monday - Wednesday, March 18th to 20th -- Available online at any time over this period

TEXTBOOKS --
Relational Database Practices Next Generation Databases
By Malcolm Hamer  
ISBN: 978-0-9989-6460-7

Available for as little as $12 		ISBN: 978-1-4842-1330-8

Available for as little as $25
It is my intent to teach this without a hard textbook requirement to make it available to everyone. Having said that, you will have an advantage if you have a copy of the textbooks. I tried to select texts that are relatively inexpensive and easy to acquire.
vine line
QUIZ INFO:
The normal process for taking quizzes is like this:
  • the student shows up to class
  • the instructor gives the quiz
  • the student has one chance to take the quiz
  • there is a 15-20 minute time limit
  • there is no use of the textbook / student notes
 My way for taking quizzes is like this:
  • give a 2 week time frame to get them done
  • you may retake each quiz up to 3 times for a better grade if the grade you receive the first or second time is not your best
  • you have a 2-hour time limit each time you take the quiz
  • you may use your textbook / notes
I can either use the normal process of taking a quiz, or use my way. If using my way, you will need to remember to take the quizzes within the 2 week time frame.
Quizzes CANNOT be re-activated so please DON'T EVEN ASK !!
vine line
GRADING:
Online Quizzes 20 percent of your grade 5 p.m. Friday, March 15th is the deadline for submitting the last 2 quizzes
Not all quizzes are active
Lab Assignments 60 percent of your grade 5 p.m. Friday, March 15th is the deadline for submitting all labs
Final Exam 20 percent of your grade 6:00 p.m. March 18 - 20 will be the online final exam in Canvas

(this will be explained during the first class)
Return to AD 350 Class Links