| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Buried in cloud files? We can help with Spring cleaning!

    Whether you use Dropbox, Drive, G-Suite, OneDrive, Gmail, Slack, Notion, or all of the above, Dokkio will organize your files for you. Try Dokkio (from the makers of PBworks) for free today.

  • Dokkio (from the makers of PBworks) was #2 on Product Hunt! Check out what people are saying by clicking here.

View
 

COP4709 Spring 2013 Assignments

Page history last edited by Dr. Ron Eaglin 9 years ago

  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

Comments (0)

You don't have permission to comment on this page.