DATABASE ADMINISTRATION (2/1 Credits)
Learning Outcomes:
On successful completion of this course, student will be able to: Explain the strategy to manage and monitor the database server; Apply SQL server features; Apply strategies for performance tuning; Construct a plan for backup and recovery.
Topics:
- SQL Server 2014 Architecture
- Managing and Troubleshooting the Database Engine
- Securing the Database Instance
- Configuring the Server for Optimal Performance
- Optimizing SQL Server 2014
- Monitoring SQL Server
- Performance Tuning
- Indexing
- Replication
- Clustering SQL Server
- Backup and Recovery
- Database Mirroring
- SQL Database Administration and Configuration
- Transaction Management
- Maintenance & Backup and Recovery
- Quiz & Automating SQL Server
- Query Processing I
- Query Processing II
- Final Test
SOCIAL MEDIA
Let’s relentlessly connected and get caught up each other.
Looking for tweets ...