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

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

COP4709 Course Lectures and Video

Page history last edited by Dr. Ron Eaglin 5 years, 8 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.