top
Corporate training

up - skill your team

Request Quote

Python, MySQL and Django Training

Learn about fundamentals of relational database server MySQL, including the concepts of Python to write reusable and maintainable code, concepts of Django to build robust web applications.

  • 30 hours of Instructor-led training
  • Beginner to Advanced level
  • Immersive hands-on sessions
GET FREE DEMO Schedules

Featured On

Modes of Delivery

Key Features

30 hours of Instructor-led sessions
Immersive hands-on learning
Learn about the basic and advanced concepts of Python, MySQL and Django
Grasp the fundamentals of the relational database server MySQL
Understand concepts of Django to build and deploy roburst and secured web apps
Develop lightweight, roburst, and secure web applications with features of Python, MySQL, and Django
Our Mentors will guide students in future implementation of these popular technologies

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 backend database. These technologies are popular because they are freely available and offer lightweight, yet robust and secure web applications. Zeolearn’s Python Django & MySQL training will teach you the fundamentals of these three technologies and help you through the basics to the advanced. By the end of the coaching, you would have sufficiently mastered the nuances through plenty of hands-on practical sessions and expert guidance from our tutors, to start building your own web apps.

Our Python Django training course is completely unique and our trainers teach you from beginner basics to advanced techniques. The cost of MySQL certification is affordable at our institute and we also offer free study materials to the registered candidates for future references.

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 Python Django course beneficial.

What do you need to be familiar with?

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

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

Frequently Asked Questions

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.

Related Courses

Front-End Development Bootcamp Kickstart your Front-End developer career with our immersive learning coding bootcamp, which includes best-in-class live training sessions. Front-End Development Bootcamp 30 hours of immersive training sessions Basic to professional level learning Build and deploy attractive web pages 500 300
HTML5 and CSS3 Learn how to design your own websites using old and new features of HTML5 and CSS3 including advanced navigation and website testing. HTML5 and CSS3 16 hours of immersive training sessions Basic to advanced level learning Create websites using features of HTML5 & CSS3 1250 458
MEAN Stack Development Learn to develop and route the Single Page Applications using MEAN Stack. Develop AngularJS Reusable Services, Filters and Directives. MEAN Stack Development 40 hrs of Immersive, Instructor led sessions Build complex web apps Learn Angular, Node, Express and MongoDB Beginner to Advanced Level 670 247
Angular 11 Create web based Single Page Applications using Angular 8. Learn how to make a static web page more interactive thus enhancing its user experience. Angular 11 20 hours of Interactive sessions Fundamental to Advanced level learning Build web based SPAs using Angular MVC Work on building SPAs of industry standards 2100 576
View all courses

Top Blogs

Python in a Nutshell: Everything That You Need to Know

Blog

The Ultimate Guide to Node.Js

Blog

MIT’s new automated ML runs 100x faster than human Data Scientists

What's New

Gartner says, by 2020, 2.3 Million jobs will be created by Artificial Intelligence

What's New

other trainings

How We Can Help You

Call us +1-646-568-9997
Live Chat
Drop a query
View Courses