Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Emotional Intelligence
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Cleaning
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 1 hour on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
Development Web Development Amazon AWS

Learn Analytics with AWS Athena and Quicksight

Learn Serverless Computing with AWS
Rating: 3.4 out of 53.4 (34 ratings)
610 students
Created by Pranjal Srivastava
Last updated 7/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Exploring AWS Analytics offerings and knowledge to handle data sicentist jobs
  • Be able to learn fundamentals of Amazon (AWS) QuickSight and its powerful and easy to use features and capability

Course content

5 sections • 11 lectures • 47m total length

  • Preview05:54

  • Preview09:41
  • Overview of Athena SQL Editor and many more option
    05:22

  • Preview03:17
  • Athena : Bulk Add Column
    05:07
  • SELECT Statement
    03:04
  • GroupBy Statement
    03:44

  • CREATE Statement
    01:08
  • ALTER, ORDER By and ALTER Statement
    04:35
  • DROP Statement
    02:20

  • Quicksight
    03:44

Requirements

  • Basic knowledge of database and data warehouse concepts
  • Basic working knowledge of any SQL style query language
  • Course includes demo of all the labs. An AWS Account would be required to try labs hands-on.

Description

Is SQL limited to Relational database, where you can perform CRUD operation with table. Then you're wrong. In the world of data science, after Python and R programing language, SQL is most used programming language. This is true, SQL is used in data science as well.

Google Bigquery, AWS Athena uses SQL for analyzing big data. A big data consists might be petabytes (1,024 terabytes) or exabytes (1,024 petabytes) of data consisting of billions to trillions of records of millions of people. To analyze such a huge data is challenging and with RDBS is impossible. A big data may be structured, semi structured or unstructured data.

In this learning journey, you'll learn and practice about AWS Athena.

What is AWS Athena?

AWS Athena, is an interactive data analysis tool offered by AWS. It uses standard SQL to analyze big data. The reason behind its popularity in industries are mentioned in following points:

  • Athena is server-less, there is no infrastructure to manage, and you pay only for the queries that you run.

  • Athena uses standard SQL (Presto) to analyze data stored in an AWS S3 bucket.

  • It is easy to use AWS analytics tool.

  • In comparison to other analytics tools, it fetches results very quickly.

  • Easily integrate with BI tools like Tableau

Additionally, you'll also learn about AWS Quicksight, a BI tool offered by Amazon AWS, makes it easy to deliver rich, interactive insights. With the help of ML algorithms you will also able to find hidden insights from the data into charts.

Enroll now and upgrade your data analytics skills.

Who this course is for:

  • Anyone who wants to learn AWS Server-less technologies for data and analytics should take this course

Instructor

Pranjal Srivastava
SME of AWS & IBM Cloud
Pranjal Srivastava
  • 3.5 Instructor Rating
  • 1,906 Reviews
  • 53,055 Students
  • 56 Courses

I am passionate developer, machine learning enthusiast, coder and bug fixer. Developed many applications on various platforms including python, java, android, php, etc.

I have worked over cloud on IBM Bluemix, AWS, and Microsoft Azure. Prefer digital marketing and SEO in my free time.

I am IBM certified Python developer.

Created own Programming language in Hindi .

#ILoveIndia

#LoveOpenSource   #SmartProgrammer


  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.