Administering a SQL Server 2022 Database Infrastructure
Learn to administer, secure, monitor, troubleshoot, back up, and optimize Microsoft SQL Server 2022 database environments.
Overview
This 4-day Microsoft SQL Server 2022 Database Infrastructure Administration training program provides comprehensive knowledge and practical skills to install, configure, secure, monitor, and maintain SQL Server environments. Participants will learn SQL Server architecture, instance installation and upgrades, user authentication, role management, permissions, encryption, auditing, backup and recovery, and SQL Server Agent automation. The course also covers alerts and notifications, Extended Events, performance monitoring, troubleshooting, data import and export, query optimization, execution plan analysis, locking, deadlock investigation, and index management. Through practical exercises, learners will develop the skills required to manage secure, reliable, and high-performing SQL Server database infrastructures.
Certification
“It’s not the certificate that matters the most but preparing for the Industry”
- Participation certificate for all the attendees.
- Deserving performers will be awarded Merit certificates.
- Participants will receive the certificate with a unique code which can be verified online.
- Internship opportunity on Course Completion
Prerequisite
- Basic knowledge of relational database concepts and SQL.
- Familiarity with database tables, queries, and relational data structures.
- Basic understanding of Windows Server and system administration is recommended.
- Knowledge of database backup, recovery, and security concepts is helpful.
- Previous experience with SQL Server or another relational database management system is beneficial but not mandatory.
Eligibility
- Database Administrators (DBAs) who want to develop SQL Server administration skills.
- SQL Server Database Developers and SQL Professionals.
- System Administrators and IT Infrastructure Professionals.
- Database Support Engineers and Technical Support Professionals.
- Data Engineers working with Microsoft SQL Server environments.
- IT professionals responsible for database security, backup, recovery, and performance.
- Professionals preparing for database administration roles involving Microsoft SQL Server.
Topics to be covered on this course
- Day 1:
- Module 1: “Introduction to SQL Server components”
- Module 2: “Installing SQL server Instance”
- Module 3: “Upgrading SQL Server to SQL Server “
- Module 4:‘ SQL Server Security’- Introduces SQL Server security models, logins and users.
- Module 5:‘Assigning Server and Database Roles’ covers fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
- Day 2 :
- Module 6:‘Authorizing Users to Access Resources’ describes permissions and the assignment of permissions
- Module 7: ‘Protecting data with Encryption and Auditing’ describes SQL Server Audit.
- Module 8:‘Recovery models and Backup Strategies’ describes the concept of the transaction log and SQL Server recovery models. It also introduces the different backup strategies available with SQL Server.
- Module 9: ‘Backup of SQL Server databases’ describes the SQL Server backup and the backup types.
- Module 10:‘Restoring SQL Server Databases’ describes the restoration of databases.
- Day 3 :
- Module 11:‘Automating SQL Server management’ describes how to use SQL Server agent for automation. It also explains the benefits of using master and target servers to centralize the administration of automation.
- Module 12: ‘Configuring Security for SQL Server agent’ describes the considerations for SQL Server agent security, including proxy accounts and credentials.
- Module 13: ‘Monitoring SQL Server with Alerts and Notifications’ covers the configuration of database mail, alerts and notifications.
- Module 14: ‘Tracing Access to SQL Server with Extended Events’ introduces how to use SQL Profiles and SQL Trace stored procedures to capture information about SQL Server. The module also describes how to use Distributed Replay to capture trace information from multiple servers and how to monitor locking.
- Day 3 :
- Module 11:‘Automating SQL Server management’ describes how to use SQL Server agent for automation. It also explains the benefits of using master and target servers to centralize the administration of automation.
- Module 12: ‘Configuring Security for SQL Server agent’ describes the considerations for SQL Server agent security, including proxy accounts and credentials.
- Module 13: ‘Monitoring SQL Server with Alerts and Notifications’ covers the configuration of database mail, alerts and notifications.
- Module 14: ‘Tracing Access to SQL Server with Extended Events’ introduces how to use SQL Profiles and SQL Trace stored procedures to capture information about SQL Server. The module also describes how to use Distributed Replay to capture trace information from multiple servers and how to monitor locking.
- Module 18 :Performance Tuning
- Tuning Tools, Locks
- Tuning Tools : Workload Files, Trace Files
- Profiler Tuning Template, SP Events
- DTA, Profiler Trace : Recommendations
- Execution Plan Analysis and Internals
- Query Costs : IO Cost and CPU Cost
- Query Costs: SubTree & Operator Cost
- Thread Count, Degree of Parallelism
- LOCKS : Types and Isolation Levels
- Sysprocesses and Lock Waits : Audits
- Deadlock Audits and Deadlock Graphs
- INDEX MANAGEMENT
