Tableau Online Training

Tableau is a simple, vast and elegant Business Intelligence tool for analyzing and reporting any type of data. Users can create and share interactive dashboards that include trend analysis, density measure in the form of graphs and charts and a rich set of Custom Visuals.

Our Tableau Training course includes wide range of data sources including DAT, CSV, EXCEL, MS ACCESS, OLTP Databases, DWH Databases, OLAP Databases, Azure Sources, One Drive, Google Cloud, Google Datasets, Facebook, JSON, XML and R. This course also includes Data Blending with Tableau Server and Tableau Online including Tableau Bridge - along with one Real-time Project and Resume Guidance.

Tableau Course Training Plans

	PLAN A	PLAN B	PLAN C
Description	Tableau	Tableau & PL SQL	Tableau, PL SQL & Python
Duration	4 Weeks	8 Weeks	12 Weeks
Tableau Desktop and Report Design
Data Modeling with Tableau Tools
ETL and ELT Process with Tableau
Tableau Prep and Data Mash-up
Big Data Access in Tableau Reports
Paginated Reports, Interactive Reports
Table Cloud Confi, Report Hosting
Row Level Security (RLS) with Tableau
Adv Settings, Data Refresh, Rest API
DDL, DML, SELECT, DCL, TCL Cmds
SQL Joins, Queries and Sub Queries
Query Tuning and Excel Integration
Basics of SPs, Functions, Transactions
Using SQL with Real-world Reports
Python Fundamentals (Basics)
Python Modes and new IDEs
Sequence, Lists, Tuple, Sets
File Handling and Exception Handling
Python Classes, XML Parser
Unit Testing, Python Web
Web Scrapping, Data Analytics
Data Science & Machine Learning Intro
Total Course Fee	INR 7,000/- USD 100	INR 13,000/- USD 200	INR 20,000/- USD 300

All Trainings are completely Practical and Real-Time.

	Timings (IST)	Demo Date	Start Date
Schedules for Tableau LIVE Online Training
1	11:15 AM - 12:15 PM	Oct 15th	Register
2	7 AM - 9 AM (wk)	Oct 26th	Register
Schedules for PL-SQL
1	6:45 AM - 7:45 AM	Oct 22nd	Register
2	8 AM - 9 AM	Nov 5th	Register
3	10:15 AM - 11:15 AM	Oct 15th	Register
4	3:00 PM - 4:00 PM	Oct 28th	Register
5	6:30 PM - 7:30 PM	Nov 11th	Register
6	9:00 AM - 11:00 AM (wk)	Oct 26th	Register
Schedules for Python Training
1	9 AM - 10 AM	Nov 5th	Register
2	4 PM - 5 PM	Oct 15th	Register
3	11 AM - 1 PM (wk)	Nov 2nd	Register

Tableau TRAINING HIGHLIGHTS :

✔ Tableau Desktop	✔ Report Design
✔ Data Modeling	✔ ETL & ELT Process
✔ Data Mash-up	✔ Big Data Access
✔ Paginated Reports	✔ Interactive Reports
✔ Cloud Config	✔ Report Hosting
✔ Resume Guidance	✔ MCSA MSBI Exam

Trainer : Mr. Shekar (15+ Yrs EXP). Profile

Tableau Training Course Contents:

Brochure Download:

Register Today

Tableau Development

Applicable for Plan A, Plan B

Tableau Development

Applicable for Plan A, Plan B

PLAN B : Tableau Administration

Applicable for Plan B

DAY 1 : TABLEAU INTRODUCTION

Need for Business Intellgence (BI)
Need for Reporting Tools
Need for Data Visualizations
Tableau Data Analyst Roles
Tableau Business Analyst Roles
Tableu - Scope and Advantages
Why Tableau? Why Visualizations?
Level Setting and Terminology
Tableau Product Line in Real-world
Licensing and Pricing in Tableau
Integration Components in Tableau
Comparing Tableau and Power BI
Comparing Tableau and QlikView

