Create new account
Forgot Password
timezone settings
Python, Django and MySQL
Rated 4.0/5 based on 352 Votes customer reviews

Python, MySQL and Django Training

  • Instructor Led Live online training
  • 30 hours immersive Hands-on training sessions
  • Live coding experience
  • Get mentored by Industry Experts
  • Build a website using Python,Mysql and Django
  • Log into the sessions from wherever you are
100% Moneyback Guarantee
Any Questions? Contact Us

Online Classroom

Instructor Led Live Online Training
USD 1699 USD 1499 Select Date & Enroll

Team / Corporate Training

Description

A popular way of building the three-tiered architecture for web applications is by using Python as the programming language, Django as the web framework and MySQL as the back end database. These technologies are popular because they are freely available and offer lightweight, yet robust and secure web applications.

Zeolearn’s comprehensive track will teach you the fundamentals of these three technologies and help you through the basics to the advanced. By the end of the course, you would have sufficiently mastered the nuances through plenty of hands-on exercises and expert guidance from our faculty, to start building your own web apps.

Here’s what you will learn!

  • The programming concepts of the popular Python language and how to write reusable and maintainable code.
  • The fundamentals of the relational database server MySQL which will allow you to scale, manage memory and run your applications on various platforms.
  • The concepts of Django that will allow you to build and deploy robust web applications with database interface and security.

Is this course right for you?

Python developers, web programmers and students who want to learn about complete web application development will find this course beneficial.

What do you need to be familiar with?

  • Knowledge of basic programming concepts
  • Knowledge of object oriented concepts
  • Knowledge of database concepts

Highlights

Instructor Led Online Classes

Live interactive training from expert faculty, access the class from anywhere.

Learn by doing

Cement your learning through hands-on assignments where you will be mentored.

Flexible Schedule

Convenient weekday and weekend batches, making it easy to attend.

Money Back Guarantee

Not happy? Opt out within one day, and get a refund!

Your Satisfaction, Assured

Get a chance to attend any other live batch of the same course for free.

Lifetime Access

Get lifetime access to your class recording to refresh your learning at any time in the future.

