Python Classroom Training

Python uses dynamic typing, and a combination of reference counting and a cycle-detecting garbage collector for memory management. It also features dynamic name resolution (late binding), which binds method and variable names during program execution. Register Today

 

Python Training Plans

Description PLAN A PLAN B
Python PL-SQL + Python
Duration 4 Weeks 6 Weeks
Database Fundamentals Croos-symbol-for-No Check-Symbol-for-Yes
SQL Basics with DDL, DML, SELECT Croos-symbol-for-No Check-Symbol-for-Yes
SQL Queries with Constraints, Keys Croos-symbol-for-No Check-Symbol-for-Yes
Normal Forms and Relationship Type Croos-symbol-for-No Check-Symbol-for-Yes
Writing Queries, Sub Queries, Joins Croos-symbol-for-No Check-Symbol-for-Yes
Writing Sub Queries, Nested Queries Croos-symbol-for-No Check-Symbol-for-Yes
Excel Imports and Pivot Tables with SQL Croos-symbol-for-No Check-Symbol-for-Yes
Basics of Stored Procedures, Functions Croos-symbol-for-No Check-Symbol-for-Yes
Python Fundamentals (Basics) Check-Symbol-for-Yes Check-Symbol-for-Yes
Python Modes and new IDEs Check-Symbol-for-Yes Check-Symbol-for-Yes
Variables, Strings, Operations, Functions Check-Symbol-for-Yes Check-Symbol-for-Yes
Sequence, Lists, Tuple, Sets Check-Symbol-for-Yes Check-Symbol-for-Yes
Date & Time, Dictionary, Python Modes Check-Symbol-for-Yes Check-Symbol-for-Yes
File Handling and Exception Handling Check-Symbol-for-Yes Check-Symbol-for-Yes
Python Classes, XML Parser, Web Scrapping Check-Symbol-for-Yes Check-Symbol-for-Yes
Unit Testing, Python Web, Data Analytics Check-Symbol-for-Yes Check-Symbol-for-Yes
Data Science and Machine Learning Intro Check-Symbol-for-Yes Check-Symbol-for-Yes
Total Course Fee INR 5,000/- INR 8,000/-

Python & PL SQL Training Schedules :

S No Timings (IST) Demo Date Start Date  
Schedules for Python Training
1 4 PM - 5 PM Sept 4th Sept 5th Register
2 11 AM - 1 PM (wk) Aug 24th Aug 25th Register
Schedules for PL-SQL (Plan B)
1 6:45 AM - 7:45 AM Sept 12th Sept 13th Register
2 8:00 AM - 9:00 AM Completed Aug 20th Register
3 10:15 AM - 11:15 AM Sept 3rd sept 4th Register
4 3:00 PM - 4:00 PM Sept 17th Sept 18th Register
5 9:00 AM - 11:00 AM (wk) Aug 24th Aug 25th Register

All Sessions Are Completely Practical & Real-Time.

 

Python Training Course Contents: (Plan A)

Python Basics - Level I

Python Basics - Level II

Module II: Advanced Python

DAY 1 : INTRODUCTION TO SCRIPT

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

DAY 9 : Python TUPLE

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

 Python Sets

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

DAY 17 : Python Regular Expressions

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

DAY 2 : INTRODUCTION TO PYTHON

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

DAY 10 : Python Dictionary

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

DAY 18 : Python-Data Base Communication

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

DAY 3 : DIFFERENT MODE IN PYTHON

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

DAY 11 : Python Functions

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

DAY 19 : Multi-Threading

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

DAY 4 : PYTHON NEW IDEs

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

 Variables in Python

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

DAY 12 : Python Modules

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

DAY 20 : Introduction to Python Web

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

DAY : 5 Python Operators and Operands

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

DAY 13 : Packages in Python

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

DAY 21 : GUI Programming-Tkinter

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

DAY 6 : String Handling

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

DAY 14 : Python Date and Time

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

DAY 22: Data Analytics

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

Data Science

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

DAY 7 : Python Conditional

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

DAY 15 : Python OS Module

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

DAY 23 : Internet of Things

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

DAY : 8 Python LOOPS

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

 Sequence or Collections and Lists

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

DAY 16 : Python Class and Objects

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

DAY 24 : Introduction to Machine Learning

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

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

Module 1: Basic SQL

Applicable For Plan B

Module 2: SQL & PL SQL

Applicable For 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 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 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 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 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 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 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
 
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 LIVE Server.
 

Python Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
 
 
  • Python Modes and new IDEs
  • Variables, Strings, Operations, Functions
  • Sequence, Lists, Tuple, Sets
  • Date & Time, Dictionary, Python Modes
  • File Handling and Exception Handling
  • Unit Testing, Python Web, Data Analytics
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T