COP4709

Welcome to COP 4709!

Education ∀

COP 4813 Course Outcomes (what you will be able to do)

• CO1 – Students will be able to design and optimize a database.
• CO2 – Students will be able to create user interface to manage and update the database.
• CO3 – Students will be able manage transactions and concurrent database users.
• CO4 – Students will be able to use databases and database tools to assist with decision support.

Wiki Based Classes – All Students Read

The class management for these courses is wiki based. The classes are assignment based. I constantly add information to help with the assignments so even if you have started with an assignment it is worthwhile to look at it on a regular basis. You are graded on your ability to DO, not your ability to regurgitate information. I also do give credit to students who help me with more (useful) information for the class – this is called your contribution grade.

How the Class Works

This class is assignment based and you should start with the assignments. There are 2 components to the course; this wiki site and the Falcon Online site. The Falcon Online site is where you will turn in assignments and post to the bulletin boards and do all those Falcon Online type of items. This site is where all the course content resides.

Syllabus

The syllabus is at this link: COP4709 Syllabus

Step 1 – Start with the Assignments  START HERE

This class is all about what you can DO. You will be using SQL Server and real data sets to perform analyses on real sets of data. There are weekly assignments – some of which are extensive and some of which build on top of other assignments. You will need to have access to SQL Server with all the analysis tools. I highly recommend you have this on your own computer.

The assignments are at this link: COP4709 Assignments

Step 2 – Course Lectures and Video

The outline of the course, topics for the current semester (Spring 2018) and video lectures may be found at the link below. These may change from semester to semester. The lectures and assignments also refer to files, information and case studies which may be found in the second link below.

The lectures are at this link: COP4709 Course Lectures By Week

The case studies are at this link: Case Studies for COP4709

Click Here to Subscribe to Videos (On Youtube)

Step 3 – Get help

I am here to help. If you have questions please (1) post questions to the appropriate bulletin board in Falcon Online, (2) contact me by coming by my office (ATC 107B), e-mailing me (ronald.eaglin@daytonastate.edu), Skype (ron.eaglin), or phone (386 506-4176).

Site Map

• post page
• Site Map
• Syllabus
• Welcome
  • Assignments
    • Assignment 1
      • Data Dictionary – Class Advising System
      • Data Dictionary – Sports Players Statistics
      • Data Dictionary – Music Database
    • Assignment 10B – Data Analysis CIS4360
    • Assignment 14B – MongoDB
    • Assignment 9B – Pivot Table
    • Writing a Good Data Analysis Report
    • Assignment 2 – Import and Analyze Data
      • Assignment Supplemental – Importing Data Common Problems and Fixes
    • Assignment 3 – Stored Procedures
    • Assignment 4 – Stored Functions
    • Assignment 5 – Transactions
    • Assignment 6 – Cursors
      • Q and A – Trackling the Cumulative Debt Cursor Problem
    • Assignment 7 – Generating Reports
    • Assignment 8 – Lookup Tables
    • Assignment 9 – Aggregation
      • Spring 2013 COP4709 Assignment 9
    • Assignment 10
    • Assignment 11 – Full Text Indexing
    • Assignment 12 – Index Schemes
    • Assignment 13 – SQL Injection
    • Assignment 14 – AWS and DynamoDB
    • Assignment 15A – Hadoop
    • Assignment 15B – Retrospective Paper
  • Case Studies
    • Crime Database
    • Food Database
    • Medicare Database
      • Medicare Database Visual Studio Code Example
    • Music Database
    • Registration Database
    • Florida Housing Database
  • Lectures
    • Lecture – Complex Queries with Registration System
    • Lecture – Getting Started with MongoDB
    • Lecture – Passing Variables in Web Forms
    • Lecture – Using a DropdownList with a Database
    • Lectures – Views Example using Registration System
    • Week 1 Topic – Review of Database I
      • Lecture – Advanced Database Modeling Object Relationships
      • Lecture – Foreign Keys Example 1
      • Lecture – Foreign Keys Example 2
      • Lecture – Getting Started with SQL Server Management Studio
      • Lecture – Table Joins Part 1
    • Week 10 Topic – Security and SQL Injection
      • Lecture – Hardening the Database
      • Lecture – SQL Injection Attack
    • Week 11 Topic – Performance and Indexes
      • Lecture – Database Indexing
      • Lecture – Monitoring Database Performance
    • Week 12 Topic -Full Text Indexing
      • Lecture – Full Text Indexing
    • Week 13 Topic – Creating an Interface
      • Lecture – Adding Gridview to Input Screen 
      • Lecture – Calling Stored Procedures from Visual Studio 1
      • Lecture – Getting Started with Database Tools in Visual Studio
    • Week 14 Topic -OLAP Advanced Analysis
      • Lecture – Using Power Pivot
    • Week 15 Topic – NOSQL Databases (DynamoDB, MongoDB)
      • Lecture – Getting Started with NoSQL 
      • Lecture – Loading Data into DynamoDB 
      • Lecture – Query and Scan of DynamoDB
    • Week 2 Topic – Importing Data
      • Lecture – Importing Data Into SQL Server
      • Lecture – Preparing a Flat File for Database Import
    • Week 3 Topic – Stored Procedures Part 1
      • Lecture – Getting Started with Stored Procedures in SQL Server
    • Week 4 Topic – Function in Queries
      • Lecture – Getting Started with Stored Functions in SQL Server
    • Week 5 Topic – Managing Transactions
      • Lecture – Getting Started with Transactions in T-SQL
    • Week 6 Topic – Stored Procedures Part 2
      • Lecture – Advanced Stored Procedures
    • Week 7 Topic – Creating Reports
      • Lecture – Getting Started with Report Builder 3 
      • Lecture – Report Builder Part 2
      • Lecture – Report Builder Part 3
    • Week 8 Topic – Working with Data – Lookup Tables
      • Lecture – Lookup Tables Part 1
    • Week 9 Topic – Data Analysis – Aggregation
      • Lecture – Advanced Query – WITH Clause
      • Lecture – Complex queries with aggregation
      • Lecture – Database and Aggregations