Tableau Training

100% Practical Training course with Realtime Project. This Tableau Training course includes Basic to Advanced Visualizations, Data Modelling, Big Data Access, API Integrations, Groups, Bins, Sets, Filters, Sets, Calculations, Functions, Table Expressions, LOD (Level Of Detail), Custom Layouts, Cloud Colloborations, Actions, Dashboards, Stories, Tableau Server, Tableau Online, Alerts, Subscriptions and Tableau Prep Compponents for ETL and End to End implementations in Realworld.

Pre-Requisites : Basic knowledge on SQL is mandatory. If you are new to Database, please opt for Plan B or Plan C below.

Tableau Training Plans

	PLAN A	PLAN B	PLAN C
Description	Tableau	PLSQL & Tableau	PLSQL, Tableau & Python
Course Duration	4 Weeks	8 Weeks	12 Weeks
Completely Real-time, Practical	✔	✔	✔
Tableau Desktop & Reports	✔	✔	✔
Groups, Sets, Hierarchies	✔	✔	✔
Filters, LOD Expressions	✔	✔	✔
Actions, Bookmarks, Calc	✔	✔	✔
Tableau Prep and ETL	✔	✔	✔
Tableau Server, Online	✔	✔	✔
Table Admin & Security	✔	✔	✔
Dashboards & Worksheets - Security	✔	✔	✔
Tableau : Real-time Project	✔	✔	✔
SQL : Basic SQL, SQL Server Concepts	❌	✔	✔
PL-SQL : Queries, Joins, Group By	❌	✔	✔
PL-SQL : Queries, SProcs, Lock Hints	❌	✔	✔
PL-SQL: Queries, Normal Forms, Excel	❌	✔	✔
Python: Modules	❌	❌	✔
Python: Detailed Design of Interactive	❌	❌	✔
Python: Python Dictionary	❌	❌	✔
Python: Introduction to Web	❌	❌	✔
Python: GUI Programming-Tkinter	❌	❌	✔
Total Course Fee *	INR 15,000 USD 203	INR 21,000 USD 284	INR 27,000 USD 365

S No	Timings (IST)	Start Date
Tableau Training Schedules
1	8:30 AM - 9:30 AM	Feb 15th	Register
2	8:30 AM - 10:30 AM (W)	Mar 11th	Register

S No	Time (IST, Mon - Fri)	Start Date
Oracle SQL & PL-SQL Training Schedules
1	6:30 AM - 7:30 AM	Feb 2nd	Register
2	8:30 AM - 9:30 AM	Feb 21st	Register
3	10:30 AM - 11:30 AM	Feb 15th	Register
4	6:30 PM - 7:30 PM	Jan 31st	Register
5	8:30 AM - 10:30 AM (W)	Feb 4th	Register

S No	Time (IST, Mon - Fri)	Start Date
Python Training Schedules
1	7:30 AM - 8:30 AM	Feb 28th	Register
2	5:30 PM - 6:30 PM	Mar 7th	Register

Tableau Training Highlights :

Advanced Reporting Concepts	Paginated Reports
Detailed Design of Interactive	Data Formatting
Advanced Visualizations	Data Access Operations
Dynamic Data Acces	Parameterized Connections
Cloud (Service) with Reports	Dashboards & Apps
Tableau Server Configuration	Data Refresh Options
Project for your Resume	Excel, Database Sources

If above schedule does not work, opt for Tableau Training Videos

Tableau Training Course Contents:

Brochure Download:

Register Today

Module 1 : Oracle SQL & PL-SQL Queries [For Plans B, C]

Module 1: Basic SQL	Module 2: SQL & PL SQL	Module 3: Adv PLSQL
CHAPTER 1 : INTRODUCTION TO DBMS What is Data and Information? Purpose of Data Management File and File System For Data Storage Disadvantages of File Data Management Database : Purpose, Basic Terminology Advantages of Database for Data Storage Possible Operations on the Database Database Models – Hierarchical Model Network Model and Relational Model Introduction to DBMS Introduction to RDBMS Database Design Most Popular RDBMS Products History, Real-time Database Examples (LIVE)	CHAPTER 7 : CONSTRAINTS & KEYS Importance of Data Integrity Working with Integrity constraints Types of Integrity Constraints Domain Integrity Constraint and Usage Entity Integrity Constraints and Usage Referential Integrity Constraint and Usage Check Constraints and Usage NOT NULL Constraint, UNIQUE Constraint PRIMARY KEY Constraint and Usage FOREIGN KEY Constraints and Relations Column Level & Table Level Constraints Adding Constraints to Tables, User_Constraints Enabling - Dropping Constraints, Self Referential Integrity Disabling Constraints on Tables	CHAPTER 13 : PL/SQL – (CONTROL STRUCTURE) - Level I Simple If, If..Else. Nested If..Else Statements Ladder, Selection, Simple Case Statements GOTO Label and EXIT Statements in PL/SQL Iterations in PL/SQL, Simple LOOP, WHILE FOR LOOP and NESTED LOOPS in PLSQL PL/SQL Select statements SQL within PL/SQL, Composite Data Types Cursor Variables and Management in PL/SQL Implicit & Explicit Cursors and Attributes Cursor with Parameters and Nested LOOPs Cursors with Sub Queries, Reference Cursors Implicit Cursors,Explicit Cursor Parameterized Cursors,Ref Cursors REF Cursors
CHAPTER 2: ORACLE INSTALLATION Oracle 2018 Installation Guidance Oracle 2012 Installation Installation Pre-Requisites and Precautions Oracle Sql Developer Oracle Sql Command prompt Oracle Versions and Editions Comparisions Connect Sql Developer Tool Creating a new User Grant permission Lock and Unlock User Account How to Reset User Account Password SQL* Plus How to Establish the Oracle Connection Default System user in Oracle Default Sysdba user in Oracle	CHAPTER 8 : QUERIES & JOINS Need for Joins and Table Comparisons SET Operations on Tables and Joins Join Types : Equi Join, Simple Join Inner Join and Query Conditions Cross Join (Cartesian Join), Conditions Join syntax - Sql syntax and Ansi Syntax Non-Equi Join and Self Join Outer Joins – Types, Advantages and Usage Cross Joins – Advantages and Limitations Self Joins, Merge Joins and Sub Queries Using Aliases in Joins and Conditions Using Inner Self Joins with HAVING JOINS and GROUP BY Queries	CHAPTER 14: ADVANCED PL/SQL - 1 Procedures in PL/SQL: STORED PROCEDURE PROCEDURES @ Parameters (IN, OUT, IN OUT) POSITIONAL Notation and NAMED Notation Procedure with Cursors and Sub Queries ALTER and DROP of Stored Procedures Functions in PL/SQL: Real-time Usage User Defined Functions, Nested Functions Using Functions in SQL Statements Working with Procedures and Functions Comparing Stored Procedures and Functions Using SPs with Table Value Functions Using SPs for Dynamic SQL Statements Loops and Table Variables in SQL Programs Merge, NVL2(), NULLIF(), COALESCE() CASE & Temporary /Global Tables
CHAPTER 3: INTRODUCTION TO RDBMS Features of RDBMS Advantages of RDBMS E.F Codd Rules for RDBMS Normalization Concepts & Process Client Server Communication Oracle Corporation Products RDBMS from Other Vendors: Microsoft, IBM,etc Oracle Versions about SQL & SQL*PLUS Database Types: OLTP and OLAP Databases Real-world Advantage of OLTP & OLAP Why a database is called as Relational Database Model Database Entites and Attributes Applicative use of RDBMS Databases	CHAPTER 9 : VIEWS, SYNONYMS,SEQUENCES VIEWS IN ORACLE, Understanding Views & Use Relational Views and Standard Views SIMPLE VIEWS and COMPLEX VIEWS in PLSQL Column Definitions in VIEWS Using VIEWS for DML Operations Forced Views, CHECK Constraints in Views Creation of READ ONLY VIEWS - Realtime Use TOP-N Analysis, (Indexed) Materialized Views SequenWorking ces, with Synonyms What is the Use of Synonym in Oracle? Difference between View and Synonym in Oracle When should Table Synonyms be used? Public Synonym and Private Synonyms All_Synonyms and Dba_Synonyms System Tables Creating Index Tables – Purpose	CHAPTER 15 : ADVANCED PL/SQL - 2 Cross Tab Views using Pivot/Unpivot Operators Follows Clause and READONLY Tables IN-LINE VIEWS. Manipulations with Triggers Purity Levels in Oracle - with Examples User_Source Dictionary Table Packages Creating PACKAGE Specifications with PLSQL PACKAGE Body - Examples with Big Data Tables Private and Public Objects in PACKAGE Types of Exceptions: User Defined Exceptions EXCEPTIONS in PL/SQL with Real-time Event Handling and Error Handling Techniques Important Error Code Values in PL/SQL RAISE_APPLICATION_ERROR Procedure
CHAPTER 4 : SQL LANGUAGE COMMANDS Structured Query Language (SQL) Basics What is SQL? What Can SQL do? Possible Operations with SQL Data Definition Language (DDL) Data Retrieval Language (DRL) Data Manipulation Language (DML) Transaction Control Language (TCL) Database Security and Privileges (DCL) Rules of SQL Queries and Statements Real-world applicative uses of SQL Creating Users and Tables Table Data Inserts and Validations Oracle Data Types DDL Commands with Examples CREATE, ALTER, TRUNCATE,DROP,RENAME Learn the DESCRIBE command to display the table structure DML Command DRL Commands Operators INSERT, UPDATE, DELETE Statements Difference between Truncate and Delete commands SELECT Statements with Multiplier SQL Comments Single Line Comments & Multi Line Comments WHERE Keyword for Query Conditions	CHAPTER 10 : SUB QUERIES, NESTED QUERIES Sub Queries in Real-world Dynamic Conditions with Sub Queries Sub Queries and Nested Sub Queries How does oracle Execute Nested Sub Queries? Inner Select and Outer Select Queries Usage of Sub Queries with WHERE, HAVING Impact of Having Clause in Sub Queries Select Nth Highest salary Select Duplicate Records Delete Duplicate Records Advantages of Oracle Sub Query Subquery in the Select Clause Examples Subquery in the From Clause Examples Display Odd Rows in a table Display Even Rows in a table Execution of Correlated Sub Queries in SQL IN, ANY SOME, ALL Operators in Sub Queries PAIR WISE and NON PAIR WISE in Sub Queries Single Row Subquery & Multiple Row Subquery Multiple Column Subquery UnCorrelated Subquery Difference between Correlated and Non-Correlated Subquery How does Oracle Execute Correlated Subquery? NULLs and Correlated Sub Queries in SQL	CHAPTER 16 : ADVANCED PL/SQL - 3 Pragma_Autonomous_Transaction() with SPs Returning into clause, Bulk Collect For All, Definer/Invoker Rights & Usage About Flash Back Queries, Dynamic SQL Flash Back Command, Purge Command Regular Expressions in PLSQL What is the Recycle Bin? How to Delete RecycleBin Table? How to Delete Recycle Bin? SQL Loader - Flat file into Oracle table Abstract Datatypes DML Error Logging and Virtual Columns Types of Triggers, Row Level Triggers Statement Level Triggers, DML Triggers DDL Triggers and Schema Level Triggers Using OLD & NEW References, Trigger Auditing Enabling / Disabling Triggers, Dropping Triggers Triggers in PL/SQL and Data Manipulations Using Memory Tables in Triggers DML and DDL Events with Triggers Compound Triggers, New data types Working with LARGE Tables in PLSQL New: EXTRACT(), Autonomous Transaction Pragma Exception_init in oracle
CHAPTER 5.SQL SPECIAL OPERATORS SET, AND, OR, NOT, IN Special Operators – IN (NOT IN) BETWEEN (NOT BETWEEN), Arithmetic and Logical Operators Understand Operator Precedence UNION, UNION ALL, INTERSECT, MINUS LIKE (NOT LIKE), IS NULL (IS NOT NULL) Understanding DCL and TCL Commands Transaction Concepts in Databases with SQL Transaction Types and Uses Commit and Rollback Operations Nested Transactions with Savepoints Database Read Consistency with SQL DDL and DML Operations with Transactions	CHAPTER 11: LOCKS in ORACLE TABLES Open Transactions and Lock Concepts Lock Types and Locking Mechanism Row Level Locks for Table Data Access Table Level Locks and Query Blocking Shared Lock and Real-time Use Shared Update Lock and Real-time Use Exclusive Lock and Real-time Use DeadLock : Detection, Prevention, Avoidance Implicit Locking Concepts in Oracle with PLSQL How to check howmany locks are occured? LOCK Hints and Query Blocking What is row exclusive lock in Oracle? What is lock in SQL? What are different types of locks?	CHAPTER 17: OBJECT TECHNOLOGY – Level I Object Technology and Applicative Use OOPS-Object Instances, Creation of Objects Creating User Defined Data Types Creating Object Tables in Oracle Inserting rows in Table using Object Retrieving data from Object Based Tables Calling a Method, Indexing Abstract Data type Attributes in PLSQL Advantages of Collections Ref Cursor (Dynamic Cursor), Weak Ref Cursor Strong Ref Cursors and Nested Tables Associative Arrays, VARRAYS/VARYING arrays Creating tables using Nested Tables Inserting, Updating & Deleting Nested, Table Records
CHAPTER 6: GROUPING QUERY RESULTS Identify Distinct Values in Tables Group Function or Aggregate function Group By Syntax Group By Operations in Queries Having Clause of DRL Statements Aggregate Functions with Group By Order By Clause and Group By SQL Group By Statement Query Execution Order with Group By Arithmetic Functions,Character Function Date & Time Functions,String Function Conversion Functions,Analytical Function Rank(), Dense_Rank(),Row_Number() NVL(),NVL2(), NullIF(),Coalesce()	CHAPTER 12 : PERFORMANCE (QUERY) TUNING Indexes - Definition and Architecture B Tree Concept in Indexes Clustered and Non clustered Indexes Primary Key and Clustered Index Unique Key and Non Clustered Indexes Simple Index, Rebuild Index Materialized Views - Indexed Views Composite Index, Function Based Index User_indexes System Table Range Partitions and Hash Partition Partion “VALUES LESS THAN “ Clause List Partition and Composite Partition Parallel Query Process with Partitions Performance Tuning Advantages	CHAPTER 18: OBJECT TECHNOLOGY – Level II Perform a Basic Search using the REGEXP_LIKE function patterns using the REGEXP_INSTR function Extract Substrings using the REGEXP_SUBSTR function Replace Patterns Using the REGEXP_REPLACE Invisible Columns in Oracle Database 12c What is fetch in SQL? Can we use limit in Oracle? What is offset in Oracle? Is PL SQL object oriented? What is Oracle object type? What is object type in Oracle PL SQL? Is Oracle object oriented database? What is PL SQL in Oracle? What is Oracle constructor?

