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 |
- |
|