Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

AWS RedShift with RDS and QuickSight

No Reviews Yet

Aundh, Pune

Course ID: 33164

Aundh, Pune

Students Interested 0 (Seats Left 0)

₹ 18,000

No Reviews Yet

Date and Time

Not decided yet.

Vikash Kumar picture
Vikash Kumar

Associate Solution Architect Certified - Twice

About Vikash Kumar

I have been in IT for more than 8 year and engaged in AWS projects for more than 4 years.
I have done the Solution Architect certification twice, recently in 2016 Nov.
I have been into AWS training for almost 1.5 years which includes online training, classroom training and corporate training.
No reviews currently Be the First to Review

About the Course

With raising demand of Cloud Data warehousing and AWS Redshift in the market, we came up with this course. The course content has been designed according to the current need of industring and its future prespectives. The combination of Redshift along wint Amazon RDS and QuickSight, makes it the hot cake in IT industry.


The Course Outline is mentioned below. It may change as per demand.





































































































































































































































































































































Category Topic Labs Duration
Introduction to Redshift Introduction to AWS & Its data storage system   01 Hr
AWS Free tier account   
Set up First Budget  
Set up Billing alarm  
Why Redshift ?  
Introduction to Data Warehouse Introduction to Data warehouse   01 Hrs
Deep dive into Data warehouse  
Public Cloud Data warehouse  
How Redshift as Data Warehouse  
Practice Use cases of Redshift - Real time scenario  
Other Tools and comparision with Redshift  
Basics of RedShift Redshift Architecture   02 Hrs
Data Loading in RedShift  
Data Distribution in RedShift Yes
Redshift Clusters Yes
Configure SQL Workbench Yes
Using S3 data for RedShift Yes
Loading Data into clusters Yes
Qurying a Redshift Cluster Yes
RedShift - Advance Performance tunning   04 Hrs
Columnar storage  
Workload Management  
Loading Data from DynamoDB   
 RedShift Best Practice-Designing Table Yes
 RedShift Best Practice-Data Loading Yes
 RedShift Best Practice-Query Designing Yes
Tunning Table Design Yes
Managing Database Security Amazon RedShift Security Overview   01 Hrs
Database User Priviledge Yes
User, Superuser and Groups Yes
Schemas Security Yes
Table Desiging Choosing a Column Compression Type   01 Hrs
Choosing Data Distribution Style Yes
Chosing Sort Keys Yes
Define Constrain Yes
Analyse Table Design Yes
Loading Data Using Copy Command to Load Data Yes 01 Hrs
Updatng Table with DML Command Yes
Updating and Inserting Data Yes
Performaing a deep copy Yes
Analysing Table Yes
Vaccuming Table Yes
Managing Concurrent write Operations Yes
Unloading Data Unloading data to S3 Yes 01 Hrs
Unloading Encrypted data files  Yes
Unloading data into delimited text file  Yes
Reloading unloaded Data Yes
User Defined Functions UDF Constraints   01 Hrs
UDF Security and Privileges  
UDF Data Types Yes
Naming UDFs  
Creating a Scalar UDF Yes
Logging Errors and Warnings in UDFs Yes
 Workload Management Defining Query Queues   02 Hrs
Modifying the WLM Configuration Yes
WLM Queue Assignment Rules Yes
Assigning Queries to Queues Yes
WLM Dynamic and Static Configuration Properties Yes
WLM Query Monitoring Rules Yes
SQL Reference Amazon RedShift SQL   02 Hrs
Using SQL Command  Yes
SQL Function Refenrence  
System Table Reference  
STL Table for logging Yes
STV Tables for Snapshot data Yes
Data Usage - QuickSight Introduction to QuickSight   02 Hrs
Architrecture of QuickSight  
Data Sources of QuickSight Yes
Illustrations in QuickSight Yes
Report Generation in QuickSight Using RedShift Yes
Dashboard and sharing in QuickSight Yes
    Total Hrs 20 Hrs

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

₹ 18,000

Post your requirement and let us connect you with best possible matches for Amazon Web Services Training Post your requirement now
₹ 18,000 Enquire

Enquire

Submit your enquiry for AWS RedShift with RDS and QuickSight

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Vikash

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer