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 Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Data Modeling with Tableau Tools Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
ETL and ELT Process with Tableau Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Tableau Prep and Data Mash-up Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Big Data Access in Tableau Reports Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Paginated Reports, Interactive Reports Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Table Cloud Confi, Report Hosting Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Row Level Security (RLS) with Tableau Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Adv Settings, Data Refresh, Rest API Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
DDL, DML, SELECT, DCL, TCL Cmds Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
SQL Joins, Queries and Sub Queries Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Query Tuning and Excel Integration Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Basics of SPs, Functions, Transactions Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Using SQL with Real-world Reports Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Python Fundamentals (Basics) Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Python Modes and new IDEs Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Sequence, Lists, Tuple, Sets Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
File Handling and Exception Handling Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Python Classes, XML Parser Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Unit Testing, Python Web Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Web Scrapping, Data Analytics Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Data Science & Machine Learning Intro Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
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

Register Today

Tableau Training Course Contents:

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)

    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)

    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

    CHAPTER 24: IMPLEMENTING OBJECT TECHNOLOGY – Level I