|
EXTRA CREDIT: Test of Everyday Reasoning with Numeracy (TER-N) 20 Points |
- |
|
|
| Week 15: IT Specialist 201 Database certification exam (4/26-5/5) |
IT Specialist Database Exam |
- |
|
|
|
| Week 14(4/24-5/7): Project Showcase Peer Review, GitHub and ePortfolio |
Commit final project to GitHub and provide a link to your repository here! |
- |
|
|
|
Dropbox for e-Portfolio link |
- |
|
|
|
| Week 13(4/17-4/24) Chapter 16 Transaction Processing, Chapter 17 Database Security and Term Project Showcase |
Register at Certiport for your exam (www.certiport.com) |
- |
|
|
|
EXTRA CREDIT: CIT Industry Night Out - 20 Fathoms (4/21) |
- |
|
|
|
Dropbox for Chapter 16 Textbook Assignment |
- |
|
|
|
Dropbox for Chapter 17 Textbook Assignment |
- |
|
|
|
| Week 12 (4/10-4/17): Chapter 15 - Coding Procedures, Functions and Triggers |
Dropbox for Chapter 15 Textbook Assignment |
- |
|
|
|
Dropbox for Milestone #3 Assignment Scripts |
- |
|
|
|
| Week 11 (4/3-4/10): Chapter 14 - Coding Scripts |
Dropbox for Chapter 14 Textbook Assignment |
- |
|
|
|
Dropbox for Chapter 14 Lab Assignment Scripts |
- |
|
|
|
EXTRA CREDIT: CIT Industry Night Out - Disability Networks (4/5) |
- |
|
|
|
EXTRA CREDIT: CIT Fun Night (4/8) |
- |
|
|
|
| Week 10 (3/20-3/27): Chapter 13 - Views and Chapter 9 Functions |
Dropbox for Chapter 9 Textbook Assignment |
- |
|
|
|
Dropbox for Chapter 9 Lab Assignment Scripts |
- |
|
|
|
Dropbox for Chapter 13 Textbook Assignment |
- |
|
|
|
Dropbox for Final Project Milestone #3 View Scripts |
- |
|
|
|
| Week 9 (3/13-3/20): Chapter 6 Subqueries |
Dropbox for Chapter 6 Textbook Assignment |
- |
|
|
|
Dropbox for Chapter 6 Lab Assignment |
- |
|
|
|
| Week 8(3/6-3/13): Chapter 5: Summary Queries |
Dropbox for Chapter 5 Textbook Assignment |
- |
|
|
|
Dropbox for Final Project Milestone #3 Assignment - Creating Aggregate (Summary) Queries |
- |
|
|
|
Dropbox for SQL Server Extensions (Extra Credit Assignment) |
- |
|
|
|
| Week 7 (2/27-3/6): Chapter 7 - Inserting, Updating and Deleting Data and Term Project Milestone #2 |
Dropbox for Chapter 7 Textbook Assignment |
- |
|
|
|
Dropbox for Final Project Assignment - Adding Data to Tables |
- |
|
|
|
| Week 6 (2/20-2/27): Chapter 11 - Creating tables using SQL and Chapter 12: Creating tables using SSMS |
Dropbox for Chapter 11 Textbook Assignment |
- |
|
|
|
Dropbox for Chapter 12 Textbook Assignment |
- |
|
|
|
Dropbox for Final Project Milestone #2 |
- |
|
|
|
| Week 5(2/13-2/20) Database Design Lab for Term Project Milestone: Database Design |
Dropbox for Final Project Milestone #1 |
- |
|
|
|
| Week 4 (2/6-2/13): Chapter 8 - Data Types and Chapter 10: Database Design |
Dropbox for Chapter 10 Textbook Assignment |
- |
|
|
|
| Week 3 (1/30-2/6): Chapter 4-Retrieving Data from Multiple Tables |
Dropbox for Chapter 4 Textbook Assignment |
- |
|
|
|
Dropbox for Chapter 4 Lab Assignment |
- |
|
|
|
| Week 2 (1/23-1/30): Chapter 2- Using SSMS & Chapter 3 - Retrieving data from a single table |
Dropbox for Chapter 2 textbook assignment |
- |
|
|
|
Dropbox for Chapter 3 Textbook Assignment |
- |
|
|
