| 
  • 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 Course Lectures By Week

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

 

COP4709 Course Lectures By Week

 

Each week be sure to read the reading section and also watch the lectures, you are responsible for all materials in the required articles and the lectures and they will make the assignments much easier. When asking questions about your assignments I will almost always ask "have you read the reading and watched the lecture?"

 

The basic concepts you should know prior to this class (from pre-requisites) are well covered in Relational Databases Programming Concepts - http://www.agiledata.org/essays/relationalDatabases.html 


 

Week 1 - Topic - Review of Database I

 

Week 2 - Topic - Importing Data

 

Week 3 - Topic - Stored Procedures Part 1

 

Week 4 - Topic - Function in Queries

 

Week 5 - Topic - Managing Transactions

 

Week 6 - Topic - Stored Procedures Part 2

 

Week 7 - Topic - Creating Reports

 

Week 8 - Topic - Working with Data - Lookup Tables

 

Week 9 - Topic - Data Analysis - Aggregation

 

Week 10 - Topic - Security and SQL Injection

 

Week 11 - Topic - Performance and Indexes

 

Week 12 - Topic - Full Text Indexing

 

Week 13 -Topic - Creating an Interface

 

Week 14 - Topic -OLAP Advanced Analysis

 

Week 15 - Topic - NOSQL using DynamoDB

 


 

Other Topics

 

Students may wish to continue with other topics. These lectures will be useful for common tasks that are performed with SQL Server and Visual Studio with a database. These topics are simply topics that did not make the 15 weeks of the course, but are still useful to understand, some are currently being developed.

 

Topic - Using Visual Studio with SQL Server

 

Topic - Creating and Using Views

 

Topic - Complex Queries

 

Topic - Microsoft NET Database Objects

 

Topic - Creating and Using Triggers

 


 

Additional Lectures and Materials

 

These can be found at;

 

COP4813 - Web Systems I - https://cop4813eaglin.pbworks.com/ 

COP4834 - Web Systems II - https://cop4834.pbworks.com/w/page/35926461/FrontPage 

 

 

 

Comments (0)

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