| Introduction to DBA |
| |
| » |
Database Environment |
| » |
DBA Types |
| » |
DBA Responsibilities |
| » |
Versions and features of SQL Server |
|
|
| |
| Creating Database System |
| |
| » |
Installation Strategy |
| » |
Type of Installation |
| » |
Editions of SQL Server |
| » |
O/S Compatibility and Hardware requirements |
| » |
Pre-requisite Software |
| » |
Default and Named Instances Installation |
| » |
Troubleshooting Installation |
| » |
Configuration |
| » |
Troubleshooting Connectivity |
|
|
| |
| SQL Server Environment |
| |
| » |
System Databases |
| » |
User Databases |
| » |
Database Setup |
| » |
Database Architecture |
| » |
Database Configuration |
| » |
SQL Server Architecture |
| » |
SQL Server optimized Configuration |
|
| |
| Protecting Database System |
| |
| » |
Authentication and Authorization |
| » |
Windows Authentication |
| » |
SQL Server Authentication |
| » |
Logins |
| » |
Permissions Using Roles and DCL |
| » |
Database User, Schema |
| » |
Encryption and Decryption |
| » |
Service Accounts Configuration |
| » |
Linked Servers Setup |
|
|
|
|
|
| Maintaining Database System |
| |
| » |
Recovery Models |
| » |
Backup Methods |
| » |
Restoring Methods |
| » |
SQL Server Agent Jobs, Schedules, Operators and Alerts |
| » |
Database Mail Configuration |
| » |
Database Maintenance Plan Preparation |
| » |
DBCC Commands |
| » |
Database Snapshots. |
| » |
Indexes fragmentation |
|
|
| |
| Creating Standby Servers for High Availability [HA] |
| |
| » |
Database Monitoring |
| » |
Log Shipping |
| » |
Replication |
| » |
Clustering [Windows & SQL Server] |
|
| |
| Monitoring the Database System |
| |
| » |
Windows and SQL Server Event Logs |
| » |
User Activity Tracking |
| » |
Performance base Line |
| » |
CPU, RAM and I/O Utilization |
| » |
Performance Monitor |
| » |
SQL Server Profiler |
|
|
|
|
