DATABASE DESIGN

THE SELECT STATEMENT

• Inner Join, Outer Join and Cross Join
• SELECT Statement Using the pubs DB
• SELECT Examples Featuring ORDER BY
• SELECT Examples with Subqueries
• SELECT Examples Featuring COMPUTE
• SELECT with String, Date and Math Functions
• SELECT with Statistical Functions
• Dynamic SQL
• SELECT Statement with GROUP BY Clause

MODIFY DATA

• Table INSERT Using Enterprise Manager
• INSERT Statement with VALUES Using Query Analyzer
  
• INSERT.....SELECT Statement
  
• DELETE Statement Examples
• UPDATE Statement
• Modifying Data with Cursors and Subqueries
• Logged and Nonlogged Operations

DATA INTEGRITY

• Entity, Domain, Referential and User-Defined Database Integrity
• Entity Integrity Definition Using Enterprise Manager
• Scripting Tables and Related Objects Using Enterprise Manager
• Domain Integrity Constraints Using the Query Analyzer
• Referential Integrity Explanation and Constraints
• User Defined Data Integrity Objects
• Business Rules Enforcement with Triggers

PROGRAMMING OBJECTS

• Simple Stored Procedures
• Stored Procedures with the OUTPUT Parameters
• Stored Procedures in the Northwind Database
• CREATE TRIGGER Examples
• Trigger Examples with DELETED and INSERTED Tables
• INSTEAD OF Triggers and AFTER Triggers
• Ωiews Definition and Examples
• CREATE FUNCTION Examples
• Temporary Tables, Optimization and tempdb

TRANSACT-SQL

1. TRANSACT-SQL

• Batch, and Scripts
• BEGIN, COMMIT, ROLLBACK TRANSACTION3. Locks, Isolation Levels and Deadlocks
• PROGRAMMING STATEMENTS in Transact-SQL
• User Defined and System Stored Procedures

1. Logical Data Modelling

• Data Types for Table Columns
• Creating Tables by Statements
• Additional Create Table Examples
• Create Special Tables and Copy Tables
• Observing Table Behaviour
• Creating Tables by Enterprise Manager
• Primary Key and Foreign Key Constraints
• Normalization and Debated Design Issues
  
• Database Design and Programming Standards

Μεθοδολογία Υλοποίησης Σεμιναρίου & Οπτικοακουστικά Μέσα