SQL Server Database Design
Course Description
Intended for those who need to create well designed, robust databases on SQL Server 2000 The course covers database design theory and practice, and the tools needed to create efficient and useable databases. Automation and Performance issues are covered as well as the design and implementation of complex queries.Duration: 5 days
Content
Database structureArchitecture
Management tasks
Transact-SQL
Transact-SQL statements
Programming in Transact-SQL
Design and implementation
Database design issues
Creating databases
Managing databases
Design and create tables
Data integrity
Constraints
Designing indexing
Implementing indices
Maintaining indices
Joining tables
Querying multiple tables
Advanced table joins
Advanced queries
Designing sub-queries
Changing data with queries
Views
Stored procedures
Parameters stored in procedures
Aggregate functions
User defined functions
Creating triggers
Transactions and locks
Implementing transaction
Managing locks
Distributed queries
Optimizing queries
Indices for query optimization
Analyzing queries
Analyzing query performance