Module 1: Basic SQL

Module 2: SQL & PL SQL

Module 3: Adv PLSQL

CHAPTER 1 : INTRODUCTION TO DBMS

What is Data and Information?
Purpose of Data Management
File and File System For Data Storage
Disadvantages of File Data Management
Database : Purpose, Basic Terminology
Advantages of Database for Data Storage
Possible Operations on the Database
Database Models – Hierarchical Model
Network Model and Relational Model
Introduction to DBMS
Introduction to RDBMS
Database Design
Most Popular RDBMS Products
History, Real-time Database Examples (LIVE)

CHAPTER 7 : CONSTRAINTS & KEYS

Importance of Data Integrity
Working with Integrity constraints
Types of Integrity Constraints
Domain Integrity Constraint and Usage
Entity Integrity Constraints and Usage
Referential Integrity Constraint and Usage
Check Constraints and Usage
NOT NULL Constraint, UNIQUE Constraint
PRIMARY KEY Constraint and Usage
FOREIGN KEY Constraints and Relations
Column Level & Table Level Constraints
Adding Constraints to Tables, User_Constraints
Enabling - Dropping Constraints, Self Referential Integrity
Disabling Constraints on Tables

CHAPTER 13 : PL/SQL – (CONTROL STRUCTURE) - Level I

Simple If, If..Else. Nested If..Else Statements
Ladder, Selection, Simple Case Statements
GOTO Label and EXIT Statements in PL/SQL
Iterations in PL/SQL, Simple LOOP, WHILE
FOR LOOP and NESTED LOOPS in PLSQL
PL/SQL Select statements
SQL within PL/SQL, Composite Data Types
Cursor Variables and Management in PL/SQL
Implicit & Explicit Cursors and Attributes
Cursor with Parameters and Nested LOOPs
Cursors with Sub Queries, Reference Cursors
Implicit Cursors,Explicit Cursor
Parameterized Cursors,Ref Cursors
REF Cursors

CHAPTER 2: ORACLE INSTALLATION

Oracle 2018 Installation Guidance
Oracle 2012 Installation
Installation Pre-Requisites and Precautions
Oracle Sql Developer
Oracle Sql Command prompt
Oracle Versions and Editions Comparisions
Connect Sql Developer Tool
Creating a new User
Grant permission
Lock and Unlock User Account
How to Reset User Account Password
SQL* Plus
How to Establish the Oracle Connection
Default System user in Oracle
Default Sysdba user in Oracle

CHAPTER 8 : QUERIES & JOINS

Need for Joins and Table Comparisons
SET Operations on Tables and Joins
Join Types : Equi Join, Simple Join
Inner Join and Query Conditions
Cross Join (Cartesian Join), Conditions
Join syntax - Sql syntax and Ansi Syntax
Non-Equi Join and Self Join
Outer Joins – Types, Advantages and Usage
Cross Joins – Advantages and Limitations
Self Joins, Merge Joins and Sub Queries
Using Aliases in Joins and Conditions
Using Inner Self Joins with HAVING
JOINS and GROUP BY Queries

CHAPTER 14: ADVANCED PL/SQL - 1

Procedures in PL/SQL: STORED PROCEDURE
PROCEDURES @ Parameters (IN, OUT, IN OUT)
POSITIONAL Notation and NAMED Notation
Procedure with Cursors and Sub Queries
ALTER and DROP of Stored Procedures
Functions in PL/SQL: Real-time Usage
User Defined Functions, Nested Functions
Using Functions in SQL Statements
Working with Procedures and Functions
Comparing Stored Procedures and Functions
Using SPs with Table Value Functions
Using SPs for Dynamic SQL Statements
Loops and Table Variables in SQL Programs
Merge, NVL2(), NULLIF(), COALESCE()
CASE & Temporary /Global Tables

CHAPTER 3: INTRODUCTION TO RDBMS

