SQL Server DBA with Cloud Administrator (AWS and
Azure) Training
Propel Your Career
Benefits of SQL DBA with Cloud Administrator Online Training:
1. Practical and Real-time Learning
2. Suitable for Starters + Working Professionals
3. Two Real-time Case Studies + Project
4. Weekly Mock Interviews
5. Focus on Real-time and Practical Concepts
6. Chapter Wise Mock Interviews + Solutions
7. Real time Interview Guidance
1. Starting with SQL Server 2019:
- History of SQL Server versions
- What's new in SQL Server 2019 for Administrators? Editions of SQL Server
- Differences between Enterprise and Standard Editions requirements
- Instances & its advantages: Default Instance, Named Instances
- Responsibilities of Database Administrator Types of DBAs
2. Installing and Configuring:
- Installing SQL Server 2019: Pre-Installation Steps, Installations, Viewing the Installation process with
Log files, Common issues, Adding or removing components
- Installing Service Packs Configuration: Configuration of Various Services, Startup Parameters,
Configuring data files and log file paths, Memory Configuration, Remote Connections, Configuring
network protocols, Ports, Configuring Services, Configuring default backup folder.
3. Working with Databases:
- System Defined databases
- Moving System Databases
- Handling TempDB database
- Database Architecture: Data Files, Log Files, Filegroups, Extents, Pages – Types, Page Architecture,
Tracking Free Space, Troubleshooting Log file full issues
- Creating Databases, Adding files, Filegroups
- SQL Server Architecture
4. Security in SQL Server 2019:
- Security Enhancements, Types of Authentications: Windows Authentication, SQL Server
Authentication
- Security Auditing, Understanding Server roles, Working with users, Resolving Orphan users
- Understanding database roles, Understanding permissions
- Major Issues
5. Backup and Restoration:
- Recovery Models: Setting Recovery Model (Full, Bulk Logged, Simple)
- Database Backups: Backup Types (Full, Differential, Transaction Log, File or Filegroup Backup),
Devices, Performing Restoration, Backup System Databases, Point-in-time Recovery, Issues related
to backups
6. Introduction to High Availability and Working
with Log Shipping:
- Introduction to High Availability, Working with Log Shipping: Features, Jobs, Requirements to
implement Log Shipping, Configuring Log Shipping, Monitoring Log Shipping, Manually performing
Fail Over, Transferring Logins, Log Shipping tables and stored procedures, Handling Issues
7. Introduction to Always On & Replication:
- Always On: HADR Internals & advantages, Setting up HADR, Patching in Always On, Troubleshooting
- Replication: Replication and Advantages, Replication Entities, Replication Architecture, Replication
Agents, Types of Replications, Configuring Replication, Snapshot Replication, Transactional
Replication, Merge Replication, Peer to Peer replication, Managing Replication, Monitoring and
Tuning Replication
8. Clustering SQL Server:
- Clustering SQL Server: Overview of Windows Clustering Requirements, Installation and
configuration of SQL Server Clustering, Applying Service packs and fixes, Moving groups, Adding
node on a SQL Server Failover Cluster, Troubleshooting Cluster issues
9. Automating Administrative Tasks:
- Maintenance Plans, Working with Database Mail: Configuring Mail Architecture, Configuring
Profiles and Accounts, Sending Mails
- Implementing Automation: Configuring SQL Server Agent, Creating Operators, Alerts, Jobs,
Managing jobs and resolving errors, Monitoring Jobs, Auto alert when jobs are enabled, disabled, or
failed
10. Advanced Administration Concepts:
- Database indexes understanding, Checking index defragmentation & Maintenance
- Database Health Check, Understanding SQL Server Profiler, Creating & Running Traces,
Understanding Extended Events, Creating & configuring Extended Events
- Monitoring Tools: System Monitor, SQL Server Profiler, Database Engine Tuning Advisor, Dynamic
Management Views, SQL Server and Windows Error Logs
- Troubleshooting: Locks, Physical Server Performance, Connectivity to SQL Server, Database
Performance, Dead Locks, Transaction Isolation Levels, Understanding Blocking, Terminating
Processes, Using the DAC
- Managing Databases
Azure and AWS Database Administrator Course Content
11. Introduction to Cloud Computing and
Databases
- Overview of cloud computing concepts
- Introduction to Azure and AWS cloud platforms
- Understanding database services in Azure and AWS
12: Azure Database Administration
- Introduction to Azure SQL Database
- Provisioning and configuring Azure SQL Database
- Managing security and access control in Azure SQL Database
- Performance monitoring and optimization in Azure SQL Database
- Implementing high availability and disaster recovery in Azure SQL Database
- Scaling and managing Azure SQL Database
13: AWS Database Administration
- Introduction to AWS RDS (Relational Database Service)
- Provisioning and configuring RDS instances
- Managing security and access control in RDS
- Performance tuning and optimization in RDS
- High availability and disaster recovery strategies for RDS
- Scaling and managing RDS instances
14: Data Migration and Integration
- Migrating on-premises databases to Azure and AWS
- Using database migration tools and services
- Data synchronization and replication across Azure and AWS databases
- Integration with other cloud services and data sources
1 5: Backup, Recovery, and Security
- Implementing backup and restore strategies in Azure and AWS
- Disaster recovery planning and implementation
- Database security best practices in the cloud
- Auditing, compliance, and encryption for databases in Azure and AWS
16: Monitoring, Troubleshooting, and
Performance Optimization
- Monitoring database performance and health in Azure and AWS
- Identifying and resolving performance bottlenecks
- Troubleshooting common database issues in the cloud
- Optimizing query performance and resource utilization
17: Best Practices and Optimization
- Designing scalable and highly available database architectures
- Database performance tuning and optimization techniques
- Implementing security and compliance best practices
- Cost optimization strategies for cloud databases
Projects Covered in Training:
Throughout the course, there will be hands-on labs and practical exercises to reinforce the concepts
and provide real-world experience in managing and administering Azure and AWS databases.
After our SQL DBA Training, participants will be proficient in:
1. SQL Server Architecture, DB Repairs, and Migrations
2. Query Tuning, Stored Procedures, and Linked Servers
3. In-Memory, DAC, and Contained Databases
4. Routine and Emergency DBA Activities
5. SQL Profiler, SQLDIAG, DTA, DMA, and SSMA Tools
6. SQL Clusters, Always-On, and SQL DBA in Azure Cloud
7. Azure Virtual Machines (VM) and Stretch Databases
8. AWS, Azure PowerShell, Azure HA-DR, and Security Management.
