SAINORA

HomeBlogsSQL Server 2005/2008 - SQL and T-SQL Programming

SQL Server 2005/2008 - SQL and T-SQL Programming

RDBMS Concepts and Writing Queries

  • Introduction to SQL
  • CODDS Rules
  • Normalization
  • Identifying Data Types
  • Creating and Managing Tables
  • Keys and Constraints
  • Views
  • Built-in Functions
  • DML, DDL, DCL Statements
  • Writing Advanced Queries with Joins, Aggregates, Sub queries, Correlated Sub queries
  • Set Operations
  • Indexes and Indexed Views
  • Indexing Best Practices
  • Schemas and its advantages
  • Synonyms
  • Transactions and locks

Transact SQL Programming

  • Transactions and Batches
  • Variables and Programming Constructs
  • Advanced Data types
  • Implementing Stored Procedures
  • Using Cursors
  • Types of Functions and its advantages
  • DML Triggers & DDL Triggers
  • Exception Handling
  • CLR Integration
  • Working with Dynamic SQL
  • Reading and Writing XML data