Tableau Developer

Tableau certification training program helps you learn Tableau and gets you up to work on the concepts of data visualization with a firm understanding of the Tableau architecture. You will become proficient in the concepts of filters, parameters, maps, graphs, dashboards, and table calculation.

Furthermore, you will learn about data blending, data aggregation, and R connectivity with Tableau in this course. This course covers Tableau Creator functionality required for new Tableau users.

It starts with simple visualisations and moves to an in-depth look at the different chart and graph functions, calculations, mapping and other functionality.

The lessons are organised into modules that provide conceptual information, how-to steps, follow me (where the students follow the instructor using Tableau) and tutorials on each subject.

Course Content:

• SQL
• Introduction to Oracle Database (SQL):
• What is Database
• Why Oracle
• Introduction to SQL and SQL *Plus, More SQL*Plus Commands
• The Data Dictionary
• Data Query Language (DQL):
• Categories of SQL Statements
• Oracle Data types
• The SELECT Statement
• Practical examples
• Data Definition Language (DDL):
• DDL Statements
• The CREATE Statement
• The DROP Command
• The ALTER Command
• Practical examples
• Data Manipulation Language (DML):                                       
• DML Statements,
• The INSERT Statement
• The DELETE Statement
• The UPDATE Statement
• Transaction Control Language (TCL):
• TCL Statements
• COMMIT Statement
• ROLLBACK Statement
• SAVEPOINT Statement
• Data Control Language (DCL):
• DCL Statements
• GRANT Statement
• REVOKE Statement
• Integrity Constraints:
• Introduction to Integrity Constraints
• Categories of Integrity Constraints
• NOT NULL Constraints
• UNIQUE KEY Constraints
• PRIMARY KEY Constraints
• FOREIGN KEY or Referential Integrity Constraints
• CHECK Constraints, Practical examples
• SQL Operators:
• Simple Selects
• Comparison Operators
• IN and NOT IN Operators
• BETWEEN Operator
• The LIKE Operator
• Logical Operators
• IS NULL and IS NOT NULL
• ANY
• ALL
• EXISTS
• Set Operators:
• Introduction
• Selection Criteria
• Union
• Union All
• Intersect
• Minus
• Joining Tables:
• Joins
• Table Aliases
• Cartesian Product
• Inner Joins
• Equi- Join
• Non-Equi Join
• Non-Key Join
• Reflexive / Self Join
• Natural Join
• Outer Joins
• Right Outer Join
• Left Outer Join
• Full Outer Join
• SQL Sub queries:
• Introduction
• Using a Sub query with a DML Statement
• Typical Sub queries
• Sub query Operators
• Standard vs. Correlated Sub queries
• Correlated Sub query
• Groups:
• SQL Statements
• GROUP BY Clause
• HAVING Clause
• Order of a SELECT Statement
• SQL BUILT-IN FUNCTIONS:
• Introduction, Pseudo Columns
• GROUP Functions
• MATHEMATICAL / NUMERIC Functions
• STRING / CHARACTER Functions
• DATE / TIME Functions
• CONVERSION Functions
• MISCELLANEOUS Functions
• More Database Objects:
• More Database Objects
• VIEWS
• SEQUENCE
• SYNONYMS
• Tableau
• Chapter – I: The Tableau Environment The
• Tableau Workspace
• Data Window
• Toolbar, Status Bar
• Tooltips, Cards and Shelves
• Reorganizing the Workspace
• Workbooks and Sheets
• Changing the Repository Location
   
•  
• Chapter – II: Connect to Data
   
•  
• 2. Connect to Data
• How to Connect to a Data Source
• Connect Live/Import
• Editing a Connection
• Replace Data Source
• Replacing Field References
• Renaming the Connection
• Duplicating the Connection
• Refreshing the Data
• Closing the Connection
• Clipboard Data Sources
• Number of Records
• Latitude and Longitude,
• Measure Names
• Data Types and Roles 
• Data Types
• Data Roles
• Joining Tables
• Adding Tables
• Editing Tables
• Custom SQL
• Working with Multiple Connections
• Understanding Data Blending
• Adding a Secondary Connection
• Defining/Edit Relationships
• Data Window Features and Functions
• Folders
• Sort
• Find Fields
• Rename Fields
• Combine Fields
• Hide or Unhide Fields
• Add Fields to the Data Window (calculation field)
• Editing Field Properties 
• Comments
• Aliases
• Hierarchies
• Colors
• Shapes
• Formats
• Sort & bull; Aggregation
• Grouping
• Sets
• Aggregation & Disaggregation