DAY 2 : TABLEAU INSTALLATION

Installing Tableau Desktop Tool
Understanding the Interface
Menu Options and Data Access Options
Integration Components in Tableau
Designing Basic Reports in Tableau
Understanding the Tableau workspace
Understanding Dimensions and Measures
Using "Show Me" Options & Workspace
Working of Shelves and Marks
Building Basic Views in Tableau
Help Menu and Samples in Tableau
Saving and Sharing your work
Application Terminology, Definitions
Data Source Page, Tableau Workspace
Distributing and Publishing Reports

DAY 3 : TABLEAU PREP

Tableau Prep Interface - Examples
Building Flows in Tableau Interface
Input Step and Cleaning Step
Adding Data to Flow, Wildcard Union
Data Sampling, Additional Inputs
Data Cleansing - Context, Process
Annotations and Cleaning Options
Group & Replace, Out of Domain Values
Fuzzy Matching Algorithms and Notes
Profile Pane in Tableau & Errors
Data Highlighting, Distribution
Pivot Step and Aggregation Step
Join Configuration Pane, Join Edits
Union Configuration Pane, Union Edits
Output Step : Creation and Edits
Running the Flow, Multi Output
Preview in Tableau Desktop

DAY 4 : DATA SOURCES IN TABLEAU

Connecting to DAT and CSV File Sources
Connecting to Excel File Sources, Sheets
Connecting to OLTP Database Sources
Connecting to DWH Database Sources
Connecting to OLAP Database Sources
Connecting to Cloud Databases Tableau
Connecting to Files & Folders in Tableau
Working with Multiple Sheets - Live, Extract
Extract Refresh, Publish Data Source
Metadata Edits, Connection Edits
Join Types: Inner, Outer and Union
Cross Database Joins, Data Blending
Data Blending - Calculations, Aggregations
Aestricks, Pdf Connections. Headers, Pivots

DAY 5 : VISUAL ANALYTICS - Level 1

Marks and Mark Types in Power BI
Number, Aggregations in Marks
Bulding View, Highlights, Details
Hierarchies and Drilldown Options
Sorting from Pill, Nested Sorts
Grouping Headers, Grouping Pane
Grouping Marks, Visual Grouping
Calculations, Parameters in Grouping
Creating and Combining Sets - Marks

DAY 6 : VISUAL ANALYTICS - Level 2

Data Filters and Fitler Shelf - Usage
Pill Types in Filtering and Dates
Measures and Continous Dimensions
Interactive Filters - Layout Modes
Casading Interactive Filters - Usage
Where Tableau Filters, Summaries
Data Source Filters, Record Filters
Context Filters and Worksheets
Filter Order with Filter Queries
Parameters in Tableau - Types
Parameters and Filters Usage
Parameters with Sets, Calculated Fields
Parameters with Reference Lines

DAY 7 : VISUAL ANALYTICS - Level 3

Formatting Options with Tableau
Labels, Annotations and Tooltips
Formatting Specific Parts of the View
Editting, Formatting Axes. Map Layers
Formatting Pane: Formatting Menu
Font, Alignment, Shading, Borders
Lines, Copy/Paste, Workbook Formats
Tooltips: Storytelling, selection, Action
Command Buttons, Conditional Tooltips
Viz in Tooltip, Size and Filters
TrendLines, Significance and Residuals
Command Buttons & Conditional Tooltips
Reference Lines: Adding, Edits, Formats
Lines, Bands, Distribution and Boxes
Reference Bands, Reference Distributions
Box Plots, Drop Lines and Forecasts

DAY 8 : VISUAL ANALYTICS - Level 4

Forecast Fields and Descriptions
k-means Cluster Analysis, Conditions
Using MDX and cohort Calculations
Grouping and Calculated Members
OLAP Cube Reports in Real-time
Map Reports : Latitudes, Longitudes
Coordinate Points, GeoCoding
Plotting Graphs, Symbols, Filled Maps
WMS and Map Layers. Spatial Data
Polygon Maps, Background Images
Mapbox Integration - Classic and GL