Features of RDBMS
Advantages of RDBMS
E.F Codd Rules for RDBMS
Normalization Concepts & Process
Client Server Communication
Oracle Corporation Products
RDBMS from Other Vendors: Microsoft, IBM,etc
Oracle Versions about SQL & SQL*PLUS
Database Types: OLTP and OLAP Databases
Real-world Advantage of OLTP & OLAP
Why a database is called as Relational Database Model
Database Entites and Attributes
Applicative use of RDBMS Databases

CHAPTER 9 : VIEWS, SYNONYMS,SEQUENCES

VIEWS IN ORACLE, Understanding Views & Use
Relational Views and Standard Views
SIMPLE VIEWS and COMPLEX VIEWS in PLSQL
Column Definitions in VIEWS
Using VIEWS for DML Operations
Forced Views, CHECK Constraints in Views
Creation of READ ONLY VIEWS - Realtime Use
TOP-N Analysis, (Indexed) Materialized Views
SequenWorking ces, with Synonyms
What is the Use of Synonym in Oracle?
Difference between View and Synonym in Oracle
When should Table Synonyms be used?
Public Synonym and Private Synonyms
All_Synonyms and Dba_Synonyms System Tables
Creating Index Tables – Purpose

CHAPTER 15 : ADVANCED PL/SQL - 2

Cross Tab Views using Pivot/Unpivot Operators
Follows Clause and READONLY Tables
IN-LINE VIEWS. Manipulations with Triggers
Purity Levels in Oracle - with Examples
User_Source Dictionary Table Packages
Creating PACKAGE Specifications with PLSQL
PACKAGE Body - Examples with Big Data Tables
Private and Public Objects in PACKAGE
Types of Exceptions: User Defined Exceptions
EXCEPTIONS in PL/SQL with Real-time
Event Handling and Error Handling Techniques
Important Error Code Values in PL/SQL
RAISE_APPLICATION_ERROR Procedure

CHAPTER 4 : SQL LANGUAGE COMMANDS

Structured Query Language (SQL) Basics
What is SQL?
What Can SQL do?
Possible Operations with SQL
Data Definition Language (DDL)
Data Retrieval Language (DRL)
Data Manipulation Language (DML)
Transaction Control Language (TCL)
Database Security and Privileges (DCL)
Rules of SQL Queries and Statements
Real-world applicative uses of SQL
Creating Users and Tables
Table Data Inserts and Validations
Oracle Data Types
DDL Commands with Examples
CREATE, ALTER, TRUNCATE,DROP,RENAME
Learn the DESCRIBE command to display the table structure
DML Command DRL Commands Operators
INSERT, UPDATE, DELETE Statements
Difference between Truncate and Delete commands
SELECT Statements with Multiplier
SQL Comments
Single Line Comments & Multi Line Comments
WHERE Keyword for Query Conditions

CHAPTER 10 : SUB QUERIES, NESTED QUERIES

Sub Queries in Real-world
Dynamic Conditions with Sub Queries
Sub Queries and Nested Sub Queries
How does oracle Execute Nested Sub Queries?
Inner Select and Outer Select Queries
Usage of Sub Queries with WHERE, HAVING
Impact of Having Clause in Sub Queries
Select Nth Highest salary
Select Duplicate Records
Delete Duplicate Records
Advantages of Oracle Sub Query
Subquery in the Select Clause Examples
Subquery in the From Clause Examples
Display Odd Rows in a table
Display Even Rows in a table
Execution of Correlated Sub Queries in SQL
IN, ANY SOME, ALL Operators in Sub Queries
PAIR WISE and NON PAIR WISE in Sub Queries
Single Row Subquery & Multiple Row Subquery
Multiple Column Subquery
UnCorrelated Subquery
Difference between Correlated and Non-Correlated Subquery
How does Oracle Execute Correlated Subquery?
NULLs and Correlated Sub Queries in SQL

CHAPTER 16 : ADVANCED PL/SQL - 3

Pragma_Autonomous_Transaction() with SPs
Returning into clause, Bulk Collect
For All, Definer/Invoker Rights & Usage
About Flash Back Queries, Dynamic SQL
Flash Back Command, Purge Command
Regular Expressions in PLSQL
What is the Recycle Bin?
How to Delete RecycleBin Table?
How to Delete Recycle Bin?
SQL Loader - Flat file into Oracle table
Abstract Datatypes
DML Error Logging and Virtual Columns
Types of Triggers, Row Level Triggers
Statement Level Triggers, DML Triggers
DDL Triggers and Schema Level Triggers
Using OLD & NEW References, Trigger Auditing
Enabling / Disabling Triggers, Dropping Triggers
Triggers in PL/SQL and Data Manipulations
Using Memory Tables in Triggers
DML and DDL Events with Triggers
Compound Triggers, New data types
Working with LARGE Tables in PLSQL
New: EXTRACT(), Autonomous Transaction
Pragma Exception_init in oracle

CHAPTER 5.SQL SPECIAL OPERATORS

SET, AND, OR, NOT, IN
Special Operators – IN (NOT IN)
BETWEEN (NOT BETWEEN),
Arithmetic and Logical Operators
Understand Operator Precedence
UNION, UNION ALL, INTERSECT, MINUS
LIKE (NOT LIKE), IS NULL (IS NOT NULL)
Understanding DCL and TCL Commands
Transaction Concepts in Databases with SQL
Transaction Types and Uses
Commit and Rollback Operations
Nested Transactions with Savepoints
Database Read Consistency with SQL
DDL and DML Operations with Transactions

CHAPTER 11: LOCKS in ORACLE TABLES

Open Transactions and Lock Concepts
Lock Types and Locking Mechanism
Row Level Locks for Table Data Access
Table Level Locks and Query Blocking
Shared Lock and Real-time Use
Shared Update Lock and Real-time Use
Exclusive Lock and Real-time Use
DeadLock : Detection, Prevention, Avoidance
Implicit Locking Concepts in Oracle with PLSQL
How to check howmany locks are occured?
LOCK Hints and Query Blocking
What is row exclusive lock in Oracle?
What is lock in SQL?
What are different types of locks?

CHAPTER 17: OBJECT TECHNOLOGY – Level I

Object Technology and Applicative Use
OOPS-Object Instances, Creation of Objects
Creating User Defined Data Types
Creating Object Tables in Oracle
Inserting rows in Table using Object
Retrieving data from Object Based Tables
Calling a Method, Indexing Abstract
Data type Attributes in PLSQL
Advantages of Collections
Ref Cursor (Dynamic Cursor), Weak Ref Cursor
Strong Ref Cursors and Nested Tables
Associative Arrays, VARRAYS/VARYING arrays
Creating tables using Nested Tables
Inserting, Updating & Deleting
Nested, Table Records

CHAPTER 6: GROUPING QUERY RESULTS

Identify Distinct Values in Tables
Group Function or Aggregate function
Group By Syntax
Group By Operations in Queries
Having Clause of DRL Statements
Aggregate Functions with Group By
Order By Clause and Group By
SQL Group By Statement
Query Execution Order with Group By
Arithmetic Functions,Character Function
Date & Time Functions,String Function
Conversion Functions,Analytical Function
Rank(), Dense_Rank(),Row_Number()
NVL(),NVL2(), NullIF(),Coalesce()

CHAPTER 12 : PERFORMANCE (QUERY) TUNING

Indexes - Definition and Architecture
B Tree Concept in Indexes
Clustered and Non clustered Indexes
Primary Key and Clustered Index
Unique Key and Non Clustered Indexes
Simple Index, Rebuild Index
Materialized Views - Indexed Views
Composite Index, Function Based Index
User_indexes System Table
Range Partitions and Hash Partition
Partion “VALUES LESS THAN “ Clause
List Partition and Composite Partition
Parallel Query Process with Partitions
Performance Tuning Advantages

CHAPTER 18: OBJECT TECHNOLOGY – Level II

Perform a Basic Search using the REGEXP_LIKE function
patterns using the REGEXP_INSTR function
Extract Substrings using the REGEXP_SUBSTR function
Replace Patterns Using the REGEXP_REPLACE
Invisible Columns in Oracle Database 12c
What is fetch in SQL?
Can we use limit in Oracle?
What is offset in Oracle?
Is PL SQL object oriented?
What is Oracle object type?
What is object type in Oracle PL SQL?
Is Oracle object oriented database?
What is PL SQL in Oracle?
What is Oracle constructor?

Module 2: Tableau Training Content [For Plans A, B, C]

