Syllabus

Module 1 - AWS Intro

  • Cloud Computing
  • Cloud deployment and service models
  • AWS Global Infrastructure and its benefits
  • AWS Services
  • Ways to access AWS Services

Module 2 - AWS Basics

  • User management through Identity Access Management (IAM)

  • Various access policies across AWS Services
  • API keys service access
  • Best practices for IAM
  • Key Management Service
  • Access billing and create alerts on billing

Module 3 - EC2/AMI/VPC

Start, stop and terminate an EC2 Instance
Security Group
AMI
VPC, ENI, Public and Private IP
Storage services
EBS and its types
EFS
Cost optimization

Module 4 - S3

Overview of Amazon S3
Amazon S3 Use Cases
Amazon S3 Buckets, Objects and Storage Classes
Integration with Other AWS Services

Module 5 - RDS

AWS RDS
MutliAZ
Read replica
Automatic Backup
Manual snapshot
Read consistency
Read encryption

Module 6 - EMR

AWS EMR
Hadoop
HDFS/S3
Hive
Kafka
Spark

Module 7 - Redshift

AWS Redshift – Data Warehouse-as-a-Service
Features
Pricing
Redshift Architecture Overview
Clusters
Leader and Compute Nodes
Node Slices
Columnar Storage for performance

Module 8 - Redshift

Up and Running with AWS Redshift – Hands On
Launch a new Redshift Cluster
Modifying a Cluster – resize, showdown, delete, reboot.
Security Groups.
Parameter groups.
Database Encryption.
Backup and recovery – creating manual snapshot and automatic snapshots.
Authorize access to Cluster
Accessing Amazon Redshift cluster – Hands On

Module 9 - Redshift

JDBC and ODBC interfaces
Install and configure client SQL tools using JDBC and/or ODBC drivers
Create Database, Users, user groups, permissions and access controls.
Connect to Redshift Cluster
Load sample data into cluster
Create and test queries against the data
Designing tables – Deep dive – Hands On
DDL SQL – Creating Tables, Alter tables, Drop tables.
LIMITATIONS and what is implemented differently.
Selecting distribution Style and distribution keys.
Selecting Sort Key.

Module 10 - Redshift

Loading data – Deep Dive – Hands On
Using Copy to Load data
Loading data from S3
Using a Manifest to Specify Data Files
Loading Compressed Files
Loading Fixed-Width Data
Loading Multi-byte Data
Loading Encrypted Data Files
Loading from JSON files.
DML Operations
Insert, Select, Update, Delete
Deep Copy
Unloading Data
Unloading Data to Amazon S3
Unloading Encrypted Data Files
Unloading Data in Delimited or Fixed-Width Format
Reloading Unloaded Data

Module 11 - Snowflake

Key Concepts & Architecture
Cloud Platforms
Snowflake Editions
Overview of Key Features
Overview of the Data Lifecycle
Continuous Data Protection

Module 12 - Snowflake

Overview of the Ecosystem
SnowSQL (CLI Client)
Installing SnowSQL
Configuring SnowSQL
Connecting Through SnowSQL
Using SnowSQL
JDBC Driver
Downloading / Integrating the JDBC Driver
Configuring and Using the JDBC Driver
JDBC Driver Diagnostic Service
ODBC Driver
Downloading the ODBC Driver
Installing and Configuring the ODBC Driver for Windows

Module 13 - Snowflake

Overview of Data Loading/Unloading
Data Loading/Unloading Considerations
Preparing to Load/Unload Data
Bulk Loading/Unloading from a Local File System
Bulk Loading/Unloading from Amazon S3
Loading Continuously Using Snowpipe
Loading Using the Web Interface
Querying Data in Staged Files

Module 14 - Snowflake

Using the Web Interface
Virtual Warehouses
Databases, Tables & Views
Queries
Date & Time Data
Semi-structured Data
Binary Data
Snowflake Time Travel & Fail-safe
Introduction to Data Sharing
Data Providers

System Usage & Billing
Understanding Snowflake Credit and Storage Usage
Understanding Snowflake Data Transfer Billing
Monitoring Account-level Credit and Storage Usage
Working with Resource Monitors
Parameter Management
User Management

Module 15 - AWS Data Pipeline/Kinesis

Data pipeline
Data collection
Components
Activities/precondition
Resources/Actions
Automate data movement
Data Stream
Visualizing Web Traffic Using Amazon Kinesis
Data Streams using AWS CLI

Module 16 - Lambda Function

Serverless Computing
Console
Automate EC2
Deployment package

Module 17 - Athena/Glue/Quicksight

AWS Athena & Glue
Creating Db and table
ETL jobs
Making Connection to Quicksight
Import,filter,fields,functions
Visualization basics
Dashboard

Developed by God Particles
Back to Top