logo

AWS Data Engineering

The well-structured AWS Data Engineering training program will equip the students with the required knowledge and skills in Data Engineering on Amazon AWS platform.

  • English
  • 9000
  • 18000
 Add To Cart
  • Course Includes
  • Live Classes
  • Continuous Assessment
  • Downloadable Course Materials
  • Real Time feedback

Requirements

  • NA

Description

Our AWS Data Engineering training program is well-crafted to provide a good level of understanding of the Data Engineering aspects on Amazon Web Services, popularly known as the AWS. This program covers the architectural principles, along with services like EBS, IAM, EC2, Athena, Glue, Lambda, Redshift and so much more. This training program is aligned with the most up to date content that will help the student to learn how to design & scale AWS Cloud implementations with industry-best practices. Furthermore, they would learn at a high level how to safely and securely move on-premise applications to Amazon’s cloud storage service.

Course Content

DATABASE CONCEPTS

Basics

DML Vs DDL Operations

SQL Vs PL SQL

RDBMS Vs NoSQL

 BASIC DATABASE OBJECTS
 mb
SQL

Select Statements

Restricting and Sorting data

Single row functions

Aggregating Using Group functions

Manipulating Data

Creating and Managing Tables

Joins

Including Constraints

Using SET Operators

Datetime Functions

Subqueries

 mb
PLSQL

Declaring Variables

Writing executable statements

Writing control structures

Composite data types

Cursors

Creating Procedures

Creating Functions

Managing Subprograms

Creating Packages

Creating Triggers

 mb
DBA FUNDAMENTALS

Managing Tables

Managing Indexes

Managing Data Integrity

Managing Privileges

Managing Users

Managing Roles

 mb
DATABASE OBJECTS

Schema Objects Vs Non Schema Objects

 mb
SCHEMA OBJECTS

Clusters

Constraints

Database links

Index-organized tables

Indexes

Materialized views

Sequences

Stored functions, stored procedures

Synonyms

Tables

Views

 

 mb
NON SCHEMA OBJECTS
mb
OTHER IMPORTANT TOPICS

Database Structures

Relationships

Data Integrity rules

Data Normalization and Denormalization

ER diagram

Introduction to NoSQL and Unstructured Data

 mb
DATA WAREHOUSING CONCEPTS

What is a Data Warehouse?

Data warehouse Vs OLTP System

Data warehouse Vs OLTP System

Bottom up approach

EDW Vs Data Marts

Typical Data Warehouse Architecture

Logical Vs Physical Design

Star Schema

Snowflake Schema

Staging area

Data Marts

Cardinality and Relationships

Facts

Dimensions

Date Dimension

Conformed Dimensions

Shared Dimension

The need for Materialized Views

DWH Performance Tuning

 mb
ETL OVERVIEW

Extraction

Transformation

Loading and Refreshing

Load time and Throughput

Load scheduling

Data Load Administration and Monitoring

Lookups and Other important transformations

Time Series analysis & Slowly Changing Dimension(SCD)

ETL Tool Walkthrough (Informatica or Talend)

 

 mb
OLAP

Symantec Layer

Data Visualization

Pivoting

Functions

Aggregations

Cubes

Multi-dimensional analysis

Reports

Data Rendering

Performance tuning

Slicing and Dicing

Temporary tables

Report automation and scheduling

OLAP Tool walkthrough (Tableau or PowerBI)

 mb
TEST MANAGEMENT

Test Plan

Test cases & scenarios

Testing cycle

UTC

Integration Testing System testing

UAT

 mb
TOOLS

HP ALM - High level –Theory

Jira - High level demo

 mb
AGILE

Agile overview

Agile types

Agile methodologies

Agile methodology in testing

 mb
UNIX

Unix Basics

UNIX commands for various operations

UNIX file I/O operations and file permissions

 mb
Introduction to AWS

Introduction to Cloud computing & AWS

 mb
EC2

-Launch BI Server with termination protection enabled -Monitor Ec2 Instance -Modify Security Group of BI Server to allow access -Resize your BI Server -Test Termination Protection -Termination Ec2 Instance

 mb
AWS S3

Create S3 bucket -Add an object to S3 bucket -Create bucket policy for BI server -Configure S3 bucket versioning -Load data into S3, processing pipelines

 mb
AWS IAM Lab

Creating users and groups -Configuring IAM policy -Configuring IAM roles for BI server

 mb
AWS Lambda

Create Lambda function -Configure s3 bucket as a Lambda event source -Trigger Lambda function by uploading data to S3

 mb
AWS Redshift

Intro to Column-oriented database Massively Parallel Processing (MVP) Concepts Data types used in Amazon RedShift Getting started with AWS Redshift Creating an IAM role Launching a Sample Amazon Redshift Cluster Authorizing access to the cluster Connecting to the cluster and running queries Loading sample data from Amazon S3 Cleaning up

 mb
Basics of EMR

Amazon Elastic MapReduce (EMR) is an Amazon Web Services (AWS) tool for big data processing and analysis.

 mb
Basics of Glue

Fully managed extract, transform, and load (ETL) service

 mb
Intro to Amazon Kinesis Data Streams

Power BI Overview -Power Bi Desktop -Power BI Queries - Connect to Data, Power BI queries - Details, Power BI queries - Common query Tasks -Power BI queries - Parameters and custom task -PowerBI – Modelling -DAX -PowerBI Visuals -PowerBI Service

 mb
Basics of DynamoDB

Fully managed proprietary NoSQL database service that supports key-value and document data structures.

 mb
Basics of Athena

Serverless Interactive Query Service

 mb
PROJECT WORK

Project involving creation of database objects, ER diagrams, Dimensional Modeling, ETL transformations, Mappings, and OLAP reports

 mb

Recent Courses

blog
Expert-Level Shell-Scripting Traini...
  • 5000
  • 10000
blog
Advanced Level Perl Training Progra...
  • 15000
  • 30000

About the Instructor

instructor
Rohit
About the Instructor

Report