Duration 3 days – 21 hrs
Overview
This course provides an in-depth look at the essentials of Microsoft SQL Server Administration and Security, covering everything from the basic architecture and design, to advanced configuration and security management. Participants will gain practical experience and deep insights into the systematic management of SQL Server environments
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