Part 1: Tableau Report Design - 1	Part 2: Tableau Report Design - 2	Part 3: Tableau Prep, Server, Online
Ch 1 : TABLEAU INTRO, INSTALLATION Introduction to Tableau, Reporting Tools Report Types in Real-time: Interactive Paginated, Analytical and Mobile Reports Data Sources for Report Design Process Databases & Types: OLTP, DWH, OLAP Tableau : Basic Understanding, Workflow Tableau as a Self Service BI Tool Tableau Features, Technical Advantages Tableau Public Desktop : Installation Development, Production and Access Data Sources Types in Tableau Tableau Prep Tools - Data Modelling Power BI Licensing Plans - Types Tableau Training : Course Plan, Lab Study Material, Certifications, FAQs	Ch 7 : TABLEAU VIZ - LEVEL 1 Tableau Visualizations - Types Visualization Categories, Usage Tableau Bar Charts and Types Simple Bar Charts and Usage Horizontal & Colored Bar Charts Stacked Bar Charts, Measures Side By Side Bar Charts and Use Interactive Bar Charts & Filters Line Charts and Data Points Continous Line Charts and Usage Discrete Line Charts and Usage Dual Line Chart and Types Area Charts : Discrete, Continous Stacked Area Charts, Reports Combine Area Charts & Line Charts	Ch 13 : DASHBOARDS & STORIES Dashboards and Stories in Tableau Bulding Dashboards - Views, Sheets Dashboard Size, Views, Objects Legends and Quick Filters in Tableau Tiles, Floating Layouts in Tableau Layout Containers, Images, Web Pages Dashboard Extensions, Management API Extensions - Usage in Tableau Device Designer - Default Layout Adding and Customizing Layouts Story Points - Creation and Updates Bollinger Bands - Views, Summary Data Cleansing - Bulk Re-aliasing Tableau Prep : Installation ETL Tableau Desktop Store, Server Store
Ch 2: BASIC REPORTS, GROUPING Tableau Public Desktop : Installation Tableau Workbook Creation, Data Sources Tableau Worksheets : Creation, Options Row Shelf & Column Shelf, Details View Marks : Text, Detail, Tooltip, Colors VizQL : Vizualization Query Language Tableau In-Memory Database Usage Dimensions, Measures Identification Working with Data Sources, WorkBooks Worksheets, Marks, Shelves, Axis Basic Report Design Terminology Grouping : Data Categorization Creating Groups on Static Data Dynamic Data Grouping, Binnig Hierarchies: Creation, Real-time Use Drilldown Reports in Tableau	Ch 8 : TABLEAU VIZ - LEVEL 2 Tableau Pie Charts, Real-time Use Simple Pie Charts - Examples Stacked Pie Charts - Examples Side By Side Pie Charts Reverse Rows and Row Count Donut Charts and Agle Properties Inner / Outer Pie Charts, Stacking Drill-down Pie Charts and Usage CrossTab Charts and Text Properties Rows, Columns and Marks : Text Conditional Formatting, Divergence Using Quick Claculations in Tableau Highlight Tables and Color Palettes Box & Wishker Plots - Text Tables Heat Maps and Real-time Usage Size Controls and Color Options	Ch 14 : TABLEAU SERVER Tableau Server - Architecture Tableau Server - Installation Process Publish Tableau Workbook, Verify Sharing Options and Layouts Adding Device Layouts in Tableu Server Adding Custom Layouts in Tableau Server Adding Content to Custom Layouts Java Script API in Table Server Tableau Online Versus Table Server Security Advantages @ Tableau Server Tableau Online - Architecture Publish Tableau Workbook, Verify Sharing Options and Layouts Adding Device Layouts in Tableu Online Adding Custom Layouts in Tableau Online Adding Content to Custom Layouts Security Advantages @ Tableau Online
Ch 3 : TABLEAU ARCHITECTURE, JOINS Data Sources, Connectors, Clients Tableau Server Components and Use Application Server and Repository VizQL Server and Data Engine Backgrounder, Data Server, Search Fast Data Engine, Gateway Components Alias, Bins, Bookmarks, Calcualtions Tableau File Types and Workbooks CrossTabs, Dashboards, Data Pane Data Source Page and Dimensions Extract, Filters, Pages, Rows, Columns Visual Sync Limitations with Slicer Level of Detail, Sets, Marks, Workbooks Using Joins in Tableau Sources Inner, Left / Right Outer Joins	Ch 9 : TABLEAU VIZ - LEVEL 3 Tableau Treemaps & Nested Rectangles Marks Type, Color, Size and Label Comparing Treemaps with Bars & Tables Circle View Vizualization and Usage Side By Side Circle View, Usage Scatter Plot - Labels, Axis Items Packed Bubbles and Circles - Lables Tableau Symbol Maps - Examples Tableau Filled Maps - Examples Using Quick Table Calculations Histogram Charts and Properties Measures and Value Comparisions Tableau Motion Charts and Axis Bullet Graphs and Limitations Dimension - Measure Considerations	Ch 15 : Colloborate TABLEAU ONLINE Tableau Online - Purpose, LIVE Reports Projects and Workbooks in Tableau Online Tableau Report Views in Tableau Online Searching Content, Data Sources, Sites Account Settings, Drill Down, Actions Custom Views, Comments - Tableau Online Downloads, Exports - Tableau Online Sharing, Subscription and favorites Web Authoring, Edits and Publish Online Data Driven Alerts - Refining, Managing Stacked Bars and Views For Alerting Navigations, Snapshots, Searching Mobile Reports - Phone Marks and Maps Interacting with Content on Tableau Online
Ch 4 : BIG DATA ACCESS, BLENDING Azure Data Access with Tableau Remote Data Sources and Joins Using SQL Queries in Tableau Use Azure SQL Warehouse (DWH) Data Blending Options in Tableau Working with Multiple Data Sources Data Combinations & Aggregations Show Data & Data Grouping Options Tableau Operators and Types Tableau Functions and Real-time Use Tableau Calculations and Formats Numerical Calculatins & Examples Aggregated Calculations in Tableau Creating Calculations From Shelfs Calculation Edits, Identifications	Ch 10 : TABLEAU FILTERS Tableau Filters - Types & Usage Extract Filters and TDE (hyper) Data Source Filters (twb Files) String and Numerical Data Fields Date/ Time Data Fields, Usage All Rows, Too & Bottom Rows Aggregated Extracts and Usage Extract History, TDE Files Context Fitlers and Realtime Use Context Filters: Performance Benefit Dimension Filters & Limitations Measure Filters and Aggregations Measure Name Filters, Measure Values Table Calculation Filters, Usage Tableau Filters - Execution Order Fiters Scope and Quick Filters	Ch 16: Colloborate TABLEAU SERVER Tableau Server - Purpose, LIVE Reports Projects, Workbooks in Tableau Server Tableau Report Views in Tableau Server Searching Content, Data Sources, Sites Account Settings, Drill Down, Actions Custom Views, Comments in Tableau Server Downloads and Exports in Tableau Server Sharing, Subscription and favorites Web Authoring, Edits and Publish Online Data Driven Alerts - Refining, Managing Stacked Bars, Alerting Views in Server Navigations, Snapshots, Searching in Server Mobile Reports - Phone Marks and Maps Interacting with Content on Tableau Server
Ch 5 : STRING, DATE FUNCTIONS String Functions in Tableau ASCII, CHAR, LEN, ENDSWITH FIND, FINDNTH, LEFT, CONTAINS LOWER, UPPER, LTRIM, RTRIM MID, MIN, REPLACE, RIGHT SPACE, SPLIT, UPPER, MAX STARTSWITH, AND, CASE ELSE, ELSEIF, END, IF, IIF IFNULL, ISDATE, ISNULL, MAX MIN, NOT, OR, THEN, WHEN, ZN DATEADD, DATEDIFF, DATENAME DATEPART, DATETRUNC, DAY ISDATE, MAKEDATE, MONTH NOW, QUARTER, TODAY, YEAR	Ch 11 : PARAMETERS, SETS Tableau Parameters - Working Creating Parameters, Conditions Linking Parameters to Calculations Using Calculations in Fields/View Dynamic Filters using Parameters Dynamic Dimension using Parameters Dynamic Measures using Parameters Creating, Using Sets in Tableau IN and OUT Concepts in Sets Working with Filters and Sets Show Set Options and Exclude Comparing Tableau Sets & Groups Comparing Tableau Sets & Hierarchies Dynamic Sets : Creation & Usage	Ch 17 : MANAGE TABLEAU SERVER Tableau Server - Administration Concepts Tableau Sites, Users, Groups Security Group Rules, Web Edits in Tableau Server Project Permission and Locking Options Data Security with user Filters in Server user Filters and Hybrid Models in Server Access Roles, Schedules, Extraction TSM : Tableau Services Manager TSM Configuration for Real-time Use Browser, Maintenance, GUI and CLI Backups and Restores with Tableau TSM TSM Upgrades For Tableau Report Config Tabcmd : Command Line Utility - Imports Tabcmd : user Import via CSV File Comparing Tableau & Microsoft Power BI
Ch 6 : TABLE, LOD CALCULATIONS Calcualtions For Year, Quarter, Month Custom Calculations, Data Appending Custom Date and Time Formatting Calculations Reuse and Edits Date and Time Conversions To INT Two Digit Conversions with Date Table Functions with Tableau Running Total and Row Number Case Statements, FIRST, LOOKUP Table Calculations, Level of Details Real-time Use of Table Calculations Partitioning, Addressing Benefits LOD : Types of Level Of Detail FIXED LOD Expressions - Examples INCLUDE LOD Expressions - Examples EXCLUDE LOD Expressions - Examples	Ch 12 : TABLEAU FORECASTS, ACTIONS Tableau Trend Lines and Usage Reference Lines and Show Data Forecasts, Exponential Smooting Creating and Using Forecasts Describing, Controlling Forecasts Adding / Editing Bookmarks Using Data Analytics in Tableau Tableau Actions and Real-time Use Tableau Action Types, Limitations Filter Actions: Static/Dynamic Highlight Actions, Dynamic Types URL and Parameter Action Types Set Actions, Runtime Actions Tableau Actions & Dashboards Use Field and Filter Actions	Ch 18 : REAL-TIME PROJECT Project Requirement Analysis Implementing SDLC Phases Requirement Gathering, FSA Phase 1: TABLEAU Report Design Visualizations, Properties Analytics and Formating Phase 2: Data Modeling, Tableau Prep Dynamic Connections, Azure DB Parameters and VizQL Scripts Phase 3: Tableau Online Analysis Cloud and Tableau Server Project FAQs and Solutions

