Python Training

What is Python and history of Python?

Why Python and where to use it?

Discussion about Python version

Set up Python environment for development

Demonstration on Python Installation

Discuss about IDE’s like IDLE, Pycharm and Sublime

Discussion about unique feature of Python

Write first Python Program

Start programming on interactive shell

Python keywords and Identifiers

Interactive and Programming techniques

Comments and document interlude in Python

Practical use cases using data analysis

Python statements and indentation

Comments in python and Command line arguments

Python Core Objects and builtin functions

Number Object and operations

String Object and Operations

List Object and Operations

Tuple Object and operations

Lists, tuples & Dictionary

Dictionary Object and operations

Set object and operations

Different data Structures, data processing

Boolean Object and None Object

What are various type of functions

Create UDF functions

Parameterize UDF function, through named and unnamed parameters

The anonymous Functions - Lambda Functions

String Object functions

List and Tuple Object functions

Dictionary Object functions

Python inbuilt Modules

Os, sys, date time, time, random, zip modules

Create Python UDM – User Defined Modules

Define PYTHONPATH

init File for package initialization

Python Exceptions Handling

What is Exception?

Handling various exceptions using try....except...else

Try-finally clause

Argument of an Exception and create self exception class

Python Standard Exceptions

Raising an exceptions, User-Defined Exceptions

Object oriented features

Understand real world examples on OOP

Implement Object oriented with Python

Creating Classes and Objects, Destroying Objects

Accessing attributes, Built-In Class Attributes

Inheritance and Polymorphism

Overriding Methods, Data Hiding

Overloading Operators

Debug Python programs using pdb debugger

Pycharm Debugger

Assert statement for debugging

What are regular expressions?

The match and search Function

Compile and matching

Matching vs searching

Search and Replace feature using RE

Extended Regular Expressions

Wildcard characters and work with them

Creating a Database with PostgresSQL

CRUD Operations

Creating a Database Object

Python PostgresSQL Database Access

DML and DDL Operations with Databases

Performing Transactions

Handling Database Errors

Disconnecting Database

Install package using Pycharm

What is pip, easy install

Set up the environment to install packages?

Python package and structure