These are weekly assignments. You must complete all assignment prior to the end of the semester - It is important to stay on schedule - however most assignments will be due 1 week after the data of the materials being due. There is one assignment per week.
You must have access to SQL Server and SQL Server management studio to be able to complete these assignments. A number of video's are available to help you get started.
| Week |
Information on Assignment |
Topic |
Instructor and Key Information (some solutions posted to BB instead) |
|
Week 1 |
Topic - Review of Database I | |
|
|
Week 2 |
Topic - Importing Data | ||
| Week 3 |
Topic - Stored Procedures Part 1 |
|
|
| Week 4 |
Topic - Function in Queries |
Spring 2013 COP4709 Assignment 4 Solution |
|
|
Week 5 |
Topic - Managing Transactions | ||
| Week 6 |
Topic - Stored Procedures Part 2 |
Spring 2013 COP4709 Assignment 6 Solution |
|
| Week 7 |
Topic - Creating Reports |
||
| Week 8 |
Topic - Working with Data - Lookup Tables |
||
| Week 9 |
Topic - Data Analysis - Aggregation | ||
| Week 10 |
Topic - Security and SQL Injection | |
|
| Week 11 | Topic - Performance and Indexes | ||
| Week 12 | Topic - Full Text Indexing | ||
| Week 13 | Topic - Creating an Interface | ||
| Week 14 | Topic - Complex Queries | |
|
| Week 15 | Topic - NOSQL using DynamoDB |