Course Outline

Introduction to SQLite database

• Overview
• Create Database
• Create Table
• Drop-Table
• Insert query
• Select query
• Delete and Update query
• WHERE AND & OR Clause

Regular Expression

• RegEx Module
• Match object
• RegEx Functions:search, findall,sub
• Match at the beginning or end
• Metacharacters
• Special Sequences

GUI Programming with Tkinter

• Introduction
• Saying Hello with Labels
• Buttons
• Message Widget
  • Entry Widget
  • Dialogs
  • Radiobutton and Checkboxes
  • Creating Menus
  • Events and Binds

Django: A web framework

1. Introduction
   • What is Django..?
   • Installing Django
   • The MVC framework
   • Why use Django..?
2. Creating a Django Project
   • Starting a project with Django
   • Creating an application
   • Configuring the application
   • Hello World with Django
   • Creating our first URL
   • Creating our first view
   • Testing our application
3. Working with Templates
   • Template Basic
   • Injecting the data from view to the template
   • Built-in Tags & filters
   • Integrating variables in templates
     • Extending the templates
   • Using static files in templates
4. Models
   • Define models
   • Creating a simple model
   • Save a model into a Database
   • Inserting & Editing Data
   • Getting a Model data with Queryset
   • Deleting Objects
   • Implementing Foreign key
   • Extending a model
5. Django Admin Interface
   • Enabling admin interface
   • Creating an admin user
6. Django Forms
   • Forms in Django
   • Searching Query
   • GET & POST methods
   • Form fields in Django
   • Building a form in Django
   • Model-based form
     • Custom validation
7. The Authentication Module
   • How to use the authentication module
   • Adding a user
   • Login and logout
   • Built-in Decorators
   • Restricting access to unknown users

Project

• Calculator with Tkinter
• A Web App using Django