Python, MySQL and Django Training & Ceritification Course

  • Overview
  • Course Content
  • Drop us a Query

Learning the fundamentals of Python, MySQL, and Django will help you in building and deploying robust web applications with database interface and security. Python, MySQL and Django Training will teach you how to build web applications is by using Python as the programming language, MySQL as the backend database, and Django as the web framework.

We, at Multisoft Solutions, are helping the working professionals with nominally charged Python, MySQL and Django Training. Backed by an experienced training team, our training house provides free study materials to the candidates. Our trainers prefer real-life examples and hands-on practical sessions.

Upon the completion of this course, the candidates will be able to:
  • The programming concepts of the popular Python language
  • Scale, manage memory and run your applications on various platforms
  • Build and deploy robust web applications with database interface and security
  • The fundamentals of the relational database server MySQL
  • How to write reusable and maintainable code
Target Audience:
  • Python developers
  • Web programmers
  • Students who want to learn about complete web application development
Prerequisites
  • Basic knowledge of object-oriented concepts
  • Basic knowledge of basic programming concepts
  • Basic knowledge of database concepts

Module 1: Getting started with Python

  • Installations and versions 2.x and 3.x
  • History of Python
  • Why to use Python?
  • Starting Python
  • Interpreter PATH
  • Using the Interpreter
  • Running a Python Script
  • Python Scripts on UNIX/Windows
  • Python Editors and IDEs
  • Using Variables, Keywords
  • Built-in Functions
  • Strings, Different Literals, Math Operators and Expressions
  • Writing to the Screen
  • String Formatting
  • Command Line Parameters

Module 2: Flow Control in-depth

  • About Flow Control
  • Indenting is significant
  • The if and elif statements
  • while loops
  • Using lists
  • Using the for statement
  • The range() function

Module 3: Sequences and File Operations

  • Lists
  • Tuples
  • Indexing and Slicing
  • Iterating through a Sequence
  • Functions for all Sequences
  • Using Enumerate()
  • Operators and Keywords for Sequences
  • The xrange() function
  • List Comprehensions
  • Generator Expressions
  • Dictionaries and Sets

Module 4: Functions

  • Syntax of function definition
  • Formal parameters
  • Global versus local variables
  • Passing parameters and returning values

Module 5: Working with Files

  • Text file I/O overview
  • Opening a text file
  • Reading text files
  • Raw (binary) data
  • Using the pickle module
  • Writing to a text file

Module 6: Errors and Exception Handling

  • Dealing with syntax errors
  • Exceptions
  • Handling exceptions with try/except
  • Cleaning up with finally

Module 7: Dictionaries and Sets

  • Dictionary overview
  • Creating dictionaries
  • Dictionary functions
  • Fetching keys or values
  • Testing for existence of elements
  • Deleting elements

Module 8: Using Modules

  • The Import Statement
  • Module Search Path
  • Package Installation Ways

Module 9: Regular Expressions

  • RE Objects
  • Pattern matching
  • Parsing data
  • Subexpressions
  • Complex substitutions
  • RE tips and tricks

Module 10: Object Oriented Programming in Python

  • Introduction to Python Classes
  • Defining Classes
  • Initializers
  • Instance Methods
  • Properties
  • Class Methods and Data
  • Static Methods
  • Private Methods and Inheritance
  • Module Aliases and Regular Expressions

Module 11: MySQL

  • Creating Database tables in Python
  • Database Inserts and Selects in Python
  • Multiple Inserts, Updates, and Complex MySQL Selects in Python

Module 12: Creating Reports with MySQL and Python

  • Overview of Project Reports
  • Syntax of creating Project reports

Module 13: Django

  • How to install and Configure Django components
  • How to create Django views?
  • About View Functions
  • Using Django's HttpResponse Class
  • Understanding HttpRequest Objects
  • Using QueryDict Objects

Module 14: Configuring URLconf's

  • About URLconf
  • Regular Expressions
  • Expression Examples
  • Simple URLConf Examples
  • Using Multiple URLConf's
  • Passing URL Arguments

Module 15: Django Templates

  • About Templates
  • Template Fundamentals
  • Creating Template Objects
  • Loading Template Files
  • Filling in Template Content (Context Objects)
  • Template Filters
  • Template Tags
  • More on For Loops
  • Template Inheritance
  • Easy Rendering of Templates
  • RequestContext Processors
  • Global Context Processor

Module 16: Django Forms

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

Module 17: Django and REST APIs

  • Django REST framework/li>
  • Django-piston

Module 18: Unit testing with Django

  • Using Python’s unittest2 library
  • Test
  • Test Databases
  • Doctests
  • Debugging

Module 19: Database models

  • About Database Models
  • Configuring Django for Database Access
  • Understanding Django Apps
  • About Django Models
  • Defining Django Models
  • Understanding Model Fields & Options
  • Table Naming Conventions
  • Creating A Django Model
  • Adding the App to Your Project
  • Validating the App
  • Generating & Reviewing the SQL
  • Adding Data to the Model
  • Primary Keys and the Model
  • Simple Data Retrieval Using a Model
  • Understanding QuerySets
  • Applying Filters
  • Specifying Field Lookups
  • Lookup Types
  • Slicing QuerySets
  • Specifying Ordering in QuerySets
  • Common QuerySet Methods
  • Deleting Records
  • Managing Related Records
  • Retrieving Related Records
  • Using Q Objects
  • Creating Forms from Models

Module 20: Using Django Admin Interface

  • Enabling the Admin Interface
  • Creating an Admin User

Module 21: Access Control with Sessions and Users

  • Cookies & Django
  • The Django Session Framework
  • Sessions in Views
  • Session Tuning
  • Installing Django User Authentication
  • Using Authentication in Views
  • Login and Logout
  • Building your Own Login/Logout Views
  • Authentication Decorators
  • Adding & Deactivating Users
  • Asynchronous Messaging
  • Managing Permissions

Module 22: Generic Views

  • Simple Generic Views
  • Using Generic Redirects
  • Other Generic Views
  • Create/Update/Delete Generic views

Module 23: Data Caching for Performance

  • Data Caching
  • Setting up Per-View Caching
  • Site Caching

Module 24: Django's Email Functionality

  • Configuring Mail Settings
  • Sending Email
  • Other Email Functions

Module 25: Deploying Django Applications

  • Deploying Django Applications

A Few Things You'll Love!

What our Students Speak

+
1
×
Hello

How can help you?