Microsoft SQL Server Administration Training in Marina Bay, Singapore

This course provides IT professionals and database administrators with the core knowledge and skills to administer Microsoft SQL Server databases. It covers installation, configuration, security, backup and restore, performance monitoring, and maintenance. The course includes hands-on labs and exercises to reinforce key administrative tasks in real-world scenarios.

Course Agenda:

SQL Server Fundamentals and Installation

• Overview of SQL Server architecture

• Editions and licensing overview

• Installing SQL Server and SQL Server Management Studio (SSMS)

• SQL Server Services and configuration options

• Exploring SQL Server system databases

Security and User Management

• Authentication modes: Windows vs SQL Server authentication

• Creating and managing logins and users

• Server roles and database roles

• Permissions and securables

• Auditing and compliance basics

Backup and Recovery

• Backup types: Full, Differential, Transaction Log

• Backup strategies and best practices

• Restoring databases in various scenarios

• Point-in-time recovery

• Managing backup history and maintenance

Performance Monitoring and Maintenance

• Monitoring tools: Activity Monitor, DMVs, Performance Counters

• Identifying resource bottlenecks

• Creating and scheduling maintenance plans

• Index maintenance and database integrity checks

• Automating tasks with SQL Server Agent jobs

Troubleshooting and Advanced Topics

• Handling blocking and deadlocks

• Using SQL Server logs and Extended Events

• Introduction to High Availability and Disaster Recovery (HADR)

• Configuring alerts and notifications

• Best practices and optimization tips

Hands-on Exercises