| 
  • 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 2015 Assignments

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

COP4709 Spring 2015 Assignments

 

No surprise - this class has weekly assignments. Each assignment is designed to build you abilities as a database administrator and your ability to manipulate, query, and analyze data. Along the way we will learn key concepts of databases and database programming.

 

Assignment
Description
Due Date
COP4709 Assignment 1 - Database Review  Getting SQL Server up and running and building a database in the environment.  1/26/15
COP4709 Assignment 2A - Importing Data  You will start by importing and analyzing data  2/2/15
COP4709 Assignment 3A - Stored Procedures  You will start writing stored  procedures in this assignment 2/9/15
COP4709 Assignment 4A - Stored Functions You will now write a stored function that returns a table and another returning a scalar  2/16/15
COP4709 Assignment 5A - Transactions
You will create a transaction stored procedure and discuss how it meets the requirements of transaction management
2/23/15
COP4709 Assignment 6A - Cursors
Learn to use cursors in stored procedures
3/2/15
COP4709A Assignment 7A - Reports  Learn to use Report Writer to create a report  3/9/15
COP4709 Assignment 8A - Lookup Tables  A common database practice is coded fields that rely on lookup tables  3/23/15 
  At this stage you now have all the basic tools to do pretty much everything with a database. We did not cover triggers (which may be useful) but a little bit of looking at documentation you will be quite capable of using them if needed. I avoid them as they often have side effects.  The next set of assignments will have you solving some relatively complex data questions. We will be using real data. In each case you will need to get data into your system, manipulate it, format queries, and provide a report of results. Where most of the first half assignments were pretty straightforward - these are much more complex.
 
COP4709 Assignment 9A - Food Analysis
You will be using a nutrition database to determine health effects of food
3/30/15
COP4709 Assignment 10A - Business Reports Using real grades and some analysis you will generate a business report to a set of high level questions. 4/6/15
COP4709 Assignment 11A - Full text indexing
Full text indexing opens up an entirely new world of querying
4/13/15
COP4709 Assignment 12A - Performance of queries
Learn how to use indexes and increase system performance
4/20/15
COP4709 Assignment 13A - Security
Learn about SQL Injection, security, and how to harden a database
4/27/15
COP4709 Assignment 14A - DynamoDB
Create a database using Amazon Web Services
5/4/15

COP4709 Assignment 15A - Hadoop

 

COP4709 Assignment 15B - Review Paper

You can either complete 15A or 15B (Hadoop homework does have a charge associated with creating the necessary VM)

 

15A - Create a Hadoop Instance using Azure Web Services.

 

 

15B - Review Paper

 

 

Past Assignments

COP 4709 Spring 2012 Assignments

COP4709 Spring 2013 Assignments

COP4709 Spring 2014 Assignments

Comments (0)

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