DAY 9 : CALCULATIONS

Tableau ─ Operators and Functions
Calculations Syntax, LOD Expressions
Numeric Calculations, String Calculations
Table Calculations and FieldSet, Edits
Manual, Quick Table Calculations
Aggregate Calculations, Columns
Date Calculations, Tableau Dates
Logic Calculations, String Calculations
Number Calculations, Type Calculations
Nested LOD Calculations, Integrations
Granularity and Ratio Calculations

DAY 10: TABLEAU CHARTS - Level 1

Bar Chart : Simple Bar Chart
Bar Chart Color Range , Stacked Bar
Line Chart Simple Line Chart
Multiple Measure Line Chart
Line Chart with Label Tableau - Pie Chart
Simple Pie Chart Drill-Down Pie Chart
Crosstab, Simple Crosstab Crosstab
Color Encoded Crosstab - Row Percentage
Scatter Plot, Simple Scatter Plot
Scatter Plot - Color Encoded Properties
Scatter Plot - Drill-Down Scatter Plot

DAY 11: TABLEAU CHARTS - Level 1

Bubble Chart : Simple Bubble Chart
Bubble Chart with Measure Values
Bubble Chart with Measure Colors
Bullet Graph and Real-time Use
Box Plot Creating Box Plot Tableau
Creating Tree Map - Bump Chart
Bump Chart and Gantt Chart
Gantt Chart Versus Histogram
Motion Charts and Properties
Waterfall Charts and Properties

DAY 12 : 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

REAL-TIME CASE STUDY

Working with Tableau Prep

Working with Tableau Desktop

Cloud Data Sources, Mapping

Data Cleansing and LOD Expressions

Calculations and Dashboards

Storytelling with Analytics, Filters

DAY 13 : TABLEAU ONLINE

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
Java Script API in Table Online
Security Advantages @ Tableau Online

DAY 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
Performance Advantages @ Tableau Server

DAY 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

DAY 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

DAY 17 : MANAGE TABLEAU ONLINE

Tableau Online - Administration Concepts
Tableau Sites, Users and Groups Security
Schedules, Tasks, Status in Tableau Online
Settings and Alerts in Tableau Online
Tableau Bridge - Need, Requirements
Brdige Client Setup and Secured Usage
Tableau Bridge Client - LIVE Connections
Tableau Command Line Utility - Usage
R Integration with Tableau Online
Cloud Integration with Tableau Online

DAY 18 : 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

REAL-TIME CASE STUDY

Working with Tableau Online

Working with Tableau Server

Table Bridge with LIVE Edits

Data Refresh - Auto, Manual

Dashboards & Worksheets - Security

Users, Roles and Group Security

Python Training Course Contents: (Plan A)

Brochure Download

Register Today

