Overview of database fundamentals

• Client/Server
• RDBMS
• Overview on SQL Server History.

SQL Server 2005 editions

• Express
• Standard
• Enterprise
• Workgroup
• Mobile
• Developer

SQL Server components and tools

• SQL Server Management Studio
• Business Intelligence Development Studio
• SQL Server Agent
• Database engine

Building a database

• Creating the Databases.
• Choosing file names and locations
• Determining file size and growth parameters

Designing tables

• Defining columns and attributes
• Selecting appropriate datatypes
• Setting the primary keys and indexes
• Modifying or removing columns

 Data Selection Queries

• Understanding Transact-SQL
• The SELECT Statement
• The WHERE Clause
• Using ORDER BY to Sort Data
• The GROUP BY Clause

Altering data with SQL commands

• Over view of T-SQL language.
• INSERT
• UPDATE
• DELETE
• Commit, rollback and commit transaction.

Applying constraints in SQL Server

• Overview on Constraints
• Enforcing the Primary key
• Enforcing the unique key
• Enforcing the Foreign key
• Performing the DML Actions on Foreign key
• Enforcing the default constraint
• Enforcing check constraints
• Validating the existing data
• Protecting relationships with foreign keys
• Designing the Database Diagrams to study the relationships

Views, Synonyms and DB Diagrams

• Overview on Views.
• Creating views
• Securing the data through views
• Overview on synonyms
• Creating Synonyms

Joins and TEMP Tables

• Overview of joins
• Writing different types of joins
• Using joins over the Foreign key relation
• Overview on temporary tables
• Creating temp tables
• Diff between local and global temp tables

 Stored Procedures, User-Defined Functions and Triggers

• Overview of SQL server Programming.
• Writing Stored procedures
• Using Cursors, parameters and variables inside a stored procedure.
• User-Defined Function Overview
• Scalar Functions
• Inline Table-Valued Functions
• Multi-Statement Table-Valued Functions
• Overview on triggers
• Types of triggers
• Implementation of triggers
• Using Functions, Views, and Stored Procedures