Tableau Training

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?

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?