Module I - Core Python	Module II - Advanced Python
CHAPTER 1 : Introduction to Script What is Script What is a program? Types of Scripts Difference between Script Programming Languages Features of Scripting Limitation of Scripting Types of programming Language Paradigms Basic understanding of Python Python and Other programming languages CHAPTER 2 : Introduction to Python What is Python? Why Python? Who Uses Python? Characteristics of Python History of Python What is PSF? Python Versions How to Download Python How to Install Python Install Python with Diff IDEs Features of Python Limitations of Python Python Applications Creating Your First Python Program Printing to the Screen Reading Keyboard Input Using Command Prompt and GUI or IDE Python Distributions Python first program Compilers VS interpreters CHAPTER 3 : Different Modes in PYTHON Execute the Script Interactive Mode Script Mode Python File Extensions SETTING PATH IN Windows Clear screen inside python Learn Python Main Function Python Comments Quit the Python Shell Shell as a Simple Calculator Order of operations Multiline Statements Quotations in Python Python Path Testing Joining two lines Python Implementation Alternatives Python Sub Packages Uses of Python in Data Science USES OF PYTHON IN IOT Working with Python in Unix/Linux/Windows/Mac/Android..!! CHAPTER 4 : PYTHON NEW IDEs PyCharm IDE How to Work on PyCharm PyCharm Components Debugging process 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 Kernels What is PIP? CHAPTER 5 : Variables in Python What is Variable? Variables in Python Constants in Python Variable and Value Variable names Mnemonic Variable Names Values and Types What Does “Type” Mean? Multiple Assignment Python different numerical types Standard Data Types Operators and Operands Order of Operations Swap variables Python Mathematics Type Conversion Mutable Versus Immutable Objects CHAPTER 6 : String Handling What is string? String operations String indices Basic String Operations String Functions, Methods Delete a string String Multiplication and concatenation Python Keywords Python Identifiers Python Literals String Formatting Operator Structuring with indentation in Python Built-in String Methods Define Data Structure? Data Structures in PYTHON CHAPTER 7: Python Operators and Operands Arithmetic Operators Relational Operators Comparison Operators Python Assignment Operators Short hand Assignment Operators Logical Operators or Bitwise Operators Membership Operators Identity Operators Operator precedence Evaluating Expressions CHAPTER 8 : Python Conditional Statements How to use “if condition” in conditional Structures 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 CHAPTER 9 : Python LOOPS How to use “While Loop” How to use “For Loop” How to use For Loop for set of other things besides numbers Break statements in For Loop Continue statement in For Loop Enumerate function for For Loop Practical Example How to use for loop to repeat the same statement over and again Break, continue statements CHAPTER 10 : Learning Python Strings Accessing Values in Strings Various String Operators Some more examples Python String replace() Method Changing upper and lower case strings Using “join” function for the string Reversing String Split Strings CHAPTER 11 : Sequence or Collections in PYTHON Strings Unicode Strings Lists Tuples Buffers Xrange CHAPTER 12 : Python Lists Lists are mutable Getting to Lists List indices Traversing a list List operations List slices List methods Map, filter and reduce Deleting elements Lists and strings CHAPTER 13 : Python TUPLE Advantages of Tuple over List Packing and Unpacking Comparing tuples Creating nested tuple Using tuples as keys in dictionaries Deleting Tuples Slicing of Tuple Tuple Membership Test Built-in functions with Tuple Dotted Charts CHAPTER 14 : Python Sets How to create a set? Iteration Over Sets Python Set Methods Python Set Operations Union of sets Built-in Functions with Set Python Frozenset CHAPTER 15 : Python Dictionary How to create a dictionary? PYTHON HASHING? Python Dictionary Methods Copying dictionary Updating Dictionary Delete Keys from the dictionary Dictionary items() Method Sorting the Dictionary Python Dictionary in-built Functions Dictionary len() Method Variable Types Python List cmp() Method Dictionary Str(dict) CHAPTER 16 : Python Functions What is a function? How to define and call a function in Python Types of Functions Significance of Indentation (Space) in Python How Function Return Value? Types of Arguments in Functions Default Arguments Non-Default Arguments Keyword Arguments Non-keyword Arguments Arbitrary Arguments Rules to define a function in Python Various Forms of Function Arguments Scope and Lifetime of variables Nested Functions Call By Value, Call by Reference Anonymous Functions/Lambda functions	CHAPTER 17 : Python Modules What is a Module? Types of Modules The import Statement The from…import Statement ..import * Statement Underscores in Python The dir( ) Function Creating User defined Modules Command line Arguments Python Module Search Path CHAPTER 18 : Packages in Python What is a Package? Introduction to Packages? py file Importing module from a package Creating a Package Creating Sub Package Importing from Sub-Packages Popular Python Packages CHAPTER 19 : 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? The Time Module Python Calendar Module Python Text Calendar Python HTML Calendar Class Unix Date and Time Commands CHAPTER 20 : File Handling What is a data, Information File? File Objects File Different Modes file Object Attributes How to create a Text File How to Append Data to a File How to Read a File Closing a file Read, read line ,read lines, write, write lines…!! Renaming and Deleting Files Directories in Python Working with CSV files Working with CSV Module Handling IO Exceptions CHAPTER 21 : Python OS Module Shell Script Commands 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 Time CHAPTER 22 : Python Exception Handling Python Errors Common RunTime Errors in PYTHON Abnormal termination Chain of importance Of Exception Exception Handling Try … Except Try .. Except .. else Try … finally Argument of an Exception Python Custom Exceptions Ignore Errors Assertions UsingAssertionsEffectively CHAPTER 23 : More Advanced PYTHON Python Iterators Python Generators Python Closures Python Decorators Python @property CHAPTER 24 : Python Class and Objects Introduction to OOPs Programming Object Oriented Programming System OOPS Principles Define Classes Creating Objects Class variables and Instance Variables Constructors Basic concept of Object and Classes Access Modifiers How to define Python classes Python Namespace Self-variable in python Garbage Collection What is Inheritance? Types of Inheritance? How Inheritance works? Python Multiple Inheritance Overloading and Over Riding Polymorphism Abstraction Encapsulation Built-In Class Attributes CHAPTER 25 : Python Regular Expressions What is Regular Expression? Regular Expression Syntax Understanding Regular Expressions Regular Expression Patterns Literal characters Repetition Cases Example of w+ and ^ Expression Example of \s expression in re.split function Using regular expression methods Using re.match() Finding Pattern in Text (re.search()) Using re.findall for text Python Flags Methods of Regular Expressions CHAPTER 26 : Python XML Parser What is XML? Difference between XML and HTML Difference between XML and JSON and Gson How to Parse XML How to Create XML Node Python vs JAVA XML and HTML CHAPTER 27 : Python-Data Base Communication What is Database? Types of Databases? What is DBMS? What is RDBMS? What is Big Data? Types of data? Oracle MySQL SQL server DB2 Postgre SQL Executing the Queries Bind Variables Installing of Oracle Python Modules Executing DML Operations..!! CHAPTER 28 : Multi-Threading What is Multi-Threading Threading Module Defining a Thread Thread Synchronization CHAPTER 29 : Multi-Threading What is Multi-Threading Threading Module Defining a Thread Thread Synchronization CHAPTER 30 : Web Scrapping The components of a web page BeautifulSoup Urllib2 HTML,CSS,JS,jQuery Dataframes PIP Installing External Modules Using PIP CHAPTER 31 : Unit Testing with PyUnit What is Testing? Types of Testings and Methods? What is Unit Testing? What is PyUnit? Test scenarios, Test Cases, Test suites CHAPTER 32 : Introduction to Python Web Frameworks Django – Design Advantages of Django MVC and MVT Installing Django Designing Web Pages HTML5, CSS3, AngularJS PYTHON Flask PYTHON Bottle PYTHON Pyramid PYTHON Falcon CHAPTER 33 : GUI Programming-Tkinter Introduction Components and Events Adding Controls Entry Widget, Text Widget, Radio Button, Check Button List Boxes, Menus, ComboBox CHAPTER 34 : Data Analytics Introduction to data Big Data? Introduction to NumPY and SciPY Introduction to Pandas and MatPlotLib CHAPTER 35 : Introduction to Machine Learning with PYTHON What is Machine learning? Machine Learning Methods Predictive Models Descriptive Models What are the steps used in Machine Learning? What is Deep Learning? CHAPTER 36 : Data Science What is Data Science? Data Science Life Cycle? What is Data Analysis What is Data Mining Analytics vs Data Science CHAPTER 37 : Internet of Things IMPACT OF THE INTERNET What is IOT History of IoT What is Network? What is Protocol? What is smart? How IoT Works? The Future of IoT

