| Introduction to Database |
- |
|
| Advantages and Features of SQL Server
|
- |
|
| Versions, Editions, Licensing and
Pricing |
- |
|
| Architecture of SQL Server |
- |
|
| SQL Server Components |
- |
|
| SQL Server Management Tools |
- |
|
| Scope of SQL Server, Roles of a DBA
|
- |
|
| Installation Consideration |
- |
|
| File Stream Options |
- |
|
| Step by Step Installation |
- |
|
| Installing Hotfix, Cumulative
Updates, and Service Packs |
- |
|
| Uninstalling and Cleanup of a Failed
SQL Server Installation |
- |
|
| Types of Servers & Client/Server and
N-Tier Architecture |
- |
|
| SQL Server Architecture |
- |
|
| Types of Databases |
- |
|
| Database Architecture |
- |
|
| Creating a Database |
- |
|
| T-SQL (Transact SQL) and SQL |
- |
|
| SQL Server Database Objects |
- |
|
| Restore Data for Database Refresh
|
- |
|
| Database Migration and/or Upgrade
|
- |
|
| Automation |
- |
|
| Minimizing Downtime and Data Loss
|
- |
|
| Disaster Recovery Solutions |
- |
|
| AlwaysOn High Availability |
- |
|
| Replication |
- |
|
| Data Movement |
- |
|
| Latest Version of SQL Server, New
Features, Advanced
Troubleshooting |
- |
|
| Performance Tuning, Monitoring, and
Troubleshooting |
- |
|
| SQL Server Partitions |
- |
|
| SQL Server Full Text Search |
- |
|
| Database Snapshots |
- |
|