Basics
- DBMS
- RDBMS
- Oracle and SQL Server
SQL Server Environment
- SQL Server 2005 and 2008
- SQL Server Management Studio
- SQL Server Business Intelligence
- Development Studio
SQL Language
Data Integrity
- Entity Integrity
- Domain Integrity
- Referential Integrity
Database Design
- Normalization
- De Normalization
- Database Diagrams (E-R)
Joins and Sub Queries
- T-SQL Operators
- Simple Queries
- Built in Functions
- Joins
- SubQueries
- Advanced Queries
- T-SQL Enhancements in SQL Server- 2008
Views
- Create View
- Advantage of View
- Updatable View
- NonUpdatable View
- Index View
Stored Procedures
- System Stored Procedure
- User Stored Procedures
- Passing In/Out Parameters
- Altering Procedure
- Advantages of Procedure
- Extended Stored Procedure
User Defined Functions
- Scalar UDF
- Inline DDF
- Multi Statement Table DDF
- Table Variables
- Temporary Tables
Triggers
- DML Triggers (After | Instead of )
- DDL Triggers
- Magic Tables
- Advantages of Triggers
Transactions and Locks
- Explicit Transactions
- TCL Commands
- Lock Types
- Isolation Levels
- Dead Locks
- MS-DTC
Cursors
- Declaring Cursors
- Modifications Thorough Cursors
- Types of Cursors
- Advantages of Cursors
Indexes
- Clustered Index
- Non Clustered Index
- Creating Index
- Advantages of Indexes
XML Integration
- FOR XML
- OPEN XML
- XML Data Type
.NET 2.0 (CLR) Integration
- CLR Objects
- CLR Stored Procedures
- CLR User Defined Functions
Security
- Windows Authentication
- SQL Server Authentication
- Creating Login
- Database Permissions
- Introduction to Roles, Schema
- Droping Login
Database Maintenance
- Backup Database
- Restore Database
- Deployment of Database
- Generating T-SQL Scripts and Batches
- System Databases and System Tables
SQL Server Agent
- Jobs
- Schedules
- Alerts
- Operators
Data Transformation Services
- BCP
- DTS Packages / SSIS Packages
Datawarehousing Support
- OLTP
- OLAP
- Analysis Services (SSAS)
- Reporting Services (SSRS)
- Sample Projects
Introduction to DBA Concepts
- Replication
- Performance Monitoring
- SQL Server Configuration Manager
- Service Broker
|