COP4709 Spring 2013 Assignments

 

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	Spring 2013 COP4709 Assignment 1	Topic - Review of Database I
Week 2	Spring 2013 COP4709 Assignment 2	Topic - Importing Data
Week 3	Spring 2013 COP4709 Assignment 3	Topic - Stored Procedures Part 1
Week 4	Spring 2013 COP4709 Assignment 4	Topic - Function in Queries	Spring 2013 COP4709 Assignment 4 Solution
Week 5	Spring 2013 COP4709 Assignment 5	Topic - Managing Transactions
Week 6	Spring 2013 COP4709 Assignment 6	Topic - Stored Procedures Part 2	Spring 2013 COP4709 Assignment 6 Solution
Week 7	Spring 2013 COP4709 Assignment 7	Topic - Creating Reports
Week 8	Spring 2103 COP4709 Assignment 8	Topic - Working with Data - Lookup Tables
Week 9	Spring 2013 COP4709 Assignment 9	Topic - Data Analysis - Aggregation
Week 10	Spring 2013 COP4709 Assignment 10	Topic - Security and SQL Injection
Week 11	Spring 2013 COP4709 Assignment 11	Topic - Performance and Indexes
Week 12	Spring 2013 COP4709 Assignment 12	Topic - Full Text Indexing
Week 13	Spring 2013 COP4709 Assignment 13	Topic - Creating an Interface
Week 14	Spring 2013 COP4709 Assignment 14	Topic - Complex Queries	Spring 2013 COP4709 Assignment 14 Solution
Week 15	Spring 2013 COP4709 Assignment 15	Topic - NOSQL using DynamoDB

 

 

 

Previous Years Assignments

 

COP 4709 Spring 2012 Assignments