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...
On this page of the site you can watch the video online MS SQL Server & Data Source With Tableau | Day 07 with a duration of hours minute second in good quality, which was uploaded by the user Analyst Era 01 January 1970, share the link with friends and acquaintances, this video has already been watched 1,489 times on youtube and it was liked by 11 viewers. Enjoy your viewing!
