Track
Software Development
Duration
60 hours
Skill Level
Foundation
Language
English
About this Course
Understand Python scripting and use MySQL for database connectivity and operations.
Learning Mode: Learn at ALC or at Home
Detailed Course Curriculum
Hands-on module breakdown aligned with MKCL production standards and industry requirements.
- History of Python
- Versions of Python
- Features of Python
- Limitations of Python
- Scripting Languages vs Programming Languages
- Applications of Python
- Python2 vs Python 3
- What is Python used for?
- Flavors of Python
- Python compared to other Languages
- Python vs Java
- How does Python work?
- What is PVM?
- Compiler vs Interpreter
- Compile Time vs Run Time
- Future Scope of Python and Career Opportunities
- What is Memory Management?
- Memory Management in various Programming Languages
- Memory vs Storage
- Three Areas of Memory Management
- How important is Memory Management?
- Memory Management
- Memory management in Python
- Allocator Domain
- Allocation Domains in detail
- Python Memory Manager
- The Default Python Implementation C Python
- GIL
- Python Memory Allocation
- Garbage Collection
- Ways to make an object eligible for Garbage Collection
- Reference Counting in Python
- Cyclical Reference or Reference Cycle
- Generational Garbage Collection
- C Python Memory Management
- Common Ways to reduce the Space Complexity
- Python Installation on Windows
- Adding Python to Environmental Variable
- Checking Python Version on Windows
- Verifying Pip Installation
- What are IDE and IDLE Editors?
- How to run Python Program using IDLE?
- IDE’s Installation -
- How to install Visual Studio?
- Thony installation
- Executing Python Program
- Identifiers and rules to Write Identifiers
- Constants, Variables and Literals
- Keywords or Reserved Keywords
- Python Comments
- Python comments
- Benefits of using Python comments
- Python Syntax
- Lines and Indentation
- Python User Input
- Data Types in Python
- Text Data Type
- Numeric Types
- Sequence Type
- Mapping Types
- Set Types
- Boolean Types
- Binary Types
- None Type
- Type Casting
- Operators in Python
- Arithmetic Operators
- Assignment Operators
- Comparison Operators
- Logical Operators
- Identity Operators
- Membership Operators
- Bitwise Operators
- Precedence and Associativity of Operators
- Ternary Operator
- What are Control Flow Statements in Python?
- Decision Control Statements
- Simple if
- If else
- Nested If
- If elif else
- Elif ladder
- Shorthand if, if else
- Multiple Conditions using and or Operator
- Transfer Statements
- Break
- Continue
- Pass
- Iterative statements
- For
- While
- Nested For loop
- Pattern Programs
- Data Types in brief
- How to access String and Indexing?
- String Slicing
- Mutable and Immutable
- Mathematical Operators for String (+,*)
- Comparison of String
- String Membership
- Format String
- Escape Character
- Removing Spaces from String
- Finding Substring
- Counting Substring and Len()
- Replacing a String
- Splitting and Joining of String
- Changing Case of a String
- Checking starting and ending part of the String
- Methods to check type of Characters present in String
- List and its Creation
- Accessing Elements of List
- List Mutability
- List Traversing
- Functions of List
- Manipulating List
- append()
- insert()
- extend()
- remove()
- Ordering Elements of List
- Aliasing and Cloning of List Object
- Use of Mathematical Operators for List
- Comparison and Membership Operators
- Nested List
- List Comprehension
- What is Tuple
- Creating a Tuple
- Accessing through Tuple
- Tuple Methods
- Mathematical and Membership Operators
- Iterating through Tuple
- Updating Tuple
- Nesting of Tuple
- Tuple Comprehension
- Unpack Tuple
- Difference between Tuple and List
- Zipping of Tuples
- Creating Sets
- Modifying Sets
- Removing Elements from set
- Python set Operation
- Set Method
- Built in Functions
- Set Comprehension
- Frozen Sets
- How to create Dictionary
- Accessing Dictionary
- Update Dictionary
- Delete the elements from dictionary
- Python dictionary methods
- Membership and iterating through in dictionary
- Important functions in dictionary pt1
- Dictionary Comprehension
- Nested Dictionary
- Built in Functions
- User Defined Function
- Docstrings
- Calling a function in python
- Types of Arguments
- Variable Length Arguments
- Scope of variables
- Types of Variables
- Recursive Functions
- Namespaces
- Nested Functions
- Benefits of functions
- Anonymous function
- Lambda Function in detail
- filter, map and reduce function
- map()
- reduce()
- properties of function
- Decorators
- Chaining Decorators
- Magic Method
- Iterables
- Iterator and Iterations
- Yield Keyword
- Generators
- Iterators vs Generators
- Python Generator expression
- What is module?
- How to create a module?
- Possibilities of Import
- Built in Modules
- Finding Members of module
- The Special Variable Name
- Packages
- Library
- Commonly used libraries
- Random Module
- Math Module
- PIL
- Movie Py Module
- PyScreenShot Module
- Date Class
- Time Class
- Date Time Class
- Time Delta class
- Open File
- Properties of Files
- Read & Write Operation
- Seek and tell method
- OS Module
- Working with Directories
- Handling binary data
- CSV Files
- Zip and Unzip
- Types of Errors
- Exception
- Exception Handling Hierarchy
- Customized Exception Handling
- Control Flow in Try and Except
- Multiple Exceptions
- Default Exception
- Finally Block
- Control Flow in try except and finally
- Else with try except finally
- Types of Exception
- Assert Keyword
- Python Loggers
- What is log and log file in programming?
- Levels of log messages
- Using basicConfig
- Formatting
- Classes and functions
- Logging Handlers
- Stream Handlers
- File Handlers
- Working with Handlers
- Exception Information
- JSON
- Json
- JSON Syntax
- Datatypes in JSON
- Read ,Write and Parse JSON
- Python Object Conversions
- Python to JSON
- Formatting the results
- Serializing
- Parse JSON
- Deserialize
- Pickling & Unpickling
- What is Reg ex
- Character Classes
- Quantifiers
- Functions of Re-Module
- Find all methods - Important functions of re module
- Symbols
- Web scrapping using reg exp
- Multitasking
- Difference between Multiprocessing and multi-threading
- Difference between Process and Thread
- Ways of creating thread in python
- Difference in program with and without Multithreading
- Thread Identification Number
- Functions/Methods in Multithreading
- Daemon Thread
- Synchronization
- Difference between lock and semaphore
- Thread Communication
- Inter Thread Communication
- Concurrency and parallelism
- Race Condition and DeadLock
- Collection Modules
- Counters
- Ordered dict
- default dict
- chain map
- Named Map
- DeQue
- User Dict
- UserList
- User String
- Object Oriented vs Procedural Oriented
- What is Class?
- What is Object ?
- Constructor
- Self Keyword
- Functions vs Method
- Types of Variables
- Static variable
- Local Variable
- Instance Variable
- Class Method
- Static Method
- Inner Class
- Garbage Collection in OOP’s
- Destructor
- Inheritance
- Inheritance
- Built in function in oops
- Single Inheritance
- Constructor super()
- Multiple inheritance
- Method Resolution Order (MRO)
- Multilevel Inheritance
- Hierarchical Inheritance
- Hybrid Inheritance
- Polymorphism
- Polymorphism
- Polymorphism with class methods
- Polymorphism with functions and objects
- Overloading
- Operator Overloading
- Magic Method for operator overloading
- Method Overloading
- Constructor Overloading
- Method Overriding
- Method overriding with multiple and multilevel inheritance
- Constructor Overriding
- Type System
- Duck Typing
- Abstraction
- Types of Methods in Python
- How to declare an abstract method in Python
- Concrete Methods in Abstract Base Classes
- Missed Abstract methods in implementation
- Abstract classes contain more subclasses?
- Different cases for Abstract class object creation
- Built in Abstract Classes
- Interfaces
- Create a Python Interface
- Python Interfaces vs Abstract Class
- Encapsulation
- Python Access Modifiers
- Why we need Encapsulation
- Calculator
- Password Generator
- Tic Tac Toe
- Rock Paper Scissors
- Chat Bot
- BMI Calculator
- Story Generator
- Quiz Game
- Create Acronyms
- Intro
- Introduction to Tkinter
- Widgets in Tkinter
- Tkinter Geometry
- Python Tkinter Button
- Python Tkinter Canvas
- Python Tkinter CheckButton
- Python Tkinter Entry
- Python Tkinter Frame
- Python Tkinter Label
- Python Tkinter Listbox
- Python Tkinter MenuButton
- Python Tkinter Menu
- Tkinter Project Calendar
- Intro
- Python Tkinter Message
- Python Tkinter RadioButton
- Python Tkinter Scale
- Python Tkinter Scrollbar
- Python Tkinter Text
- Python Tkinter Toplevel
- Python Tkinter SpinBox
- Python Tkinter Paned Window
- Python Tkinter Label Frame
- Python Tkinter MessageBox
- Python GUI PyQt5- Part 1 intro
- PyQt5 Introduction
- Modules and tools
- PyQt5 First Program
- PyQt5 Layouts
- QVBoxLayout and QHBoxLayout
- QGridLayout
- QFormLayout
- QStackedLayout
- Signals and slots
- PyQt5 Widgets
- QLabel
- QLineEdit
- QPushButton
- QRadioButton
- QCheckBox
- QComboBox
- QSpinBox
- QSlider
- QMenuBar, QMenu & QAction
- QToolBar
- QInputDialog
- QFontDialog
- QFileDialog
- QTab
- QStacked
- QSplitter
- QDock
- QStatusBar
- QList
- QScrollBar
- QCalendar
- Qmessagebox
- Multiple document interface
- Drag and Drop
- Drawing API
- Clipboard
- BrushStyle Constants
- QPixmap Class
- Database handling
- Project 1- Text Editor
- Project 2- Calculator
- Python Turtle intro
- Introduction to Python Turtle
- Moving and Drawing with turtle
- First Turtle Program
- Turtle program on pen control
- Program- Event handling
- Program on working state of the turtle module
- Working with turtle screen
- Program Colourful Star Pattern
- Turtle Methods
- Program - Draw a hut using turtle module
- Pygame intro
- Pygame Introduction
- Basic structure of a Pygame program
- Basic Pygame concepts
- Pygame - Display Modes
- Pygame - Color Object
- Pygame - Event Objects
- Keyboard Events
- Mouse Events
- Pygame - Drawing Shapes
- Pygame - Using Image
- Pygame - Displaying Text
- Pygame - Moving an Image
- Pygame - Use Text as Buttons
- Pygame - Transforming Images
- Pygame - Sound Objects
- Playing Music
- Pygame - Load Cursor
- Pygame - The Sprite Module
- Snake Game
- Basic SQL intro
- Database and RDBMS
- Introduction to SQL
- SQL Subset
- RDBMS concepts
- Installing MySQL on windows
- Simple SQL queries
- SQL Expression
- SQL Operators
- DDL Operations
- DML Operations
- Functions in SQL
- Advanced SQL intro
- SQL Subqueris
- SQL Clause
- SQL Joins
- SQL Union
- SQL Group by
- SQL Views
- SQL Indexes
- SQL Transactions
- Python Programming with MySQL intro
- MySQL Database
- Install MySQL Driver
- Check if Database Exists
- Python MySQL Create Table
- Check if Table Exists
- Primary Key
- Python MySQL Insert Into Table
- Insert Multiple Rows
- Python MySQL Select From
- Selecting Columns
- Python MySQL Where
- Python MySQL Order By
- Python MySQL Delete From By
- Python MySQL Drop Table
- Python MySQL Update Table
- Python MySQL Limit
- Python MySQL Join
Eligibility Criteria
• Basic knowledge of computers and keen desire to build skills in this field.
• Open to students, job seekers, and working professionals.
• Open to students, job seekers, and working professionals.
Official Certification
• Official MKCL KLiC Certificate upon successful completion of the course and evaluations.
Work-Centric Learning Approach
• Step 1: Learners are given an overview of the course and its connection to life and work
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
Ready to start Python and MYSQL Fundamentals?
Join our upcoming batch at ZICA Kalyani center with certified instructors.
Other MKCL Courses
-
Python
120 hours -
Mobile App Development
120 hours -
Advanced C# Programming Techniques
30 hours -
Advanced Concepts of C#
60 hours