Part 1: Tableau Report Design - 1

Part 2: Tableau Report Design - 2

Part 3: Tableau Prep, Server, Online

Ch 1 : TABLEAU INTRO, INSTALLATION

Introduction to Tableau, Reporting Tools
Report Types in Real-time: Interactive
Paginated, Analytical and Mobile Reports
Data Sources for Report Design Process
Databases & Types: OLTP, DWH, OLAP
Tableau : Basic Understanding, Workflow
Tableau as a Self Service BI Tool
Tableau Features, Technical Advantages

Tableau Public Desktop : Installation
Development, Production and Access
Data Sources Types in Tableau
Tableau Prep Tools - Data Modelling
Power BI Licensing Plans - Types
Tableau Training : Course Plan, Lab
Study Material, Certifications, FAQs

Ch 7 : TABLEAU VIZ - LEVEL 1

Tableau Visualizations - Types
Visualization Categories, Usage
Tableau Bar Charts and Types
Simple Bar Charts and Usage
Horizontal & Colored Bar Charts
Stacked Bar Charts, Measures
Side By Side Bar Charts and Use
Interactive Bar Charts & Filters

Line Charts and Data Points
Continous Line Charts and Usage
Discrete Line Charts and Usage
Dual Line Chart and Types
Area Charts : Discrete, Continous
Stacked Area Charts, Reports
Combine Area Charts & Line Charts

Ch 13 : DASHBOARDS & STORIES

Dashboards and Stories in Tableau
Bulding Dashboards - Views, Sheets
Dashboard Size, Views, Objects
Legends and Quick Filters in Tableau
Tiles, Floating Layouts in Tableau
Layout Containers, Images, Web Pages
Dashboard Extensions, Management
API Extensions - Usage in Tableau
Device Designer - Default Layout
Adding and Customizing Layouts
Story Points - Creation and Updates
Bollinger Bands - Views, Summary
Data Cleansing - Bulk Re-aliasing
Tableau Prep : Installation ETL
Tableau Desktop Store, Server Store

Ch 2: BASIC REPORTS, GROUPING

Tableau Public Desktop : Installation
Tableau Workbook Creation, Data Sources
Tableau Worksheets : Creation, Options
Row Shelf & Column Shelf, Details View
Marks : Text, Detail, Tooltip, Colors
VizQL : Vizualization Query Language
Tableau In-Memory Database Usage
Dimensions, Measures Identification

Working with Data Sources, WorkBooks
Worksheets, Marks, Shelves, Axis
Basic Report Design Terminology
Grouping : Data Categorization
Creating Groups on Static Data
Dynamic Data Grouping, Binnig
Hierarchies: Creation, Real-time Use
Drilldown Reports in Tableau

Ch 8 : TABLEAU VIZ - LEVEL 2

Tableau Pie Charts, Real-time Use
Simple Pie Charts - Examples
Stacked Pie Charts - Examples
Side By Side Pie Charts
Reverse Rows and Row Count
Donut Charts and Agle Properties
Inner / Outer Pie Charts, Stacking
Drill-down Pie Charts and Usage

CrossTab Charts and Text Properties
Rows, Columns and Marks : Text
Conditional Formatting, Divergence
Using Quick Claculations in Tableau
Highlight Tables and Color Palettes
Box & Wishker Plots - Text Tables
Heat Maps and Real-time Usage
Size Controls and Color Options

Ch 14 : TABLEAU SERVER

Tableau Server - Architecture
Tableau Server - Installation Process
Publish Tableau Workbook, Verify
Sharing Options and Layouts
Adding Device Layouts in Tableu Server
Adding Custom Layouts in Tableau Server
Adding Content to Custom Layouts
Java Script API in Table Server
Tableau Online Versus Table Server
Security Advantages @ Tableau Server
Tableau Online - Architecture
Publish Tableau Workbook, Verify
Sharing Options and Layouts
Adding Device Layouts in Tableu Online
Adding Custom Layouts in Tableau Online
Adding Content to Custom Layouts
Security Advantages @ Tableau Online

Ch 3 : TABLEAU ARCHITECTURE, JOINS

Data Sources, Connectors, Clients
Tableau Server Components and Use
Application Server and Repository
VizQL Server and Data Engine
Backgrounder, Data Server, Search
Fast Data Engine, Gateway Components
Alias, Bins, Bookmarks, Calcualtions

Tableau File Types and Workbooks
CrossTabs, Dashboards, Data Pane
Data Source Page and Dimensions
Extract, Filters, Pages, Rows, Columns
Visual Sync Limitations with Slicer
Level of Detail, Sets, Marks, Workbooks
Using Joins in Tableau Sources
Inner, Left / Right Outer Joins

Ch 9 : TABLEAU VIZ - LEVEL 3

Tableau Treemaps & Nested Rectangles
Marks Type, Color, Size and Label
Comparing Treemaps with Bars & Tables
Circle View Vizualization and Usage
Side By Side Circle View, Usage
Scatter Plot - Labels, Axis Items
Packed Bubbles and Circles - Lables

Tableau Symbol Maps - Examples
Tableau Filled Maps - Examples
Using Quick Table Calculations
Histogram Charts and Properties
Measures and Value Comparisions
Tableau Motion Charts and Axis
Bullet Graphs and Limitations
Dimension - Measure Considerations

Ch 15 : Colloborate TABLEAU ONLINE

Tableau Online - Purpose, LIVE Reports
Projects and Workbooks in Tableau Online
Tableau Report Views in Tableau Online
Searching Content, Data Sources, Sites
Account Settings, Drill Down, Actions
Custom Views, Comments - Tableau Online
Downloads, Exports - Tableau Online
Sharing, Subscription and favorites
Web Authoring, Edits and Publish Online
Data Driven Alerts - Refining, Managing
Stacked Bars and Views For Alerting
Navigations, Snapshots, Searching
Mobile Reports - Phone Marks and Maps
Interacting with Content on Tableau Online

Ch 4 : BIG DATA ACCESS, BLENDING

Azure Data Access with Tableau
Remote Data Sources and Joins
Using SQL Queries in Tableau
Use Azure SQL Warehouse (DWH)
Data Blending Options in Tableau
Working with Multiple Data Sources
Data Combinations & Aggregations
Show Data & Data Grouping Options

Tableau Operators and Types
Tableau Functions and Real-time Use
Tableau Calculations and Formats
Numerical Calculatins & Examples
Aggregated Calculations in Tableau
Creating Calculations From Shelfs
Calculation Edits, Identifications

Ch 10 : TABLEAU FILTERS

Tableau Filters - Types & Usage
Extract Filters and TDE (hyper)
Data Source Filters (twb Files)
String and Numerical Data Fields
Date/ Time Data Fields, Usage
All Rows, Too & Bottom Rows
Aggregated Extracts and Usage
Extract History, TDE Files

Context Fitlers and Realtime Use
Context Filters: Performance Benefit
Dimension Filters & Limitations
Measure Filters and Aggregations
Measure Name Filters, Measure Values
Table Calculation Filters, Usage
Tableau Filters - Execution Order
Fiters Scope and Quick Filters

Ch 16: Colloborate TABLEAU SERVER

Tableau Server - Purpose, LIVE Reports
Projects, Workbooks in Tableau Server
Tableau Report Views in Tableau Server
Searching Content, Data Sources, Sites
Account Settings, Drill Down, Actions
Custom Views, Comments in Tableau Server
Downloads and Exports in Tableau Server
Sharing, Subscription and favorites
Web Authoring, Edits and Publish Online
Data Driven Alerts - Refining, Managing
Stacked Bars, Alerting Views in Server
Navigations, Snapshots, Searching in Server
Mobile Reports - Phone Marks and Maps
Interacting with Content on Tableau Server

Ch 5 : STRING, DATE FUNCTIONS

String Functions in Tableau
ASCII, CHAR, LEN, ENDSWITH
FIND, FINDNTH, LEFT, CONTAINS
LOWER, UPPER, LTRIM, RTRIM
MID, MIN, REPLACE, RIGHT
SPACE, SPLIT, UPPER, MAX

STARTSWITH, AND, CASE
ELSE, ELSEIF, END, IF, IIF
IFNULL, ISDATE, ISNULL, MAX
MIN, NOT, OR, THEN, WHEN, ZN
DATEADD, DATEDIFF, DATENAME
DATEPART, DATETRUNC, DAY
ISDATE, MAKEDATE, MONTH
NOW, QUARTER, TODAY, YEAR

Ch 11 : PARAMETERS, SETS

Tableau Parameters - Working
Creating Parameters, Conditions
Linking Parameters to Calculations
Using Calculations in Fields/View
Dynamic Filters using Parameters
Dynamic Dimension using Parameters
Dynamic Measures using Parameters

Creating, Using Sets in Tableau
IN and OUT Concepts in Sets
Working with Filters and Sets
Show Set Options and Exclude
Comparing Tableau Sets & Groups
Comparing Tableau Sets & Hierarchies
Dynamic Sets : Creation & Usage

Ch 17 : MANAGE TABLEAU SERVER

Tableau Server - Administration Concepts
Tableau Sites, Users, Groups Security
Group Rules, Web Edits in Tableau Server
Project Permission and Locking Options
Data Security with user Filters in Server
user Filters and Hybrid Models in Server
Access Roles, Schedules, Extraction
TSM : Tableau Services Manager
TSM Configuration for Real-time Use
Browser, Maintenance, GUI and CLI
Backups and Restores with Tableau TSM
TSM Upgrades For Tableau Report Config
Tabcmd : Command Line Utility - Imports
Tabcmd : user Import via CSV File
Comparing Tableau & Microsoft Power BI

