SQL Fundamentals and Amazon QuickSight

Focused View

Paula Roigés

1:32:55

49 View

1. Introduction

1. Welcome to the course.mp4

02:13

2. What youll learn in this course.mp4

02:14

3.1 Amazon QuickSight User Guide.html

3.2 Chinook Database.html

3.3 DBeaver Download.html

3.4 PostgreSQL Downloads.html

3. Tools and Data.mp4

02:18

4. Database management system (DBMS).html

2. Introduction to SQL

1. Understanding relational databases and SQL.mp4

02:41

2. Relational databases.html

3.1 Chinook Database.html

3.2 chinook postgresql.zip

3.3 ChinookDatabase.txt

3.4 DBeaver Documentation.html

3.5 DBeaver Download.html

3.6 PostgreSQL Download Link.html

3.7 PostgreSQL Manual.html

3.8 readme.zip

3. Setting up SQL environments (MySQL, PostgreSQL, etc.).mp4

03:16

4. Writing SQL queries to retrieve and manipulate data.mp4

02:36

5. SQL environments and queries.html

3. Retrieving Data with SQL

1. SELECT statements and filtering data.mp4

02:56

2. Customers from USA.html

3. Sorting and limiting query results.mp4

02:44

4. Top 5 customers.html

5. Working with multiple tables using JOINs.mp4

03:21

6. Using Inner Joins.html

7. Aggregating data with GROUP BY and aggregate functions.mp4

02:28

8. Group by.html

4. Modifying and Transforming Data

1. Inserting, updating, and deleting data.mp4

04:22

2. Modifying Data.html

3. Deleting Data.html

4. Using SQL functions for data transformation.mp4

05:52

5. Using CONCAT.html

6. Using SUM.html

7. Creating calculated columns and aliases.mp4

03:10

8. Using Aliases and calculated columns.html

5. Data Analysis with SQL

1. Filtering data using WHERE and HAVING clauses.mp4

03:14

2. Filtering Data in SQL.html

3. Performing calculations with arithmetic and logical operators.mp4

03:07

4. Performing Calculations with Arithmetic and Logical Operators.html

5. Subqueries and nested queries for complex analysis.mp4

03:05

6. Subqueries and Nested Queries for Complex Analysis.html

6. Introduction to Amazon QuickSight

1. Understanding the features and benefits of QuickSight.mp4

02:57

2.1 AWS setup.html

2. Exploring the QuickSight interface and its components.mp4

02:22

3. Setting up QuickSight and connecting to data sources.mp4

02:32

4. QuickSight Introduction Quiz.html

7. Building Visualisations with QuickSight

1.1 Music Sales Analysis.pdf

1.2 QuickSight visualisation types.pdf

1. Creating basic charts, such as bar charts, line charts, and pie charts.mp4

02:23

2. The QuickSight Basic Charts Quiz.html

3. Formatting and customising visualisations.mp4

02:46

4. Formatting and customising visualisations.html

5. Adding interactivity to dashboards with filters and parameters.mp4

07:11

6. Interactivity in QuickSight.html

8. Advanced Dashboard Creation

1. Designing interactive dashboards with multiple visualisations.mp4

02:10

2. Designing Interactive Dashboards with Multiple Visualisations.html

3.1 Calculated field functions.pdf

3. Creating calculated fields and applying conditional formatting.mp4

04:41

4. Calculated fields and conditional formatting.html

5. Incorporating advanced features like drill-downs and hierarchy navigation.mp4

04:08

6. Drill-downs and hierarchy navigation.html

9. Sharing and Publishing Dashboards

1. Collaborating with other users on QuickSight.mp4

02:17

2. Collaboration in QuickSight.html

3. Publishing dashboards and embedding them in websites or applications.mp4

02:31

4. Publishing and embedding Dashboards.html

5. Scheduling data refreshes and automating dashboard updates.mp4

03:33

6. Scheduling data refreshes.html

10. Conclusions

1. Conclusions.mp4

03:47

2. Test SQL Fundamentals and Dashboard Creation with Amazon QuickSight.html

Description

SQL Fundamentals and Dashboard Creation for beginners

What You'll Learn?

Understand SQL Fundamentals
Master Data Analysis with SQL
Create Interactive Dashboards with Amazon QuickSigh
Publish and Share Dashboards

Who is this 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.

What You Need to Know?

No prior knowledge of SQL or Amazon QuickSight is required. Basic computer literacy and familiarity with spreadsheet software like Microsoft Excel or Google Sheets would be beneficial, but not mandatory.

More details

Description
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!
Who this course is 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.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

SQL Server

MySQL

Paula Roigés

Instructor's Courses

Hello, I'm your course instructor, and I'm thrilled to guide you on this data analysis journey! As a seasoned data analyst, I bring a wealth of experience in SQL, PostgreSQL, and Amazon QuickSight. My passion lies in empowering learners like you to unlock the power of data visualization. Throughout this course, I'll provide you with the support and guidance you need to succeed. Let's explore the world of data together and gain meaningful insights!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.