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
|