CET 4429 Lectures

Click on the link to either download or view the video files.  These lectures are available as part of the CET 4429 class. Additional lecture that might be useful are available at http://ucf-cet4583.pbwiki.com/CET+4584+Lectures

Database Concepts Review and Design

• Getting Started with SQL Server  
• How to Create a Connection String
• Database Design Concepts - Abstraction and Relationships
• Database Normalization and Redesign 
• Creating Complex Views for Reporting
• Database Design Tutorials (not video)
• Coding Correctly in DOTNET (or any language)

Transaction and Concurrency Management

• Transaction and Concurrency Management  
• Creating Stored Procedures in SQL Server 
• Course Registration Transaction Example
• Using Transactions and Identity Fields

Database Standards

• Creating a Database Mapping Application 
• Getting Started with LINQ
• LINQ - Using Stored Procedures

Database User Interface (entry and reports) 

• Logic Layers in Database Design
• Using LINQ with Stored Procedures to Create a Web Input Form    
• Using Session Variable in DOTNET to Identify User
• Reporting with LINQ Using Database Views
• Generating reports with Report Viewer and Datasets (Microsoft Video) 

Optimization and Tuning

• Optimization Techniques in SQL Server  
• Creating Indexes in SQL Server

Other Database

• Using ETL in SQL Server 2005
• Using Visio Professional to Reverse Engineer a Database
• Using NIEM Standards in Database Design 
• Building a Login System Using ADO
• Using Stored Procedures to INSERT Data 
• Using a Script to Transfer a Database from Server to Server
• Categories and Codes Case Study

Microsoft LINQ Series

How do I get started in LINQ?

How do I perform group and aggregate queries?

How do I use LINQ over datasets?

How do I use LINQ to SQL?

How do I create a One to Many form Using LINQ to SQL?

How do I upgrade VB project to enable LINQ?

How do I get started with LINQ to XML?

How do I enable XML Intellisense and use XML Namespaces?

How do I create XML DOcuments from SQL Data?

How do I create Excel spreadsheets using LINQ to XML?