Session 1
- SQL Server
- System Requirements
- Architecture Enhancement
- Multiple Instances
- Post Installation
- Register / Run Server
- Check / Verify Logins
- Network Libraries
- Verify Directories
- SQL Agent Issues
- Client Issues
- TCP/IP
- Data Transfer Method
- Upgrade Checklist
- Online Database Upgrade
- Online Upgrade Exceptions
- Upgrade and Replication
- Security and Logon
- SQL Login Commands
Session 2
- Database Security
- Adding Users
- Database User Command
- Database Permissions
- Create / Use Roles
- Creating Databases
- Placing Database Files
- File Groups
- Altering a Database
Session 3
- Constraints
- Primary Constraints
- Foreign Key Constraints
- Indexes
- Index Maintenance
- Stored Procedures
Session 4
- Triggers
- Views
- Database Backup
- Working with Backups
- Transaction Log Backup
- File / File Group Backups
Session 5
- Types of Replication
- Implementing Replication
- More on Replication
- Linked Servers
- Server Automation
Session 6
- Managing Automation
- Advanced Alerts
- SQL Mail Integration
- Linked Servers
- Monitoring SQL Server
- Performance Issues
- Optimizing Database Performance
- IIS Virtual Directory
- Security Auditing
|