SQL Fundamentals and Amazon QuickSight

سرفصل های دوره

SQL Fundamentals and Dashboard Creation for beginners

1. Introduction

1. Welcome to the course

2. What youll learn in this course

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

4. Database management system (DBMS).html

2. Introduction to SQL

1. Understanding relational databases and SQL

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.)

4. Writing SQL queries to retrieve and manipulate data

5. SQL environments and queries.html

3. Retrieving Data with SQL

1. SELECT statements and filtering data

2. Customers from USA.html

3. Sorting and limiting query results

4. Top 5 customers.html

5. Working with multiple tables using JOINs

6. Using Inner Joins.html

7. Aggregating data with GROUP BY and aggregate functions

8. Group by.html

4. Modifying and Transforming Data

1. Inserting, updating, and deleting data

2. Modifying Data.html

3. Deleting Data.html

4. Using SQL functions for data transformation

5. Using CONCAT.html

6. Using SUM.html

7. Creating calculated columns and aliases

8. Using Aliases and calculated columns.html

5. Data Analysis with SQL

1. Filtering data using WHERE and HAVING clauses

2. Filtering Data in SQL.html

3. Performing calculations with arithmetic and logical operators

4. Performing Calculations with Arithmetic and Logical Operators.html

5. Subqueries and nested queries for complex analysis

6. Subqueries and Nested Queries for Complex Analysis.html

6. Introduction to Amazon QuickSight

1. Understanding the features and benefits of QuickSight

2.1 AWS setup.html

2. Exploring the QuickSight interface and its components

3. Setting up QuickSight and connecting to data sources

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

2. The QuickSight Basic Charts Quiz.html

3. Formatting and customising visualisations

4. Formatting and customising visualisations.html

5. Adding interactivity to dashboards with filters and parameters

6. Interactivity in QuickSight.html

8. Advanced Dashboard Creation

1. Designing interactive dashboards with multiple visualisations

2. Designing Interactive Dashboards with Multiple Visualisations.html

3.1 Calculated field functions.pdf

3. Creating calculated fields and applying conditional formatting

4. Calculated fields and conditional formatting.html

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

6. Drill-downs and hierarchy navigation.html

9. Sharing and Publishing Dashboards

1. Collaborating with other users on QuickSight

2. Collaboration in QuickSight.html

3. Publishing dashboards and embedding them in websites or applications

4. Publishing and embedding Dashboards.html

5. Scheduling data refreshes and automating dashboard updates

6. Scheduling data refreshes.html

10. Conclusions

1. Conclusions

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

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy