Introduction
- History of versions
- Editions of SQL server
- Installation
- SSMS environment
SQL server Architecture
Server Configuration
- SQL server configuration manager
- Starting and stopping of SQL server
- Default Port
- Authentication modes
Database Configuration and Maintenance
- System Databases & User databases
- Physical database architecture
- Physical files
- Primary, Log files, Secondary Files
- Pages, Extents
- Transaction Log
- Database Options
- Recovery Options
- Auto Options
- Access
- Parameterization (2008)
- Collation sequences
- Maintain database integrity : Constraints
- Moving of Database
Designing Indexes
- Index architecture
- Designing Indexes
- Clustered Index
- Non Clustered index
- Index Options : Fill Factor
- Maintaining Indexes
- Tuning Indexes
- Fragmentation
- Index Reorganize and Index Rebuild
Security
- Surface area configuration
- Logins, Users
- Securable and Object permission
Backups and Restore
- Backups
- Full, Differential, Transaction Log
- Restore
- Recovery Models
- Maintaining Transaction Log
Dealing with Flat Files
- BCP
- Bulk Insert
- Open Row set
- Open data source
Automation
- SQL server Agent
- Jobs
- Schedules
- Database Mail setup
- Trouble Shooting database mail
High Availability
- Replication
- Snap Shot
- Transactional
- Merge
- Mirroring
- Log Shipping
- Clustering
Optimizing Performance
- Available Tools
- SQL Profiler
- DTA
- DBCC Commands
- DMV’s
- System Stored Procedures
- Index Performance Tuning
- Query Tuning
- Execution Plans
- Table Scan, Index Scan, and Index Seek
- Locks
- Transactions concept and Isolation levels