Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Jan 27th @8:00PM

Faculty: Mr. U. Seshadri (18+ Yrs Of Exp,..) (AWS Certified Trainer)

Duration: 2 Months

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91 - 9246212143, 80 96 96 96 96

 

Syllabus:

Amazon Web Services
with MySQL & Linux Basics

MySQL

• Introduction to SQL
• Popular Databases – MySQL
• SQL Basics
  • Database, Tables
  • DDL, DML, DCL, TCL
• SQL Constraints
• Not Null
• Primary Key
• Foreign Key
• Default
• Check
• Unique
• SQL Data Types
• SQL DQL
• Select
• Group By
• Having
• Order By
• SQL Joins
• Inner Join
• Left Join
• Right Join
• Full Join
• Self-Join
• Cross Join
• SQL Advanced Queries
• SQL Windows Functions
• SQL CTE/Hierarchical Queries
• SQL Views
• SQL Indexes
• PLSQL
• SQL vs PLSQL
• Procedures
• Functions
• Triggers
• SQL Project
• SQL Data Engineering Use Case

Linux Basics

• Linux Introduction
• Command line utilities and basic commands
• Linux File System Introduction
• Text Editors
• Filters and Redirections
• Users & Groups and Permissions

Cloud Computing

• Problems in Traditional Storage Systems
• Problems in Traditional Processing Services
• Cloud Computing as Solution
  • IAAS
  • PAAS
  • SAAS
• Cloud Services
• Comparison of AZURE, AWS and GCP

Amazon Web Services

• Introduction to AWS
• AWS Free Account Creation
• Free Tier Account Limitations Overview

Compute

• EC2 Instance Launch Wizard
• EC2 Instance Type
  • Windows EC2
  • Linux EC2
• Generation Custom Public Key & Private Key
• PPK File Using AWS Account
• Security Group
• Transfer Local File to Server
  • Windows Server
  • Linux Server
• Webservers
  • Linux Webserver
  • Windows Webserver
• Bootstrap Script
• Create EC2 User
  • Linux Machine
• Placement Groups
• Load Balancers
  • Elastic Load Balancer
• Application Load Balancer
• Network Load Balancer
• Auto Scaling
• Status Checks
  • Instance Status Check
  • System Status Check
• Protect the Instance From Termination
• Scale Up and Down
• Scale Out and In
• Snapshots
  • Moving Snapshot to Another Region
  • Schedule Snapshot
• Amazon Data Lifecycle Manager
• Creating Customized Amazon Machine Images (AMI)
• Create EC2 Instance Alarm
• Launch an instance from a launch template
• Metadata and Tags
• AWS Command Line Interface (CLI)
• Recover Lost Key Pair

Storage:

• Elastic Block Store (Volume)
  • Attach & Detach Volume
  • Mount the Volume
• Elastic File System (EFS)
• Simple Storage Service (S3)
  • Versioning in S3
  • Static Webhosting with S3 Bucket
  • Amazon S3 Storage Classes
  • S3 Replication
    • Same Region Replication
    • Cross Region Replication
  • S3 Transfer Acceleration
  • Encryption
  • Access Control List
  • Bucket Policies
  • Life Cycle Management
  • S3 Access Logs
  • S3 Event Notification
  • S3 Object Lock
  • Connect S3 Bucket Using WINSCP

Identity & Access Management

• Root Account VS IAM User
• Create IAM User & Attach Policy
• Create User Groups & Attach Policy
• Creating Custom IAM Policies
• IAM Password Policies
• Multi-Factor Authentication
  • Root User
  • IAM User
• Roles
• IAM Credential Reports

Amazon Virtual Private Cloud

• Introduction about VPC & Create VPC
• Introduction about Subnet & Create Subnet
• Public Subnet
• Private Subnet
• Internet Gateways & Route Tables
• Bastion Hosts
• NAT Gateways
• Network Access Control List (NACL)
• Ephemeral Ports
• VPC Reachability Analyzer
• VPC Peering
• VPC Endpoint
• Gateway Endpoint
• VPC Flow logs
• VPN Configuration with AWS (Open VPN)

Route 53

• DNS Record Overview
• Routing Policies
• Simple Routing Policy
• Latency Routing Policy
• Failover Routing Policy
• Weighted Routing Policy
• Geolocation Routing Policy
• Multivalue Routing Policy

Database

• Introduction of Database
• Types of AWS Databases
• Types of AWS Services in AWS Databases
• Launching a RDS Instances (MySQL)
• Multi Availability Zone For RDS Instances
• Read replicas For RDS Instances
• Connect RDS Instance with MYSQL Workbench
• DynamoDB

Application Services

• Elastic Beanstalk
• AWS Lambda
• Simple Notification Service
• Simple Queue Service
• AWS Calculator
• Amazon Event Bridge (Amazon CloudWatch Events)
• Simple Email Service
• Service Quota

Monitoring Tools

• Cloud Watch
• Logs
• Metrics
• Create Billing Alarm

Migration and Transfer

• AWS Backup
• AWS DataSync (EFS to EFS)

Athena & Glue

AWS Project

• VPC, EC2 & RDS
• S3 & Route53