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

2. Variables & Data Types

• Variables
• Numbers
• String
• Lists, Tuples & Dictionary

3. Conditional Statements & Loops

• if…statement
• if…else statement
• elf…statement
• The while…Loop
• The for…. Loop

4. Control Statements

• continue statement
• break statement
• pass statement

5. Functions

• Define function
• Calling a function
• Function arguments
• Built-in functions

6. Modules & Packages

• Modules
• How to import a module…?
• Packages
• How to create packages

7. Classes & Objects

• Introduction about classes & objects
• Creating a class & object
• Inheritance
• Methods Overriding
• Data hiding

8. 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 5: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 6: Data Loading, Storage and file format

• Writing CSV files with numpy and pandas
• JSON Data
• YAML Data

Module 7: Python Regular Expressions

• What are regular expressions?
• The match Function
• The search Function
• Matching vs searching
• Search and Replace
• Extended Regular Expressions
• Wildcard

Module 8: 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

Module9: Django

Module10: Flask
Module11: RESTAPI
Module 12: Plotting Graph on HTML Page

• Introducing Matplotlib
• Bar Charts
• Line Charts
• Scatter plots
• Bubble charts

DJANGO

1. Introduction to Django Web Framework
2. Introduction to REST and API
3. Introduction to Restful Webservices
4. Django Rest Framework(DRF)
5. DRF Advantages and Constraints
6. Difference between Django and REST API
7. REST API pre-requisites
8. REST API Configuration and Installation
9. Serialization and Deserialization
10. JSON and XML
11. Action and handler methods
12. Function based and class based views
13. API Views
14. Mixins

FLASK
Section 1

Introduction to Flask

Using Python packages

Web frameworks

Decorators

Routes

Running Flask locally

Building a basic dynamic site

Debugging a Python program

Python Part 2

Booleans

Conditional Statements

Lists

Indexing into strings + lists

Looping over lists

Section 2

Flask Exercises Part 1

Using HTML templates

Jinja2 templating language

Building a guess-the-number site

Building a fortune teller site

Python Part 3

Dictionaries

APIs + JSON

Requests package

Parsing a JSON response

Section 3

Flask Exercises Part 2

Advanced Flask features

Building a stock price site

Building a weather site

Deploying Your Website

Using a Platform-as-a-Service (PaaS)

DNS basics

Adding a custom domain

Designing RESTful Web APIs
Rest API Overview

What Is REST?

Course Overview

History of Distributed Computed

HTTP in a Nutshell

HTTP in Action

What is REST

An Example of a Well Designed API

What We’ve Learned

Designing a RESTful API

Introduction

Designing for REST

Demo: Using URIs

Design Verbs

Demo: Using Verbs

Idempotency in Action

Understanding Idempotency

Designing Results

Demo: Designing Your Results

Formatting Results

Demo: Formatting Results

Hypermedia

What We’ve Learned

Handling More Complex Scenarios in Your API

Introduction

Designing Associations

Demo: Associations

Designing Paging

Demo: Paging

Error Handling

Demo: Error Handling

Designing Caching

Demo: Caching with ETags

Functional APIs

Demo: Functional APIs

Asynchronous APIs

What We’ve Learned

Versioning Your API

Introduction

Should You Version Your APIs

Designing Versioning

Demo: Versioning Strategies

What We’ve Learned

Locking Down Your API

Introduction

APIs and Security

Cross Domain Security

Authentication and Authorization

Authentication Types

Understanding OAuth

What We’ve Learned

Data Base –
Understanding the Database Schema

Using Python SQL Libraries to Connect to a Database

SQLite

MySQL

PostgreSQL

Creating Tables

SQLite

MySQL

PostgreSQL

Inserting Records

SQLite

MySQL

PostgreSQL

Selecting Records

SQLite

MySQL

PostgreSQL

Updating Table Records

SQLite

MySQL

PostgreSQL

Deleting Table Records

SQLite

MySQL

PostgreSQL