Module I - Core Python

Module II - Advanced Python

CHAPTER 1 : Introduction to Script

What is Script
What is a program?
Types of Scripts
Difference between Script
Programming Languages
Features of Scripting
Limitation of Scripting
Types of programming Language Paradigms
Basic understanding of Python
Python and Other programming languages

CHAPTER 2 : Introduction to Python

What is Python?
Why Python?
Who Uses Python?
Characteristics of Python
History of Python
What is PSF?
Python Versions
How to Download Python
How to Install Python
Install Python with Diff IDEs
Features of Python
Limitations of Python
Python Applications
Creating Your First Python Program
Printing to the Screen
Reading Keyboard Input
Using Command Prompt and GUI or IDE
Python Distributions
Python first program
Compilers VS interpreters

CHAPTER 3 : Different Modes in PYTHON

Execute the Script
Interactive Mode
Script Mode
Python File Extensions
SETTING PATH IN Windows
Clear screen inside python
Learn Python Main Function
Python Comments
Quit the Python Shell
Shell as a Simple Calculator
Order of operations
Multiline Statements
Quotations in Python
Python Path Testing
Joining two lines
Python Implementation Alternatives
Python Sub Packages
Uses of Python in Data Science
USES OF PYTHON IN IOT
Working with Python in
Unix/Linux/Windows/Mac/Android..!!

