Python Development

​

PYTHON

Course Content

1. Introduction

• What is Python..?

• A Brief history of Python

• Why Should I learn Python..?

• Installing Python

• How to execute Python program

• Write your first program

1. Variables & Data Types

• Variables

• Numbers

• String

• Lists, Tuples & Dictionary

1. Conditional Statements & Loops

• if…statement

• if…else statement

• elf…statement

• The while…Loop

• The for…. Loop

1. Control Statements

• continue statement

• break statement

• pass statement

1. Functions

• Define function

• Calling a function

• Function arguments

• Built-in functions

1. Modules & Packages

• Modules

• How to import a module…?

• Packages

• How to create packages

1. Classes & Objects

• Introduction about classes & objects

• Creating a class & object

• Inheritance

• Methods Overriding

• Data hiding

1. Files & Exception Handling

• Writing data to a file

• Reading data from a file

• Read and Write data from csv file

• try…except

• try…except…else

• finally

• os module

Module 3 : Getting started with Python Libraries

• what is data analysis ?

• why python for data analysis ?

• Essential Python Libraries

• Installation and setup

• Ipython

• Jupyter Notebook

• 7 VS 3.5

Module 4 :Working with Pandas

• Installing pandas

• Pandas data frames

• Pandas Series

• Data aggregation with Pandas Data Frames

• Concatenating and appending Data Frames

• Joining Data Frames

Module 5 : Data Loading, Storage and file format

• Writing CSV files with numpy and pandas

• JSON Data

• YAML Data

Module 6 : Python Regular Expressions

• What are regular expressions?

• The match Function

• The search Function

• Matching vs searching

• Search and Replace

• Extended Regular Expressions

• Wildcard

Module 7 : Python Oracle Database Access

• Install the cx_Oracle and other Packages

• Create Database Connection

• CREATE, INSERT, READ, UPDATE and DELETE Operation

• DML and DDL Oepration with Databases

• Performing Transactions

• Handling Database Errors

• Disconnecting Database

​

o

​