T-SQL for Microsoft SQL Server 2005

PT5182
Training Summary
This course teaches students the basics of Microsoft SQL Server and the SQL Server Language. Instructors will share their experiences while teaching the course material.
Prerequisites
Students should have prior knowledge of SQL, Basic Knowledge, and Relational Database Theories.
Duration
Four days
Course Topics
  • Introduction to SQL Server
  • Rules and Defaults
  • Database Design
  • Views
  • System Databases
  • Constraints
  • System Tables
  • System Stored Procedures
  • Triggers and Stored Procedures
  • Databases
  • Batches and Scripts
  • Datatypes
  • Transaction Management
  • Tables
  • Programming Constructs
  • Retrieving Data
  • Distributive Data
  • Modifying Data
  • SQL Server Extensibility
  • Indexes
  • Certification Preparation

Related Scheduled Courses