Curriculum

  1. Installations and versions 2.x and 3.x
  2. History of Python
  3. Why to use Python?
  4. Starting Python
  5. Interpreter PATH
  6. Using the Interpreter
  7. Running a Python Script
  8. Python Scripts on UNIX/Windows
  9. Python Editors and IDEs
  10. Using Variables, Keywords
  11. Built-in Functions
  12. Strings, Different Literals, Math Operators and Expressions
  13. Writing to the Screen
  14. String Formatting
  15. Command Line Parameters
  1. About Flow Control
  2. Indenting is significant
  3. The if and elif statements
  4. while loops
  5. Using lists
  6. Using the for statement
  7. The range() function
  1. Lists
  2. Tuples
  3. Indexing and Slicing
  4. Iterating through a Sequence
  5. Functions for all Sequences
  6. Using Enumerate()
  7. Operators and Keywords for Sequences
  8. The xrange() function
  9. List Comprehensions
  10. Generator Expressions
  11. Dictionaries and Sets
  1. Syntax of function definition
  2. Formal parameters
  3. Global versus local variables
  4. Passing parameters and returning values
  1. Text file I/O overview
  2. Opening a text file
  3. Reading text files
  4. Raw (binary) data
  5. Using the pickle module
  6. Writing to a text file
  1. Dealing with syntax errors
  2. Exceptions
  3. Handling exceptions with try/except
  4. Cleaning up with finally
  1. Dictionary overview
  2. Creating dictionaries
  3. Dictionary functions
  4. Fetching keys or values
  5. Testing for existence of elements
  6. Deleting elements
  1. The Import Statement
  2. Module Search Path
  3. Package Installation Ways
  1. RE Objects
  2. Pattern matching
  3. Parsing data
  4. Subexpressions
  5. Complex substitutions
  6. RE tips and tricks
  1. Introduction to Python Classes
  2. Defining Classes
  3. Initializers
  4. Instance Methods
  5. Properties
  6. Class Methods and Data
  7. Static Methods
  8. Private Methods and Inheritance
  9. Module Aliases and Regular Expressions
  1. Creating Database tables in Python
  2. Database Inserts and Selects in Python
  3. Multiple Inserts, Updates, and Complex MySQL Selects in Python
  1. Overview of Project Reports
  2. Syntax of creating Project reports
  1. How to install and Configure Django components?
  2. How to create Django views?
  3. About View Functions
  4. Using Django's HttpResponse Class
  5. Understanding HttpRequest Objects
  6. Using QueryDict Objects
  1. About URLconf
  2. Regular Expressions
  3. Expression Examples
  4. Simple URLConf Examples
  5. Using Multiple URLConf's
  6. Passing URL Arguments
  1. About Templates
  2. Template Fundamentals
  3. Creating Template Objects
  4. Loading Template Files
  5. Filling in Template Content (Context Objects)
  6. Template Filters
  7. Template Tags
  8. More on For Loops
  9. Template Inheritance
  10. Easy Rendering of Templates
  11. RequestContext Processors
  12. Global Context Processors
  1. Form classes
  2. Validation
  3. Authentication
  4. Advanced Forms processing techniques
  1. Django REST framework
  2. Django-piston
  1. Using Python’s unittest2 library
  2. Test
  3. Test Databases
  4. Doctests
  5. Debugging
  1. About Database Models
  2. Configuring Django for Database Access
  3. Understanding Django Apps
  4. About Django Models
  5. Defining Django Models
  6. Understanding Model Fields & Options
  7. Table Naming Conventions
  8. Creating A Django Model
  9. Adding the App to Your Project
  10. Validating the App
  11. Generating & Reviewing the SQL
  12. Adding Data to the Model
  13. Primary Keys and the Model
  14. Simple Data Retrieval Using a Model
  15. Understanding QuerySets
  16. Applying Filters
  17. Specifying Field Lookups
  18. Lookup Types
  19. Slicing QuerySets
  20. Specifying Ordering in QuerySets
  21. Common QuerySet Methods
  22. Deleting Records
  23. Managing Related Records
  24. Retrieving Related Records
  25. Using Q Objects
  26. Creating Forms from Models
  1. Enabling the Admin Interface
  2. Creating an Admin User
  1. Cookies & Django
  2. The Django Session Framework
  3. Sessions in Views
  4. Session Tuning
  5. Installing Django User Authentication
  6. Using Authentication in Views
  7. Login and Logout
  8. Building your Own Login/Logout Views
  9. Authentication Decorators
  10. Adding & Deactivating Users
  11. Asynchronous Messaging
  12. Managing Permissions
  1. Simple Generic Views
  2. Using Generic Redirects
  3. Other Generic Views
  4. Create/Update/Delete Generic views
  1. Data Caching
  2. Setting up Per-View Caching
  3. Site Caching
  1. Configuring Mail Settings
  2. Sending Email
  3. Other Email Functions
Deploying Django Applications

faq

Python is a reliable and safe programming language while MySQL is among the most widely used backend databases used around the world. Using Python and MySQL, Django, a light yet robust framework provides secure and dependable web applications. These three are now among the most popular trio of technologies used by web developers.

Given that most web applications are now being built around these, it is prudent to know the hands on working of Python, MySQL and Django to have a lucrative career in web development. Zeolearn’s course will help you thoroughly grasp the fundamentals of these technologies with lots of practice sessions and expert guidance by our faculty.

After completing our course, you will be able to:

  • Master the basic and advanced concepts of Python, MySQL and Django
  • Learn how to connect the Django framework with the MySQL database
  • Learn the features of MySQL that will allow you to develop convenient administrator user interfaces, full text search and replication of data
  • Learn about REST APIs and how to integrate with them
  • Unit test and debug Django apps
  • Develop secure websites by integrating features of Django

Towards the end of the course, all participants will be required to work on a project to get hands on familiarity with the concepts learnt. You will learn to build web application using Python programming language, MySQL database and Django framework, with full support from your mentors. This project, which can also be a live industry project, will be reviewed by our instructors and industry experts. On successful completion, you will be awarded a certificate.

Classes are held on weekdays and weekends. You can check available schedules and choose the batch timings which are convenient for you.

You may be required to put in 10 to 12 hours of effort every week, including the live class, self study and assignments.

  • Your classes will be held online. All you need is a windows computer with good internet connection to attend your classes online. A headset with microphone is recommended.
  • You may also attend these classes from your smart phone or tablet.

Don’t worry, you can always access your class recording or opt to attend the missed session again in any other live batch.

Corporates who have up-skilled their teams