Ch 6 : TABLE, LOD CALCULATIONS

Calcualtions For Year, Quarter, Month
Custom Calculations, Data Appending
Custom Date and Time Formatting
Calculations Reuse and Edits
Date and Time Conversions To INT
Two Digit Conversions with Date
Table Functions with Tableau
Running Total and Row Number
Case Statements, FIRST, LOOKUP

Table Calculations, Level of Details
Real-time Use of Table Calculations
Partitioning, Addressing Benefits
LOD : Types of Level Of Detail
FIXED LOD Expressions - Examples
INCLUDE LOD Expressions - Examples
EXCLUDE LOD Expressions - Examples

Ch 12 : TABLEAU FORECASTS, ACTIONS

Tableau Trend Lines and Usage
Reference Lines and Show Data
Forecasts, Exponential Smooting
Creating and Using Forecasts
Describing, Controlling Forecasts
Adding / Editing Bookmarks
Using Data Analytics in Tableau

Tableau Actions and Real-time Use
Tableau Action Types, Limitations
Filter Actions: Static/Dynamic
Highlight Actions, Dynamic Types
URL and Parameter Action Types
Set Actions, Runtime Actions
Tableau Actions & Dashboards
Use Field and Filter Actions

Ch 18 : REAL-TIME PROJECT

Project Requirement Analysis
Implementing SDLC Phases
Requirement Gathering, FSA

Phase 1:

TABLEAU Report Design
Visualizations, Properties
Analytics and Formating

Phase 2:

Data Modeling, Tableau Prep
Dynamic Connections, Azure DB
Parameters and VizQL Scripts

Phase 3:

Tableau Online Analysis
Cloud and Tableau Server
Project FAQs and Solutions

Module 3: Python Training Content [For Plan C]

Python Basics - Level I	Python Basics - Level II	Module II: Advanced Python
DAY 1 : INTRODUCTION TO SCRIPT What is Script in Python? What is a program in Python? Types of Scripts in Python? Difference between Script programming languages list main features of scripting Lang. limitation of client side scripting Programming Language Paradigms Basic understanding of Python Is Python a compiled language? where is python used in real life? Why is Python called Python?	DAY 9 : Python TUPLE Advantages of Tuple over List Packing and Unpacking - Tuples Creating Nested tuple -Examples Deleting Tuples - Slicing of Tuples Comparing Tuple Membership Test Built in Functions ,Dotted Charts Python Sets how to create/declare a set in python Iteration Over Sets - Python Methods Python Set Operations - Union of Sets Built-in Functions with Set python frozenset get element	DAY 17 : Python Regular Expressions What is Regular Expression? Regular Expression Syntax Understanding Regular Expressions Regular Expression Patterns Literal characters - Repetition Cases Groups and Grouping Regular Expressions Example of w+ and ^ Expression Example of \s expression in re.split function Using regular expression methods Using re.match() in Regular Exp. Finding Pattern in Text (re.search()) Using re.findall for text
DAY 2 : INTRODUCTION TO PYTHON What is Python Programming? Why Python is used in DS? Where is python Mostly used? Characteristics of Python Programming History of Python Programming Language What is PSF Python Programming? Python Versions - Python Application How to Download Python,print to the screen How to Install Python , Creating Program Install Python with Diff IDEs Features of Python Programming Limitations of Python Programming	DAY 10 : Python Dictionary How to create a dictionary? PYTHON HASHING - Dictinary Methods Copying dictionary - Updating Dictionary Delete Keys from the dictionary Sorting the Dictionary - Dictionary len() Python Dictionary in-built Functions Variable Types - python List Cmp() Python List cmp() Method Python Dictionary Str(dict) How do you create a dictionary in Python? Can Python dictionary have multiple values? How do you add to a dictionary in python?	DAY 18 : Python-Data Base Communication What is Database? Types of Databases What is Database Management System What is Relational DBMS? What is Big Data? Types of data? Oracle - SQLSERVER - MYSQL - DB2 Postgre SQL - DataBase Sample Executing the Queries - Bind Variables Installing of Oracle Python Modules Executing DML Operations..!! Connecting to the Database Create a connection object. Create a cursor object to read/write.
DAY 3 : DIFFERENT MODE IN PYTHON Execute the Script - Interactive & Script Mode Python File Extensions - Script Mdoe SETTING PATH IN Windows - Clear Screen Learn Python Main Function - Comments Quit the Python Shell - Simple Calculator Order of operations - Multiline Statements Quotations in Python - Python Path Testing Joining two lines - Python Implementation Python Packages - Usage of Python in DS USES OF PYTHON IN IOT - Working in Python in Unix/Linux/Windows/Mac/Android..!! script Mode and Interactive mode	DAY 11 : Python Functions What is a function? - Types of Function How to define and call a function in Python Significance of Indentation (Space) in Python How Function Return Value? Types of Arguments in Functions Default Arguments - Non Default Arg. Keyword Arguments - Non Keyword Arg. Arbitrary Arguments in python Various Forms of Function Arguments Scope and Lifetime of variables - Nested Fun Call By Value, Call by Reference in python Anonymous Functions/Lambda functions	DAY 19 : Multi-Threading What is Multi-Threading Threading Module in python Defining a Thread in python Thread Synchronization What is python multithreading? Does Python have true multithreading? Difference between multiprocessing & multithreading Why does Python have a Gil? Thread Control Block (TCB): Thread Identifier in MultiThreading Stack pointer in multi-Threading Program counter, Thread State
DAY 4 : PYTHON NEW IDEs PyCharm IDE - How to Work on Pycharm PyCharm Components - Debugging in Pycharm PYTHON Install Anaconda - What is Anaconda? Coding Environments - Spyder Components General Spyder Features - Spyder Shortcut Keys Jupyter Notebook - What is Conda? Conda List - Jupyter and Kernals Environment Python PIP - Mutable Versus Immutable Objects Variables in Python What is Variable? - Variables and Constants Variable names - Mnemonic Variable Names Values and Types - What Does "Type" Mean? Multiple Assignment - Python Numerical types	DAY 12 : Python Modules What is a Module? - Types of Modules The import Statement - The from… import st ..import * Statement - Underscores in python The Dir() Function in python Creating User defined Modules Command line Arguments in python Getting Python Module Search Path What are modules and packages in Python? What is Python import statement? How do you import random in Python? import <module_name> string python from <module_name> import <name(s)> from <module> import <name> as <name>	DAY 20 : Introduction to Python Web Python Web Frameworks Django – Design Form or patterns Advantages of Django Web Framework MVC and MVT - Installing Django Designing Web Pages using python HTML5, CSS3, AngularJS Templates PYTHON Flask - Java Script variables PYTHON Bottle - PYTHON pyramid - Falcon How Python is used for web programming? Can I build a website with Python? Is Python suitable for Web development? What is Python and Django?
DAY : 5 Python Operators and Operands Arithmetic Operators - Relational Operators Comparison Operators - Assignment Operator Short hand Assignment Operators Logical Operators or Bitwise Operators Membership Operators - Identity Operators Operator precedence - Evaluating Expressions python evaluate expression in string Standard Datatypes - Operators and Operands Order of operations - Swap Variables Types Conversion Function - Python Math. Mutable Versus Immutable Objects Operator precedence - Evaluating Exp. Evaluating expressions in python	DAY 13 : Packages in Python What is a Package in Python? Introduction to Packages? py file - Creating a package Importing module from a package Creating Sub Package in Python Importing from Sub-Packages Most Popular Python Packages How many libraries are there in Python? What are libraries in Python? What is the difference between NumPy & SciPy? Why is SciPy and NumPy used? Python what is Seaborn? - Examples Is NumPy a Python framework?	DAY 21 : GUI Programming-Tkinter Introduction to Tkinter GUI Program Components and Events in Tkinter Adding Controls in Tkinter form Entry Widget, Text Widget, Radio Button, Check Button in Tkinter forms List Boxes, Menus, ComboBox, Canvas, Entry What is Tk () in Python? What is Mainloop () in Python? What is the best GUI for Python? Can we make a GUI in Python? Messagebox ,simpledialog messagebox tkinter methods showinfo(),showerror(), showwarning()
DAY 6 : String Handling what is String ? - String Operations - String indices String Functions - len , upper, lower,join,Split SwapCase(), Title(),find(),isupper(),islower() Delete a string - Python Keywords String Multiplication and concatenation Python Identifiers - Python Literals string formatting operator in python Built-in String Methods - Data Structures Structuring with indentation in Python Define Data Structure in Python Language Reverse words - Reverse Characters Examples How do you split a string in Python?	DAY 14 : Python Date and Time How to Use Date & DateTime Class How to Format Time Output How to use Timedelta Objects Calendar in Python datetime classes in Python How to Format Time Output? Python Calendar Module,Time Module Python Text Calendar Python HTML Calendar Class Unix Date and Time Commands Python strftime() How strftime() works?	DAY 22: Data Analytics Introduction to data Big Data? Introduction to NumPY and SciPY Introduction to Pandas and MatPlotLib Data Science What is Data Science in Python Data Science Life Cycle in python what is data analysis using python what is Data Mining in Python Analytics vs Data Science in python How Python is used in big data? Is Python or R better for data science? Why is Python used in data science?
DAY 7 : Python Conditional Control Structures - Sequential Control Structure Selective and Repetative Control Structure How to use “if condition” in conditional control Structures in python if statement (One-Way Decisions) if .. else statement (Two-way Decisions) How to use “else condition” if .. elif .. else statement (Multi-way) When “else condition” does not work How to use “elif” condition How to execute conditional statement with minimal code - Nested IF Statement Nested IF Statement in python	DAY 15 : Python OS Module Shell Script Commands in OS Modules Various OS operations in Python Python File System Shell Methods Different Python Modules os - math - cmd -csv - random Numpy ( numerical python ) Pandas - sys - Matplotlib - Datetime Python Exception Handling Common RunTime Errors in PYTHON Abnormal termination,Python Custom Exception Chain of importance Of Exception,Assertions Exception Handling, Argument of an Exception Try … Except,Try…Except…else,Try…finally	DAY 23 : Internet of Things IMPACT OF THE INTERNET What is IOT - History of IOT What is importance of Network? What is importance of Protocol? what is smart_open in python How Internet of Things Works? The Future of Internet of Things What is future of Internet of Things Is Python used in IoT? - Framework Which language is better for IoT? How many IoT devices will be there? How many IoT devices are there?
DAY : 8 Python LOOPS How to use While loop and For loop Break and Continue Statements in For loop Python Enumerate function for For Loop Sequence or Collections and Lists Strings - Unicode Strings Lists - Tuples - Sets - Dictionary - Xrange Lists are mutable - Accessing the List Updating a List - Deleting a List List indices - Traversing a list List operations - List Slices - List Methods Map, filter and reduce - Deleting elements What is list of list in python? What is Python list function? How do you add to a list in Python?	DAY 16 : Python Class and Objects Introduction to OOPs Programming Object Oriented Programming System Define Classes - Built in Class Attributes Creating Objects - Constructors Class variables and Instance Variables Basic concept of Object and Classes Access Modifiers - Self Varible in python How to define Python classes Python Namespace - Garbage Collections What is Inheritance? Types of Inheritance? Single Inheritance - Hierarchical Inheritance Multilevel,Multiple,Hybrid Inheritance Overloading and Over Riding Polymorphism - Abstraction – Encapsulation	DAY 24 : Introduction to Machine Learning Learning with PYTHON What is Machine learning? Machine Learning Methods predictive models in python Descriptive Models in Python What are the steps used in Mach. Learning? what is deep learning in python How Python can be used in Mach. learning? Which Python library is used for Mach.Learning? What is PredictionIO machine learning server? What are some well open source ML libraries? Why are most machine learning projects? Some good open source projects for ML What is the best open source machine translation?

