وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 18461
    حجم: 485 مگابایت
    مدت زمان: 93 دقیقه
    تاریخ انتشار: 3 شهریور 1402
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید