• 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.


COP4709 Course Lectures and Video

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

COP4709 Applied Database II - Course Lectures and Video



 Topic - Review of Database I


 Topic - Importing Data


Topic - Stored Procedures


 Topic - Function in Queries


 Topic - Managing Transactions


 Topic - Creating Reports


 Topic - Working with Data - Lookup Tables


 Topic - Data Analysis - Aggregation


 Topic - Security and SQL Injection


 Topic - Performance and Indexes


 Topic - Full Text Indexing


 Topic - Creating an Interface


Topic - NOSQL using DynamoDB


Database Fundamentals


Lecture - Getting Started with SQL Server Management Studio  - This is an introduction video that gets you started working with Visual Studio.


Foreign Keys Example 1 - Creating Foreign Keys. An example video of the correct use of foreign keys and normalizing table design.


Foreign Keys Example 2 - Inserting and Deleting Records - An example of how to use foreign keys practically when inserting and deleting records that contain foreign key relationships.


Views Example using Registration System - An example of creating a complex view joining 5 tables for the Case Study - Registration Database .


Complex Queries with Registration System - A video and write-up of performing complex queries with the Case Study - Registration Database .


Getting Started with Report Builder 3 -A video showing the creation of a simple report with report Builder.



Programming Examples


Getting Started with Database Tools in Visual Studio - This demonstrates how to connect to a database and create functional pages without writing code, simply using the Visual Studio Data Aware Objects.



Medicare Database Visual Studio Code Example - This has a video and corresponding code. It demonstrates how to write database objects in C# code using the Medicaid Satisfaction database.


ADO.NET Tutorial - This is an external tutorial that covers all the ADO.NET objects. Very well written and easy to follow.


Calling Stored Procedures from Visual Studio 1 - Demonstrates using Visual Studio Objects to call a stored procedure from an interface.


Adding Gridview to Input Screen - Uses example for calling stored procedure and shows how to add a Gridview that updates every time data is entered.


Passing Variables in Web Forms - Demonstrates 3 methods of passing variables in Web Forms, Session, HTTP GET QueryString, and HTTP Post. All three using minimal code.


Using a DropdownList with a Database - This uses the registration system example. We bind a drop down list to a database view, and use return values to call a stored procedure.


Database Analysis


Using Power Pivot - Really cool example of using PowerPivot with Excel 2010 to analyze the foreign aid database.


Case Studies


Continuing Your Database Education


This course is really designed to get you over the hump of the major learning curve of using databases in a real organizational setting. Of course this field never ends and I strongly recommend continuing with learning everything you can. Here are links to make that possible.


Microsoft Virtual Academy - http://www.microsoftvirtualacademy.com/ - Every technical topic you can imagine with great materials and training.


Coursera - https://www.coursera.org/ - Free and a personal favorite of mine. Courses are well done and cover a huge number of topics.


EdX - https://www.edx.org/ - From Harvard to ASU, one of the major players in online education with great courses


Udacity - https://www.udacity.com/ - Offers what they call Nanodegrees, specialize and master individual fields









Comments (0)

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