| Nicole Cook | IT 125 -- Section 32406 | |
|---|---|---|
| Fall 2024 | Course Syllabus |
Please see my schedule here: Nicole's Class/Student Support Schedule |
| email: nicole.cook@seattlecolleges.edu |
Online class with Video Link
Video Lecture / Lab Tuesday 6:00 pm - 8:40 pm Lab Support Tuesday, Wednesday and Thursday (see my schedule, times vary by day) |
Phone: Please use email |
| IT 125 5.0 Units - Introduction To SQL Using MySQL | |||
|---|---|---|---|
|
Provides instruction in the techniques for querying, modifying, creating
and deleting databases and database components using MySQL and MySQL
Workbench. While this course focuses on MySQL, the techniques can also
be used in other databases like PostgreSQL, Oracle or Microsoft SQL
Server. This course requires hands-on work by the student. While it is helpful if a student has seen or used a database tool in the past, this course is taught with no expectation of prior database knowledge. |
|||
| Section | Lecture Time & Location | Student Support Hours Time & Location | Lab Time & Location |
|
Sect# 32406
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
(9/23 - 9/27) |
Course Overview; Related Supporting Topics | Chapter 1 |
Week 1 Quiz
ends 10/8, 11:59 pm |
Lab 1
MySQL and MySQL Workbench Install |
|
Week 2
(9/30 - 10/4) |
Basic Scripting; MySQL and MySQL Workbench | Chapter 2 |
Week 2 Quiz
ends 10/15, 11:59 pm |
Lab 2
Create A MySQL Table |
|
Week 3
(10/7 - 10/11) |
Single Table Intro to Basic SQL Select | Chapter 3 |
Week 3 Quiz
ends 10/22, 11:59 pm |
Lab 3
Creating Simple and Advanced Queries |
|
Week 4
(10/14 - 10/18) |
Joins and Multi-table SQL Select Queries | Chapter 4 |
Week 4 Quiz
ends 10/29, 11:59 pm |
Lab 4
Creating Simple and Advanced Joins |
|
Week 5
(10/21 - 10/25) |
Modification of Existing Databases | Chapters 5 & 8 |
Week 5 Quiz
ends 11/5, 11:59 pm |
Lab 5
Modifying Tables and Cleanup |
|
Week 6
(10/28 - 11/1) |
Building Your Own Database -- Design | Chapters 10 & 11 |
Week 6 Quiz
ends 11/12, 11:59 pm |
Lab 6
Creating an ERD |
|
Week 7
(11/4 - 11/8) |
More Complex Queries | Chapters 6 & 7 |
Week 7 Quiz
ends 11/19, 11:59 pm |
Lab 7
Summary Queries, Subqueries and CTE |
|
Week 8
(11/11 - 11/15) |
Functions and Views | Chapters 9 & 12 |
Week 8 Quiz
ends 11/26, 11:59 pm |
Lab 8
Database Portfolio Completion |
|
Week 9
(11/18 - 11/22) |
Stored Programs | Chapters 13 & 15 |
Week 9 Quiz
ends 12/6, 5:00 pm pm |
|
|
Week 10
(11/25 - 11/29) |
Security and Administration | Chapters 17 & 18 |
Week 10 Quiz
ends 12/6, 5:00 pm |
|
|
Week 11
(12/2 - 12/6) |
Review and Presentations | None | None | None |
|
Week 12
(12/9 - 12/13) |
Final Exam | None | None | None |
| Note: 5:00 pm on Friday, December 6th is the deadline for submitting all homework and any online quizzes. No other late submissions will be accepted!! | ||||
| Final Exam Info: | Monday - Wednesday, December 9th to 1th -- Available online at any time over this period | |||
|
TEXTBOOK - |
| Murach's MySQL 3rd Edition | |
| By Joel Murach | |
|
ISBN-13: 978-1943872367 -- and -- ISBN-10: 1943872368 (either one works) |
| QUIZ INFO: | |
|---|---|
The normal process for taking quizzes is like this:
|
My way for taking quizzes is like this:
|
|
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 !! |
|
| GRADING: | ||
|---|---|---|
| Online Quizzes | 20 percent of your grade | 5 p.m. Friday, March 6th is the deadline for submitting any active quizzes |
| Lab Assignments | 60 percent of your grade | 5 p.m. Friday, March 6th is the deadline for submitting all labs |
| Final Exam | 20 percent of your grade | Monday, March 9th to Wednesday March 13th -- Available online during this period |