Learn python programming now from Calicut,Kerala,India

baabtra.com provides python programming courses  which helps students/graduates learn cutting edge skills in python and its frameworks to buildsecure & interactive web applications. Nobody else other than baabtra.com provides such industry oriented training in python or its frameworks in calicut
COURSE OUTLINE
MYSQL

Part I :  Data Persistence – RDBMS Concepts with Mysql

  • Introduction to RDBMS
    • Different types of database available
    • Entity relationship models
    • Basics of RDBMS concepts
  • DDL,DML,DCL statements

 

Part 2: Mysql Joins.Functions, Grouping

  • Scalar and Aggregate Functions
  • Grouping Data with aggregate functions, Having clause
  • Relevance Of joins
  • Different types of Joins
    • Inner Join
    • Outer Join
      • Right outer join
      • Left Outer Join

 

Part 3: Stored Procedures

 

  • Stored Procedures and its advantages
  • IN,OUT,INOUT Parameters
  • Control structures in SQL with stored Procedures
  • SQL handlers
  • Cursors with stored procedures
  • User Defined Functions (UDF)
  • Difference between UDF and SP

 

Part 4: Transactions, Views, indexing

 

  • Transactions
    • Relevance of transaction
    • Rollback and Commit
    • Example scenario with transaction
  • Views
  • Query optimization – Database indexing
  • Database Normalization

 PYTHON

 Part I :  Introduction to Python

  • Setting up the environment- Windows/ Linux
  • How to use Python
  • Introducing the Python Interpreter
  • Program Execution

Part II :  Basic Data Types in Python

  • Numbers
    • Operations on all numeric types
    • Strings
      • Operations on Strings
      • String formatting with the % operator
      • String slicing
      • Sequences
        • Lists
          • Operation on mutable sequences(type list)
    • Tuple
      • Operations on tuple
    • Dictionaries
      • Operations on mappings/dictionaries(type dict)
    • Operations on all sequence types(lists, tulples, strings)
    • Sets
      • Main Set operations
      • Sequence slicing

Part III :  Operators in Python

  • Operators and their evaluation order
  • Comparisons (defined between any types)
  • Boolean Operators

Part IV :  Some Python Statements

  • The print statement
  • The break statement
  • The continue statement
  • The else clause on loop statements
  • The pass statement
  • The range() function

Part V : Control Flow statements

  • The If statement
  • The While statement
  • The for statement

Part VI :  Functions

  • The return statement
  • Calling functions
  • Keyword Arguments

Part VII: Object Oriented Python

  • Classes and Instances
  • The class statement
  • Function definitions in a class body
  • Instances
  • _ _init_ _
  • Inheritance

 

 

Part VIII: Exceptions

  • The Try statement
  • Try/except
  • Try/finally
  • Built in exception classes

 

Part IX: Modules

  • The import statement
  • The from statement
  • The relative import

 

Part X: Built in Types

Part XI : Built in Functions

Part XII:(Optional) GTK and GUI development with Glade

  • Introduction to GTK
  • GUI development with Glade
  • Connecting GLADE interface with python

DJANGO- Framwork

Part I : Introduction to Django

  • What is Django?
  • Django and Python
  • Django’s take on MVC: Model, View and Template
  • DRY programming: Don’t Repeat Yourself
  • How to get and install Django

Part II : Getting started with Django

  • About the 3 Core Files:
    • models.py
    • urls.py
    • views.py
    • Setting up database connections
    • Managing Users & the Django admin tool

Part  III : Django URL Patterns and Views

  • Designing a good URL scheme
  • Generic Views

Part  IV : Django Forms

  • Form classes
  • Validation
  • Authentication
  • Advanced Forms processing techniques

Part V : Django & REST APIs

  • Django REST framework
  • Django-piston

Part VI: Unit Testing with Django

  • Overview / Refresher on Unit Testing and why it’s good
  • Using Python’s unittest2 library
  • Test
  • Test Databases

 

About Ijasali Manalody