CHAPTER 4 : PYTHON NEW IDEs

PyCharm IDE
How to Work on PyCharm
PyCharm Components
Debugging process 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 Kernels
What is PIP?

CHAPTER 5 : Variables in Python

What is Variable?
Variables in Python
Constants in Python
Variable and Value
Variable names
Mnemonic Variable Names
Values and Types
What Does “Type” Mean?
Multiple Assignment
Python different numerical types
Standard Data Types
Operators and Operands
Order of Operations
Swap variables
Python Mathematics
Type Conversion
Mutable Versus Immutable Objects

CHAPTER 6 : String Handling

What is string?
String operations
String indices
Basic String Operations
String Functions, Methods
Delete a string
String Multiplication and concatenation
Python Keywords
Python Identifiers
Python Literals
String Formatting Operator
Structuring with indentation in Python
Built-in String Methods
Define Data Structure?
Data Structures in PYTHON

CHAPTER 7: Python Operators and Operands

Arithmetic Operators
Relational Operators
Comparison Operators
Python Assignment Operators
Short hand Assignment Operators
Logical Operators or Bitwise Operators
Membership Operators
Identity Operators
Operator precedence
Evaluating Expressions

CHAPTER 8 : Python Conditional

Statements
How to use “if condition” in conditional
Structures
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

CHAPTER 9 : Python LOOPS

How to use “While Loop”
How to use “For Loop”
How to use For Loop for set of other things besides numbers
Break statements in For Loop
Continue statement in For Loop
Enumerate function for For Loop
Practical Example
How to use for loop to repeat the same
statement over and again
Break, continue statements

CHAPTER 10 : Learning Python Strings

Accessing Values in Strings
Various String Operators
Some more examples
Python String replace() Method
Changing upper and lower case strings
Using “join” function for the string
Reversing String
Split Strings

CHAPTER 11 : Sequence or Collections in PYTHON

Strings
Unicode Strings
Lists
Tuples
Buffers
Xrange

CHAPTER 12 : Python Lists

Lists are mutable
Getting to Lists
List indices
Traversing a list
List operations
List slices
List methods
Map, filter and reduce
Deleting elements
Lists and strings

CHAPTER 13 : Python TUPLE

Advantages of Tuple over List
Packing and Unpacking
Comparing tuples
Creating nested tuple
Using tuples as keys in dictionaries
Deleting Tuples
Slicing of Tuple
Tuple Membership Test
Built-in functions with Tuple
Dotted Charts

CHAPTER 14 : Python Sets

How to create a set?
Iteration Over Sets
Python Set Methods
Python Set Operations
Union of sets
Built-in Functions with Set
Python Frozenset

CHAPTER 15 : Python Dictionary

How to create a dictionary?
PYTHON HASHING?
Python Dictionary Methods
Copying dictionary
Updating Dictionary
Delete Keys from the dictionary
Dictionary items() Method
Sorting the Dictionary
Python Dictionary in-built Functions
Dictionary len() Method
Variable Types
Python List cmp() Method
Dictionary Str(dict)

