Build practical database administration and security expertise with SQL Server Administration and Security Training, a comprehensive course designed for database administrators, system administrators, developers, IT professionals, application support engineers, and technical specialists responsible for Microsoft SQL Server environments.
Duration 3 days – 21 hrs
Overview
The SQL Server Administration and Security Training course provides practical, hands-on training in the essential skills required to administer and secure Microsoft SQL Server databases in professional and enterprise environments. Participants will develop a strong understanding of SQL Server architecture, configuration, database management, security controls, backup and recovery, monitoring, maintenance, and performance management.
The course begins with the fundamentals of SQL Server administration and database architecture, helping participants understand SQL Server instances, databases, storage structures, database objects, and essential administrative components. Learners will gain practical knowledge of configuring SQL Server environments and performing routine database administration tasks.
A major focus of the training is SQL Server database security. Participants will learn how to manage logins, users, roles, permissions, authentication, and authorization while applying security principles such as least-privilege access. The course also addresses practical approaches to protecting sensitive database information and maintaining secure access to SQL Server resources.
Participants will also develop essential backup and recovery skills, including backup strategies, restoration procedures, recovery models, and methods for protecting business-critical data. These skills help database professionals prepare for data loss, system failures, and other incidents that may affect database availability.
The training further covers SQL Server monitoring and performance management, enabling participants to identify database performance issues, analyze resource usage, troubleshoot common problems, and apply appropriate optimization and maintenance practices.
Through practical demonstrations, hands-on exercises, and administration scenarios, learners will gain experience applying SQL Server administration and security concepts to realistic workplace situations. The course is designed to help participants move beyond theoretical knowledge and develop skills that can be applied to day-to-day database operations.
By the end of the SQL Server Administration and Security Training, participants will have a solid foundation in SQL Server administration, database security, backup and recovery, monitoring, maintenance, troubleshooting, and performance management, preparing them to support secure, reliable, and high-performing SQL Server environments.
Learning Objectives
- Identify AWS architecting basic practices
- Summarize the fundamentals of account security
- Identify strategies to build a secure virtual network that includes private and public subnets
- Practice building a multi-tier architecture in AWS
- Identify strategies to select the appropriate compute resources based on business use cases
- Compare and contrast AWS storage products and services based on business scenarios
- Compare and contrast AWS database services based on business needs
- Identify the role of monitoring, load balancing, and auto scaling responses based on business needs
- Identify and discuss AWS automation tools that will help you build, maintain, and evolve your infrastructure
- Discuss hybrid networking, network peering, and gateway and routing solutions to extend and secure your infrastructure
- Explore AWS container services for the rapid implementation of an infrastructure-agnostic, portable application environment
- Identify the business and security benefits of AWS serverless services based on business examples
- Discuss the ways in which AWS edge services address latency and security
- Explore AWS backup, recovery solutions, and best practices to ensure resiliency and business continuity
Audience
- Database Administrators (DBAs): Professionals responsible for installing, configuring, and maintaining SQL Server databases.
- Database Developers: Developers who design and build database applications and need to understand database administration and security.
- IT Professionals: IT staff who manage and support SQL Server environments as part of their job responsibilities.
- System Administrators: Administrators responsible for the overall health and performance of database systems within an organization.
- Data Analysts: Professionals who require an understanding of database structures and security to effectively manage and analyze data.
- Security Professionals: IT security staff who need to ensure the security and integrity of database systems.
- Project Managers: Managers overseeing database-related projects who need a better understanding of the technical aspects and security considerations.
- Technical Support Staff: Support personnel who provide assistance and troubleshooting for SQL Server environments.
- IT Managers: Managers overseeing IT departments who want to ensure their team has the necessary skills for database administration and security.
- Students and Graduates: Individuals pursuing a career in database administration and looking to gain specialized knowledge in SQL Server.
Pre- requisites
- Basic knowledge of database concepts
- Familiarity with SQL Server environment
- Basic understanding of IT infrastructure
Course Content
Module 1: Architecting Fundamentals
- AWS services
- AWS infrastructure
- AWS Well-Architected Framework
- Hands-on lab: Explore and interact with the AWS Management Console and AWS Command Line Interface
Module 2: Account Security
- Principals and identities
- Security policies
- Managing multiple accounts
Module 3: Networking 1
- IP addressing
- VPC fundamentals
- VPC traffic security
Module 4: Compute
- Compute services
- EC2 instances
- Storage for EC2 instances
- Amazon EC2 pricing options
- AWS Lambda
- Hands-On Lab: Build your Amazon VPC infrastructure
Module 5: Storage
- Storage services
- Amazon S3
- Shared file systems
- Data migration tools
Module 6: Database Services
- Database services
- Amazon RDS
- Amazon DynamoDB
- Database caching
- Database migration tools
- Hands-on Lab: Create a database layer in your Amazon VPC infrastructure
Module 7: Monitoring and Scaling
- Monitoring
- Alarms and events
- Load balancing
- Auto scaling
- Hands-on Lab: Configure high availability in your Amazon VPC
Module 8: Automation
- AWS CloudFormation
- Infrastructure management
Module 9: Containers
- Microservices
- Containers
- Container services
Module 10: Networking 2
- VPC endpoints
- VPC peering
- Hybrid networking
- AWS Transit Gateway
Module 11: Serverless
- What is serverless?
- Amazon API Gateway
- Amazon SQS
- Amazon SNS
- Amazon Kinesis
- AWS Step Functions
- Hands-on Lab: Build a serverless architecture
Module 12: Edge Services
- Edge fundamentals
- Amazon Route 53
- Amazon CloudFront
- DDoS protection
- AWS Outposts
- Hands-On Lab: Configure an Amazon CloudFront distribution with an Amazon S3 origin
Module 13: Backup and Recovery
- Disaster planning
- AWS Backup
- Recovery strategies
- Hands-on Lab: Capstone lab – Build an AWS Multi-Tier architecture. Participants review the concepts and services learned in class and build a solution based on a scenario. The lab environment provides partial solutions to promote analysis and reflection. Participants deploy a highly available architecture. The instructor is available for consultations