Python Basics - Level I

Python Basics - Level II

Module II: Advanced Python

DAY 1 : INTRODUCTION TO SCRIPT

What is Script in Python?
What is a program in Python?
Types of Scripts in Python?
Difference between Script
programming languages list
main features of scripting Lang.
limitation of client side scripting
Programming Language Paradigms
Basic understanding of Python
Is Python a compiled language?
where is python used in real life?
Why is Python called Python?

DAY 9 : Python TUPLE

Advantages of Tuple over List
Packing and Unpacking - Tuples
Creating Nested tuple -Examples
Deleting Tuples - Slicing of Tuples
Comparing Tuple Membership Test
Built in Functions ,Dotted Charts

Python Sets

how to create/declare a set in python
Iteration Over Sets - Python Methods
Python Set Operations - Union of Sets
Built-in Functions with Set
python frozenset get element

DAY 17 : Python Regular Expressions

What is Regular Expression?
Regular Expression Syntax
Understanding Regular Expressions
Regular Expression Patterns
Literal characters - Repetition Cases
Groups and Grouping Regular Expressions
Example of w+ and ^ Expression
Example of \s expression in re.split function
Using regular expression methods
Using re.match() in Regular Exp.
Finding Pattern in Text (re.search())
Using re.findall for text

DAY 2 : INTRODUCTION TO PYTHON

What is Python Programming?
Why Python is used in DS?
Where is python Mostly used?
Characteristics of Python Programming
History of Python Programming Language
What is PSF Python Programming?
Python Versions - Python Application
How to Download Python,print to the screen
How to Install Python , Creating Program
Install Python with Diff IDEs
Features of Python Programming
Limitations of Python Programming

DAY 10 : Python Dictionary

How to create a dictionary?
PYTHON HASHING - Dictinary Methods
Copying dictionary - Updating Dictionary
Delete Keys from the dictionary
Sorting the Dictionary - Dictionary len()
Python Dictionary in-built Functions
Variable Types - python List Cmp()
Python List cmp() Method
Python Dictionary Str(dict)
How do you create a dictionary in Python?
Can Python dictionary have multiple values?
How do you add to a dictionary in python?

DAY 18 : Python-Data Base Communication

What is Database? Types of Databases
What is Database Management System
What is Relational DBMS?
What is Big Data? Types of data?
Oracle - SQLSERVER - MYSQL - DB2
Postgre SQL - DataBase Sample
Executing the Queries - Bind Variables
Installing of Oracle Python Modules
Executing DML Operations..!!
Connecting to the Database
Create a connection object.
Create a cursor object to read/write.

DAY 3 : DIFFERENT MODE IN PYTHON

Execute the Script - Interactive & Script Mode
Python File Extensions - Script Mdoe
SETTING PATH IN Windows - Clear Screen
Learn Python Main Function - Comments
Quit the Python Shell - Simple Calculator
Order of operations - Multiline Statements
Quotations in Python - Python Path Testing
Joining two lines - Python Implementation
Python Packages - Usage of Python in DS
USES OF PYTHON IN IOT - Working in Python
in Unix/Linux/Windows/Mac/Android..!!
script Mode and Interactive mode

DAY 11 : Python Functions

What is a function? - Types of Function
How to define and call a function in Python
Significance of Indentation (Space) in Python
How Function Return Value?
Types of Arguments in Functions
Default Arguments - Non Default Arg.
Keyword Arguments - Non Keyword Arg.
Arbitrary Arguments in python
Various Forms of Function Arguments
Scope and Lifetime of variables - Nested Fun
Call By Value, Call by Reference in python
Anonymous Functions/Lambda functions

DAY 19 : Multi-Threading

What is Multi-Threading
Threading Module in python
Defining a Thread in python
Thread Synchronization
What is python multithreading?
Does Python have true multithreading?
Difference between multiprocessing & multithreading
Why does Python have a Gil?
Thread Control Block (TCB):
Thread Identifier in MultiThreading
Stack pointer in multi-Threading
Program counter, Thread State

DAY 4 : PYTHON NEW IDEs

PyCharm IDE - How to Work on Pycharm
PyCharm Components - Debugging in Pycharm
PYTHON Install Anaconda - What is Anaconda?
Coding Environments - Spyder Components
General Spyder Features - Spyder Shortcut Keys
Jupyter Notebook - What is Conda?
Conda List - Jupyter and Kernals Environment
Python PIP - Mutable Versus Immutable Objects

Variables in Python

What is Variable? - Variables and Constants
Variable names - Mnemonic Variable Names
Values and Types - What Does "Type" Mean?
Multiple Assignment - Python Numerical types

DAY 12 : Python Modules

What is a Module? - Types of Modules
The import Statement - The from… import st
..import * Statement - Underscores in python
The Dir() Function in python
Creating User defined Modules
Command line Arguments in python
Getting Python Module Search Path
What are modules and packages in Python?
What is Python import statement?
How do you import random in Python?
import <module_name> string python
from <module_name> import <name(s)>
from <module> import <name> as <name>

DAY 20 : Introduction to Python Web

Python Web Frameworks
Django – Design Form or patterns
Advantages of Django Web Framework
MVC and MVT - Installing Django
Designing Web Pages using python
HTML5, CSS3, AngularJS Templates
PYTHON Flask - Java Script variables
PYTHON Bottle - PYTHON pyramid - Falcon
How Python is used for web programming?
Can I build a website with Python?
Is Python suitable for Web development?
What is Python and Django?

DAY : 5 Python Operators and Operands

Arithmetic Operators - Relational Operators
Comparison Operators - Assignment Operator
Short hand Assignment Operators
Logical Operators or Bitwise Operators
Membership Operators - Identity Operators
Operator precedence - Evaluating Expressions
python evaluate expression in string
Standard Datatypes - Operators and Operands
Order of operations - Swap Variables
Types Conversion Function - Python Math.
Mutable Versus Immutable Objects
Operator precedence - Evaluating Exp.
Evaluating expressions in python

DAY 13 : Packages in Python

What is a Package in Python?
Introduction to Packages?
py file - Creating a package
Importing module from a package
Creating Sub Package in Python
Importing from Sub-Packages
Most Popular Python Packages
How many libraries are there in Python?
What are libraries in Python?
What is the difference between NumPy & SciPy?
Why is SciPy and NumPy used?
Python what is Seaborn? - Examples
Is NumPy a Python framework?

DAY 21 : GUI Programming-Tkinter

Introduction to Tkinter GUI Program
Components and Events in Tkinter
Adding Controls in Tkinter form
Entry Widget, Text Widget, Radio Button,
Check Button in Tkinter forms
List Boxes, Menus, ComboBox, Canvas, Entry
What is Tk () in Python?
What is Mainloop () in Python?
What is the best GUI for Python?
Can we make a GUI in Python?
Messagebox ,simpledialog
messagebox tkinter methods
showinfo(),showerror(), showwarning()

