SQL Server 2019 Management Training
About Education
This training provides comprehensive information and practical applications for the effective installation, management, monitoring, and protection of Microsoft SQL Server 2019 by system administrators and database administrators (DBAs). Throughout the training, advanced administrative topics such as SQL Server installation, configuration, backup and restore strategies, security, monitoring, data transfer, automation, replication, and high availability will be covered using practical examples. Participants will gain the knowledge and skills necessary to manage SQL Server infrastructures securely, reliably, and efficiently.
Prerequisites
- Basic knowledge of SQL (T-SQL query proficiency)
- Familiarity with database concepts
- Basic proficiency in Windows Server environments
- Previous training in ‘Querying SQL Server’ or similar courses is advantageous.
Duration of Training
Total Duration: 5 Days (6 hours per day)
Total Training Hours: 30 hours
Training Format: Practical and interactive classroom/online environment
Who Should Participate?
- Database administrators (DBAs)
- System administrators and IT infrastructure specialists
- Technical team members who manage SQL Server in production environments
- Candidates who have set SQL Server administration as their career goal
- Application developers, individuals seeking to better understand data infrastructure
Educational Content
- SQL Server Installation and Configuration
- SQL Server ön gereksinimleri
- SQL Server kurulumu ve yönetimi
- Measuring service configuration and hardware requirements
- SQLIOSIM usage and installation automation
- Database and File Management
- Database planning and creation
- File/FileGroup management
- Metadata review, file transfer
- Buffer Pool Extension configuration
- Disaster Recovery (Backup & Restore)
- Backup strategies
- Transaction log architecture
- Full, differential, and transaction log backup
- Restore operations, time-based rollback
- Snapshots, system database recovery
- SQL Server Security and Authorisation
- Security model, user and role management
- Encryption, keys and certificates
- Fixed/database roles and custom role definition
- Authorisation levels and schema-based control
- Monitoring and Performance Tracking
- Current Activity & System Monitor
- Data Collector and SQL Profiler
- DDL triggers, Event Notification
- Audit mechanisms and warning systems
- Data Transfer
- Data transfer architecture
- Import/Export Wizard and SSIS usage
- ETL processes with SSIS, distribution, bcp tool
- Database Maintenance
- Data integrity checks
- Index maintenance, file size management
- Scheduling automatic maintenance tasks
- Advanced Management Tools
- Policy-Based Management
- Multi-server management
- Resource Governor kullanımı
- Task Automation
- SQL Server Agent configuration
- Scheduled tasks, operators
- Automated task scripts and security
- SQL Server Replication
- Replication architecture and definitions
- Merge, Snapshot, Transactional replication
- Publication & Subscription
- HTTP Merge structure
- High Availability
- Log Shipping
- Database Mirroring
- SQL Server Clustering
- Peer-to-Peer Replication
- Always On Availability Groups
What You Will Gain at the End of Training
- Learn the installation, configuration, and updating processes of SQL Server 2019 through practical application.
- Full proficiency in database creation, management, migration and monitoring
- Ability to develop, test and implement backup and recovery strategies
- Understanding the SQL Server security model and effectively managing roles, users, and permissions
- Automating tasks and creating alert systems with SQL Server Agent
- Understanding replication and high availability solutions at the application level
- Advanced database management practice with real-world scenarios
