MS SQL Server & Data Source With Tableau | Day 07
What will you learn?
• Understanding the concepts of SQL, Tableau, and use them in problem solving.
• Upgrade your Resume with skills which are in demand
• Understanding the process of Gathering the Data, Analyzing the Data and Visualizing the Data
• Using the Data in way which aids in better Business Decision Making
• Presenting useful insights in the form of metrics, KPIs, reports and Dashboards
• Performing Qualitative and Quantitative Business Analysis
• Understanding the importance of analyzing the Current and Historical Data
• Understanding the Basics of Database theory
• Understanding the working of SQL and using it to create, design and manipulate the Databases
• Fetching required data from a Database.
• Creating insightful visualizations in Tableau
• Visualizing the Data using SQL and Tableau
• Understanding the use of SQL and Tableau in solving real time scenarios
Course Content- Basics and Advanced: Relational Database Theory & Introduction to SQL
Lecture1: Why use SQL?
Lecture2: Introducing Databases
Lecture3: Relational Database Fundamentals
Lecture4: Comparing Databases and Spreadsheets
Lecture5: Important Database Terminology
Lecture6: The Concept of Relational Schemas: Primary Key
Lecture7: The Concept of Relational Schemas: Foreign Key
Lecture8: The Concept of Relational Schemas: Unique Key and Null Values
Lecture9: The Concept of Relational Schemas: Relationships Between Tables
Lecture10: SQL – Install and get to know MySQL
Lecture11: Installing MySQL Workbench and Server
Lecture12: Creating a New User and a New Connection to it
Lecture13: SQL – Best SQL Practices
Lecture14: Coding Tips and Best Practices
Lecture15: SQL – Loading the ’employees’ Database
Lecture16: Loading the ’employees’ Database
Lecture17: Loading the ’employees’ Database
Lecture18: SQL – Practical Application of the SQL SELECT Statement
Lecture19: Using SELECT – FROM
Lecture20: Using WHERE
Lecture21: Using AND
Lecture22: Using OR
Lecture23: Operator Precedence and Logical Order
Lecture30: Using SELECT DISTINCT
Lecture31: Getting to Know Aggregate Functions
Lecture32: Using ORDER BY
Lecture33: Using GROUP BY
Lecture34: Using HAVING
Lecture35: Using WHERE vs HAVING – Part I
Lecture36: Using LIMIT
Lecture37: SQL – Expanding on MySQL Aggregate Functions
Lecture38: Applying COUNT()
Lecture39: Applying SUM()
Lecture40: MIN() and MAX()
Lecture41: Applying AVG()
Lecture42: Rounding Numbers with ROUND()
Lecture43: SQL – SQL JOINs
Lecture44: What are JOINs?
Lecture45: The Functionality of INNER JOIN – Part I
Lecture46: Duplicate Rows
Lecture47: The Functionality of LEFT JOIN – Part I
Lecture48: The Functionality of RIGHT JOIN
Lecture49: Differences between the New and the Old Join Syntax
Lecture50: Using JOIN and WHERE Together
Lecture51: The Functionality of CROSS JOIN
Lecture52: Combining Aggregate Functions with Joins
Lecture53: JOIN More than Two Tables
Lecture54: Top Tips for Joins
Lecture55: The Differences Between UNION and UNION ALL
Lecture56: SQL – SQL Subqueries
Lecture57: SQL Subqueries with IN Embedded Inside WHERE
Lecture58: SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE
Lecture59: SQL Subqueries Nested in SELECT and FROM
Lecture60: SQL – The CASE Statement
Tableau Desktop
Lecture 1: Tableau Desktop – An Idea
Lecture 2: Tableau Desktop – An Introduction
Lecture 3: Map Chart in Tableau
Lecture 4: Scatter Plot in Tableau
Lecture 5: My First Dashboard
Lecture 6: Action Url in Tableau
Lecture 7: Donut chart in Tableau
Lecture 8: Histogram in Tableau
Lecture 9: How to make Histogram dynamic
Lecture 10: Box and Whisker plot – An Intuition
Lecture 11: Box and Whisker plot in Tableau
Lecture 12: Treemap in Tableau
Lecture 13: Dashboard and Story in Tableau
Lecture 14: Introduction to Join
Lecture 15: Data Blending in Tableau
Lecture 16: Data Blending in Tableau – Part 2
Lecture 17: Creating the static sets in Tableau
Lecture 18: Creating the Dynamic sets in Tableau
Lecture 19: Creating the Combined Sets in Tableau
Lecture 20: Adding reference Lines and beautifying the charts
Lecture 21: Finalizing the Dashboard
Lecture 22: Tableau Desktop – Table Calculations
Lecture 23: Tableau – Some more cool features
Lecture 24: Tableau Desktop – Animations and Background Images
Lecture 25: Tableau Desktop – Level of Details
Lecture 26: Tableau Desktop – Custom Charts
Lecture 27: Tableau Desktop – Dashboard Techniques
Lecture 28: Tableau Desktop – Database connectivity
Lecture 29: Tableau Desktop – Integration with R
Lecture 30: Tableau Desktop – How to integrate Tableau with web page
#learning #onlinetraining #elearning #programing #freedemo #analystera #Tableau
Enroll for Course :
DevOps:http://www.analystera.com/course/azur...
Certification:http://www.analystera.com/course/azur...
Excel Reporting:http://www.analystera.com/course/exce...
Python Data Science:http://www.analystera.com/course/pyth...
Tableau:-http://www.analystera.com/course/tabl...
Nesta página do site você pode assistir ao vídeo on-line MS SQL Server & Data Source With Tableau | Day 07 duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Analyst Era 01 Janeiro 1970, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,489 vezes e gostou 11 espectadores. Boa visualização!
