Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Skillshare Introduction to Data Analytics on Amazon AWS Cloud – RedShift – Glue – QuickSight

Video Introducing this tutorial

1. Marketing Video AWS RedShift (EDIT) (1)
2. 001 WHAT IS CLOUD
3. 002 WHAT IS CLOUD COMPUTING
4. 003 Cloud Computing Services
5. 004 WHY CLOUD COMPUTING
6. 005 HOW DATA WAREHOUSE WORKS
7. 006 TYPES OF DATA WAREHOUSE
8. 007 DATA WAREHOUSE ARCHITECTURE
9. 008 DATA WAREHOUSE COMPONENTS
10. 009 WHY USE DATA WAREHOUSE
11. 010 Amazon Web Services
12. 011 What is AWS RedShift
13. 012 Why AWS RedShift
14. Lab 001 Creating AWS Account
15. Lab 002 Web Console Overview
16. Lab 003 IAM Role
17. Lab 004 Creating a Cluster
18. Lab 005 Creating IAM User for Redshift
19. Lab 006 Getting Started with AWS Redshift QueryEditor
20. Lab 007 Installing SQL Workbench Client Tool
21. Lab 008 Connecting AWS Redshift with SQL Client (JDBC)
22. Lab 009 AWS Redshift Query using SQL Workbench
23. Lab 010 Creating and Loading Dataset to S3 Bucket
24. Lab 011 Setting Up AWS CLI
25. Lab 012 Load Dataset to S3 from CLI
26. Lab 013 COPY Table from S3 to Redshift Method 1
27. Lab 014 COPY Table from S3 to Redshift Method 2
28. Theory 016 a AWS Glue
29. Theory 016 b What is ETL
30. Theory 016 c ETL Process in Data Warehouse
31. Theory 016 d ETL TOOLS
32. Lab 015 Fetch Table from S3 using AWS Glue
33. Lab 016 Create IAM Role and Fetch Data from S3
34. Lab 017 Security Group and VPC Settings for AWS Redshift with AWS Glue
35. Lab 018 Connecting AWS Redshift with Glue
36. Lab 019 Crawl Redshift Table Metadata to Glue
37. Lab 020 Create Glue Job to Copy data from S3 to Redshift Table
38. Lab 021 ETL Scripting in Glue Job to Transform Data
39. Lab 022 Loading Multiple Datasets to Redshift using JDBC
40. Theory 017 What is SQL
41. Theory 018 Basic SQL Commands
42. Lab 023 1 SELECT ALL Statement
43. Lab 023 2a SELECT Specific Column
44. Lab 023 2b SELECT Single Column
45. Lab 023 3 DISTINCT Statement
46. Lab 023 4 COUNT and COUNT(DISTINCT)
47. Lab 023 5 WHERE Statement
48. Lab 023 6 AND Statement
49. Lab 023 7 OR Statement
50. Lab 023 8 NOT Statement
51. Lab 023 9 UPDATE Statement
52. Lab 023 10 DELETE Statement
53. Lab 023 11 INSERT INTO Statement
54. Lab 024 Why Join Datasets (Overview)
55. Lab 025 SQL JOINS
56. Lab 026 COUNT DISTINCT and SUM Function
57. Lab 027 AVG Function
58. Lab 028 Extreme Value Calculation and Sorting
59. Lab 029 Slicing and Limiting Data
60. Lab 030 Grouping and Filtering in Groups
61. Theory 019 What is QuickSight
62. Lab 031 Creating QuickSight Account
63. Lab 032 Importing Dataset in QuickSight
64. Lab 033 Basic Aggregation Function in QuickSight
65. Lab 034 Donut and Pie Chart in QuickSight
66. Lab 035 Bar Charts in QuickSight
67. Lab 036 Line Charts
68. Lab 037 Creating a Dashboard in QuickSight