CHAPTER 16 : Python Functions

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

CHAPTER 17 : Python Modules

What is a Module?
Types of Modules
The import Statement
The from…import Statement
..import * Statement
Underscores in Python
The dir( ) Function
Creating User defined Modules
Command line Arguments
Python Module Search Path

CHAPTER 18 : Packages in Python

What is a Package?
Introduction to Packages?
py file
Importing module from a package
Creating a Package
Creating Sub Package
Importing from Sub-Packages
Popular Python Packages

CHAPTER 19 : 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?
The Time Module
Python Calendar Module
Python Text Calendar
Python HTML Calendar Class
Unix Date and Time Commands

CHAPTER 20 : File Handling

What is a data, Information File?
File Objects
File Different Modes
file Object Attributes
How to create a Text File
How to Append Data to a File
How to Read a File
Closing a file
Read, read line ,read lines, write, write lines…!!
Renaming and Deleting Files
Directories in Python
Working with CSV files
Working with CSV Module
Handling IO Exceptions

CHAPTER 21 : Python OS Module

Shell Script Commands
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
Time

CHAPTER 22 : Python Exception Handling

Python Errors
Common RunTime Errors in PYTHON
Abnormal termination
Chain of importance Of Exception
Exception Handling
Try … Except
Try .. Except .. else
Try … finally
Argument of an Exception
Python Custom Exceptions
Ignore Errors
Assertions
UsingAssertionsEffectively

CHAPTER 23 : More Advanced PYTHON

Python Iterators
Python Generators
Python Closures
Python Decorators
Python @property

CHAPTER 24 : Python Class and Objects

Introduction to OOPs Programming
Object Oriented Programming System
OOPS Principles
Define Classes
Creating Objects
Class variables and Instance Variables
Constructors
Basic concept of Object and Classes
Access Modifiers
How to define Python classes
Python Namespace
Self-variable in python
Garbage Collection
What is Inheritance? Types of Inheritance?
How Inheritance works?
Python Multiple Inheritance
Overloading and Over Riding
Polymorphism
Abstraction
Encapsulation
Built-In Class Attributes

CHAPTER 25 : Python Regular Expressions

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

CHAPTER 26 : Python XML Parser

What is XML?
Difference between XML and HTML
Difference between XML and JSON and Gson
How to Parse XML
How to Create XML Node
Python vs JAVA
XML and HTML

CHAPTER 27 : Python-Data Base Communication

What is Database? Types of Databases?
What is DBMS?
What is RDBMS?
What is Big Data? Types of data?
Oracle
MySQL
SQL server
DB2
Postgre SQL
Executing the Queries
Bind Variables
Installing of Oracle Python Modules
Executing DML Operations..!!

CHAPTER 28 : Multi-Threading

What is Multi-Threading
Threading Module
Defining a Thread
Thread Synchronization

CHAPTER 29 : Multi-Threading

What is Multi-Threading
Threading Module
Defining a Thread
Thread Synchronization

CHAPTER 30 : Web Scrapping

The components of a web page
BeautifulSoup
Urllib2
HTML,CSS,JS,jQuery
Dataframes
PIP
Installing External Modules Using PIP

CHAPTER 31 : Unit Testing with PyUnit

What is Testing?
Types of Testings and Methods?
What is Unit Testing?
What is PyUnit?
Test scenarios, Test Cases, Test suites

CHAPTER 32 : Introduction to Python Web

Frameworks
Django – Design
Advantages of Django
MVC and MVT
Installing Django
Designing Web Pages
HTML5, CSS3, AngularJS
PYTHON Flask
PYTHON Bottle
PYTHON Pyramid
PYTHON Falcon

CHAPTER 33 : GUI Programming-Tkinter

Introduction
Components and Events
Adding Controls
Entry Widget, Text Widget, Radio Button,
Check Button
List Boxes, Menus, ComboBox

CHAPTER 34 : Data Analytics

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

