SQL Fundamentals and Amazon QuickSight

SQL Fundamentals and Amazon QuickSight, available at $19.99, has an average rating of 3.8, with 29 lectures, 25 quizzes, based on 10 reviews, and has 18 subscribers.

You will learn about Understand SQL Fundamentals Master Data Analysis with SQL Create Interactive Dashboards with Amazon QuickSigh Publish and Share Dashboards This course is ideal for individuals who are This course is designed for beginners who want to learn SQL fundamentals and how to create interactive dashboards using Amazon QuickSight, regardless of their prior experience or background. It is particularly useful for This course is designed for beginners who want to learn SQL fundamentals and how to create interactive dashboards using Amazon QuickSight, regardless of their prior experience or background.

Enroll now: SQL Fundamentals and Amazon QuickSight

Summary

Title: SQL Fundamentals and Amazon QuickSight

Price: $19.99

Average Rating: 3.8

Number of Lectures: 29

Number of Quizzes: 25

Number of Published Lectures: 29

Number of Published Quizzes: 25

Number of Curriculum Items: 55

Number of Published Curriculum Objects: 55

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Understand SQL Fundamentals

Master Data Analysis with SQL

Create Interactive Dashboards with Amazon QuickSigh

Publish and Share Dashboards

Who Should Attend

This course is designed for beginners who want to learn SQL fundamentals and how to create interactive dashboards using Amazon QuickSight, regardless of their prior experience or background.

Target Audiences

This course is designed for beginners who want to learn SQL fundamentals and how to create interactive dashboards using Amazon QuickSight, regardless of their prior experience or background.

Welcome to the world of data analysis and visualisation with the course SQL Fundamentals and Dashboard Creation with Amazon QuickSight for Beginners! In this beginner-friendly course, you will learn the fundamentals of SQL (Structured Query Language) and how to utilise Amazon QuickSight to create interactive and appealing dashboards.

Throughout the course, we will start from the basics, assuming no prior knowledge of SQL or QuickSight, and gradually progress to more advanced concepts. By the end, you’ll have a solid foundation in SQL and the skills to build engaging dashboards to communicate insights effectively.

By the end of this course, you’ll have the knowledge and skills to confidently write SQL queries to retrieve and analyse data, as well as create visually appealing dashboards using Amazon QuickSight. Whether you’re a data analyst, an aspiring data professional, or simply interested in exploring the world of data, this course will provide you with a strong foundation to kickstart your journey.

Embark on this exhilarating and enlightening journey into the fascinating realm of SQL and Amazon QuickSight, where we will explore the depths of data analysis and visualization. Together, we will harness the immense power of data to uncover valuable insights, make data-driven decisions, and gain a deeper understanding of the information that surrounds us. So, come along and be part of this thrilling expedition as we navigate through the intricacies of SQL and Amazon QuickSight, and together, unlock the endless possibilities that data has to offer!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the course

Lecture 2: What youll learn in this course

Lecture 3: Tools and Data

Chapter 2: Introduction to SQL

Lecture 1: Understanding relational databases and SQL

Lecture 2: Setting up SQL environments (MySQL, PostgreSQL, etc.)

Lecture 3: Writing SQL queries to retrieve and manipulate data

Chapter 3: Retrieving Data with SQL

Lecture 1: SELECT statements and filtering data

Lecture 2: Sorting and limiting query results

Lecture 3: Working with multiple tables using JOINs

Lecture 4: Aggregating data with GROUP BY and aggregate functions

Chapter 4: Modifying and Transforming Data

Lecture 1: Inserting, updating, and deleting data

Lecture 2: Using SQL functions for data transformation

Lecture 3: Creating calculated columns and aliases

Chapter 5: Data Analysis with SQL

Lecture 1: Filtering data using WHERE and HAVING clauses

Lecture 2: Performing calculations with arithmetic and logical operators

Lecture 3: Subqueries and nested queries for complex analysis

Chapter 6: Introduction to Amazon QuickSight

Lecture 1: Understanding the features and benefits of QuickSight

Lecture 2: Exploring the QuickSight interface and its components

Lecture 3: Setting up QuickSight and connecting to data sources

Chapter 7: Building Visualisations with QuickSight

Lecture 1: Creating basic charts, such as bar charts, line charts, and pie charts

Lecture 2: Formatting and customising visualisations

Lecture 3: Adding interactivity to dashboards with filters and parameters

Chapter 8: Advanced Dashboard Creation

Lecture 1: Designing interactive dashboards with multiple visualisations

Lecture 2: Creating calculated fields and applying conditional formatting

Lecture 3: Incorporating advanced features like drill-downs and hierarchy navigation

Chapter 9: Sharing and Publishing Dashboards

Lecture 1: Collaborating with other users on QuickSight

Lecture 2: Publishing dashboards and embedding them in websites or applications

Lecture 3: Scheduling data refreshes and automating dashboard updates

Chapter 10: Conclusions

Lecture 1: Conclusions

Instructors

Paula Roigés
Data Analyst and Instructor at Udemy

Rating Distribution

1 stars: 1 votes

2 stars: 1 votes

3 stars: 2 votes

4 stars: 2 votes

5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!