DAY 6 : String Handling

what is String ? - String Operations - String indices
String Functions - len , upper, lower,join,Split
SwapCase(), Title(),find(),isupper(),islower()
Delete a string - Python Keywords
String Multiplication and concatenation
Python Identifiers - Python Literals
string formatting operator in python
Built-in String Methods - Data Structures
Structuring with indentation in Python
Define Data Structure in Python Language
Reverse words - Reverse Characters Examples
How do you split a string in Python?

DAY 14 : Python Date and Time

How to Use Date & DateTime Class
How to Format Time Output
How to use Timedelta Objects
Calendar in Python
datetime classes in Python
How to Format Time Output?
Python Calendar Module,Time Module
Python Text Calendar
Python HTML Calendar Class
Unix Date and Time Commands
Python strftime()
How strftime() works?

DAY 22: Data Analytics

Introduction to data Big Data?
Introduction to NumPY and SciPY
Introduction to Pandas and MatPlotLib

Data Science

What is Data Science in Python
Data Science Life Cycle in python
what is data analysis using python
what is Data Mining in Python
Analytics vs Data Science in python
How Python is used in big data?
Is Python or R better for data science?
Why is Python used in data science?

DAY 7 : Python Conditional

Control Structures - Sequential Control Structure
Selective and Repetative Control Structure
How to use “if condition” in conditional
control Structures in python
if statement (One-Way Decisions)
if .. else statement (Two-way Decisions)
How to use “else condition”
if .. elif .. else statement (Multi-way)
When “else condition” does not work
How to use “elif” condition
How to execute conditional statement with
minimal code - Nested IF Statement
Nested IF Statement in python

DAY 15 : Python OS Module

Shell Script Commands in OS Modules
Various OS operations in Python
Python File System Shell Methods
Different Python Modules
os - math - cmd -csv - random
Numpy ( numerical python )
Pandas - sys - Matplotlib - Datetime
Python Exception Handling
Common RunTime Errors in PYTHON
Abnormal termination,Python Custom Exception
Chain of importance Of Exception,Assertions
Exception Handling, Argument of an Exception
Try … Except,Try…Except…else,Try…finally

DAY 23 : Internet of Things

IMPACT OF THE INTERNET
What is IOT - History of IOT
What is importance of Network?
What is importance of Protocol?
what is smart_open in python
How Internet of Things Works?
The Future of Internet of Things
What is future of Internet of Things
Is Python used in IoT? - Framework
Which language is better for IoT?
How many IoT devices will be there?
How many IoT devices are there?

DAY : 8 Python LOOPS

How to use While loop and For loop
Break and Continue Statements in For loop
Python Enumerate function for For Loop

Sequence or Collections and Lists

Strings - Unicode Strings
Lists - Tuples - Sets - Dictionary - Xrange
Lists are mutable - Accessing the List
Updating a List - Deleting a List
List indices - Traversing a list
List operations - List Slices - List Methods
Map, filter and reduce - Deleting elements
What is list of list in python?
What is Python list function?
How do you add to a list in Python?

DAY 16 : Python Class and Objects

Introduction to OOPs Programming
Object Oriented Programming System
Define Classes - Built in Class Attributes
Creating Objects - Constructors
Class variables and Instance Variables
Basic concept of Object and Classes
Access Modifiers - Self Varible in python
How to define Python classes
Python Namespace - Garbage Collections
What is Inheritance? Types of Inheritance?
Single Inheritance - Hierarchical Inheritance
Multilevel,Multiple,Hybrid Inheritance
Overloading and Over Riding
Polymorphism - Abstraction – Encapsulation

DAY 24 : Introduction to Machine Learning

Learning with PYTHON
What is Machine learning?
Machine Learning Methods
predictive models in python
Descriptive Models in Python
What are the steps used in Mach. Learning?
what is deep learning in python
How Python can be used in Mach. learning?
Which Python library is used for Mach.Learning?
What is PredictionIO machine learning server?
What are some well open source ML libraries?
Why are most machine learning projects?
Some good open source projects for ML
What is the best open source machine translation?

EVERY SESSION IS COMPLETELY PRACTICAL. REAL-TIME. TASKS, MATERIAL, LAB WORK for EVERY SESSION. Register Today

Who can benefit from this Tableau Training course?

Complete Real-time and Practical Tableau Training with Real-time Project. With this humongous amount of data and real business implications at play, business organizations across the world have the need for an easy to use tool to analyze data and derive actionable insights from it. Tableau helps organizations do exactly this – mining the data and visualizing business opportunities.

Tableau Training - Highlights :

Completely Real-time & Practical Classes
Highly Interactive with Technical Examples
Project Oriented FAQs for your Job Interviews
Real-time Project with Complete Solution Explanation
Chapter Wise Interview Questions (FAQs) with Answers
Real-time Case Studies for Queries and DB Design, Solutions
Case Studies for Programming, Business Logic Solutions
Mock Interviews - Chapter Wise. Solutions & Explanations

Basic to Advanced Reporting Concepts
Detailed Design of Interactive, Paginated Reports
Basic to Advanced Visualizations and Data Formatting
Working with Tableau Prep, ETL & Data Access Operations
Dynamic Data Acces and Parameterized Connections
Tableau Cloud (Service) with Reports, Dashboards, Apps
Tableau Server Configuration and Data Refresh Options
Project for your Resume with Excel, Database Sources

Other Popular Courses: TSQL Training, MSBI Training, Power BI Training, Azure Data Engineer Training, SQL DBA Training, [+] More Courses

SQL Server T-SQL, Azure SQL, Azure DBA, Azure BI, Azure Data Engineer, Power BI Training

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Register

Details Register

Online Register

Online Video

Online Video

Tableau Training

Tableau Training Plans

Tableau Training Highlights :

Tableau Training Course Contents:

Module 1: Basic SQL

Module 2: SQL & PL SQL

Module 3: Adv PLSQL

CHAPTER 1 : INTRODUCTION TO DBMS

CHAPTER 7 : CONSTRAINTS & KEYS

CHAPTER 13 : PL/SQL – (CONTROL STRUCTURE) - Level I

CHAPTER 2: ORACLE INSTALLATION

CHAPTER 8 : QUERIES & JOINS

CHAPTER 14: ADVANCED PL/SQL - 1

CHAPTER 3: INTRODUCTION TO RDBMS

CHAPTER 9 : VIEWS, SYNONYMS,SEQUENCES

CHAPTER 15 : ADVANCED PL/SQL - 2

CHAPTER 4 : SQL LANGUAGE COMMANDS

CHAPTER 10 : SUB QUERIES, NESTED QUERIES

CHAPTER 16 : ADVANCED PL/SQL - 3

CHAPTER 5.SQL SPECIAL OPERATORS

CHAPTER 11: LOCKS in ORACLE TABLES

CHAPTER 17: OBJECT TECHNOLOGY – Level I

CHAPTER 6: GROUPING QUERY RESULTS

CHAPTER 12 : PERFORMANCE (QUERY) TUNING

CHAPTER 18: OBJECT TECHNOLOGY – Level II

Part 1: Tableau Report Design - 1

Part 2: Tableau Report Design - 2

Part 3: Tableau Prep, Server, Online

Ch 1 : TABLEAU INTRO, INSTALLATION

Ch 7 : TABLEAU VIZ - LEVEL 1

Ch 13 : DASHBOARDS & STORIES

Ch 2: BASIC REPORTS, GROUPING

Ch 8 : TABLEAU VIZ - LEVEL 2

Ch 14 : TABLEAU SERVER

Ch 3 : TABLEAU ARCHITECTURE, JOINS

Ch 9 : TABLEAU VIZ - LEVEL 3

Ch 15 : Colloborate TABLEAU ONLINE

Ch 4 : BIG DATA ACCESS, BLENDING

Ch 10 : TABLEAU FILTERS

Ch 16: Colloborate TABLEAU SERVER

Ch 5 : STRING, DATE FUNCTIONS

Ch 11 : PARAMETERS, SETS

Ch 17 : MANAGE TABLEAU SERVER

Ch 6 : TABLE, LOD CALCULATIONS

Ch 12 : TABLEAU FORECASTS, ACTIONS

Python Basics - Level I

Python Basics - Level II

Module II: Advanced Python

DAY 1 : INTRODUCTION TO SCRIPT

DAY 9 : Python TUPLE

DAY 17 : Python Regular Expressions

DAY 2 : INTRODUCTION TO PYTHON

DAY 10 : Python Dictionary

DAY 18 : Python-Data Base Communication

DAY 3 : DIFFERENT MODE IN PYTHON

DAY 11 : Python Functions

DAY 19 : Multi-Threading

DAY 4 : PYTHON NEW IDEs

DAY 12 : Python Modules

DAY 20 : Introduction to Python Web

DAY : 5 Python Operators and Operands

DAY 13 : Packages in Python

DAY 21 : GUI Programming-Tkinter

DAY 6 : String Handling

DAY 14 : Python Date and Time

DAY 22: Data Analytics

DAY 7 : Python Conditional

DAY 15 : Python OS Module

DAY 23 : Internet of Things

DAY : 8 Python LOOPS

DAY 16 : Python Class and Objects

DAY 24 : Introduction to Machine Learning

Who can benefit from this Tableau Training course?

Tableau Training - Highlights :

SQL Server T-SQL, Azure SQL, Azure DBA, Azure BI, Azure Data Engineer, Power BI Training

For latest schedules Click Here