CHAPTER 35 : Introduction to Machine

Learning with PYTHON
What is Machine learning?
Machine Learning Methods
Predictive Models
Descriptive Models
What are the steps used in Machine Learning?
What is Deep Learning?

CHAPTER 36 : Data Science

What is Data Science?
Data Science Life Cycle?
What is Data Analysis
What is Data Mining
Analytics vs Data Science

CHAPTER 37 : Internet of Things

IMPACT OF THE INTERNET
What is IOT
History of IoT
What is Network?
What is Protocol?
What is smart?
How IoT Works?
The Future of IoT

Python & PL SQL Training Course Contents: (Plan B)

Brochure Download

Register Today

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 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 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 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

CHAPTER 5.SQL BASICS

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 6.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 7: 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

CHAPTER 8 : BUILT-IN FUNCTIONS in SQL

Arithmetic Functions
Character Functions
Date & Time Functions
Character, String Functions
Conversion Functions
General Functions
OLAP Functions
Rank(), Dense_Rank(),Row_Number()
NVL(),NVL2(), NullIF(),Coalesce()
Other Functions Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Nest multiple functions

CHAPTER 9 : CONSTRAINTS & KEYS – Level I

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

CHAPTER 10 : CONSTRAINTS & KEYS (Level II)

Multiple Constraints on Columns
Adding Constraints to Tables
Enabling - Dropping Constraints
Disabling Constraints on Tables
Querying for Constraints Information
Data Validations using Constraints
Constraints Limitations and Usage
System Table – User_Constraints
Column Level Constraints
Table level Constraints
Self Referential Key Constraints

CHAPTER 11 : 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
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 12 : 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

CHAPTER 13 : SUB QUERIES, CORRELATED QUERIES

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
Mulitple 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
Data Retrieval with EXISTS, NOT EXISTS

CHAPTER 14 : 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?
Types of Synonym
Public Synonym and Private Synonyms
All_Synonyms and Dba_Synonyms System Tables
Creating Index Tables – Purpose

CHAPTER 15 : 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
Materialized Views - Indexed Views
Composite Index
Function Based Index
User_indexes System Table
Rebuild Index
Partitioning Tables using PL/SQL
Working with Very Large Tables
Range Partitions and Hash Partition
Partion “VALUES LESS THAN “ Clause
List Partition and Composite Partition
Parallel Query Process with Partitions
Performance Tuning Advantages

CHAPTER 16 : PL/SQL (PROCEDURE LANGUAGE – SQL)

Introduction to Programming Languages
Introduction & Advantage of PL/SQL
PL/SQL Architecture, PL/SQL Data types
Difference between SQL and PL/SQL
PL-SQL Programming Structure
How PL/SQL Works?
Example of PL/SQL Features
Simple PL/SQL Programs
Printing Variables
DBMS_Output Package Usage
The %TYPE Attribute and %ROWTYPE Attribute
Variable and Constants, Using Built-in Functions
Conditional and Unconditional Statements

CHAPTER 17 : 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
Overview of PL/SQL Control Structures
PL/SQL Select statements
PL/SQL Delimiters
Iterations in PL/SQL, Simple LOOP, WHILE
FOR LOOP and NESTED LOOPS in PLSQL

CHAPTER 18 : PL/SQL – (CONTROL STRUCTURE) – Level II

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
Types of Cursors
Implicit Cursors
Explicit Cursors
Parameterized Cursors
REF Cursors
Record and PL/SQL Table Types. Real-time Use
What are Oracle-Supplied Packages?
Examples of Some of the Oracle-Supplied Packages
How Does the DBMS_OUTPUT Package Work?

CHAPTER 19: 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 how many locks are occurred?
LOCK Hints and Query Blocking

CHAPTER 20 : 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 21 : 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 22 : 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 Recycle Bin Table?
How to Delete Recycle Bin?
SQL Loader
Abstract Data types
DML Error Logging and Virtual Columns

CHAPTER 23 : ADVANCED PL/SQL - 4

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