Module 1

• Database concepts
• OLTP vs OLAP databases
• Client-Server architecture
• Database design
• Introduction to SQL
• Transact-SQL
• SQL Server components
• Analysis service
• SQL Server Integration Service (SSIS)
• Notification Services
• Relational Database Engine .Net CLR
• Reporting Services
• Service Broker
• AWE
• Mirroring
• SQLiMail
• Native Ciphering
• SQL Server Management Studio
• Database Creation
• Transaction log
• Checkpointing
• Filegroups
• Schemas
• Database snapshot
• Data Types
• Tables
• Table Partitioning
• XML Queries
• OpenXML
• XQuery
• Indexes: grouping, no grouping and heap
• Index creation
• Index optimization
• Data Integrity
• Restriction
• Triggers
• Views
• Stored Procedures
• Functions
• Transactions
• Locks
• CLR Integration
• Assemblies

Module 2

• Installation and configuration of the SQL Server Database
• Backup and restoring
• Security copies
• SQL Server Security
• Activity monitor
• SQL Server Profiler
• DLL Triggers
• Automatization of administrative tasks
• Alerts
• Multiple-Server configuration
• Replica management and monitor
• Replica configuration
• Disponibility and maintainance
• Server Clustering
• Log Shipping