SQL Server Administration (SSMS) Training in Kuala Lumpur, Malaysia

This course provides IT professionals, database administrators, and developers with the practical skills needed to manage and administer Microsoft SQL Server using SQL Server Management Studio (SSMS). The course covers core administrative tasks, performance tuning, backup and recovery, security, automation, and best practices for maintaining a secure and efficient SQL Server environment.

Course Agenda

Introduction to SSMS and SQL Server Architecture

• Overview of SQL Server editions and components

• Navigating SQL Server Management Studio

• Connecting to and managing multiple instances

Database Creation and Configuration

• Creating databases and filegroups

• Configuring database properties

• Managing system and user databases

Security and Permissions

• SQL Server authentication modes

• Managing logins, users, and roles

• Granting and revoking permissions

• Auditing and compliance features

Backup and Recovery

• Backup strategies: Full, Differential, Transaction Log

• Performing and automating backups

• Restoring databases using SSMS

• Point-in-time recovery

Monitoring and Performance Tuning

• Using Activity Monitor and DMVs

• Configuring and reading SQL Server logs

• Indexing strategies and maintenance

• Query performance and execution plans

Automation and Maintenance

• SQL Server Agent jobs and alerts

• Creating and scheduling maintenance plans

• Automating backups, integrity checks, and index optimization

• Email notifications and logging

Troubleshooting and Diagnostics

• Handling blocking and deadlocks

• Monitoring disk usage and resource bottlenecks

• Using SQL Profiler and Extended Events

• Importing/exporting data

Best Practices and Case Studies

• Real-world administration scenarios

• Security hardening checklist

• Disaster recovery planning

• Performance optimization strategies

Hands-on Exercises