C & C++ Programming and Python with MYSQL Fundamentals

Build a strong programming foundation in C, C++, Python, and connect with MySQL databases.

C & C++ Programming and Python with MYSQL Fundamentals
Course Features:
  • Language: English
  • list-box-outline Track: Software Development
  • Duration: 120 hours
  • layers-outline Level: Foundation
  • Learning Mode: Learn at ALC or Learn at Home
  • Jurisdiction: Maharashtra
  • Certificate of Completion
Eligibility
  • Learner should preferably a std. 10th Pass student (Not Compulsory)
  • It is desirable that Learner should have done MS-CIT Course (Not Compulsory)
List of ALCs

Introduction

  • Introduce the Fundamentals of C Programming: Learners will learn the basic concepts of C programming including variables, data types, and operators to understand how simple programs are constructed.
  • Understand Control Structures: Explore decision-making, looping, and case control structures to manage the flow of a C program.
  • Master Functions and Pointers: Gain proficiency in using functions and pointers for modular programming and effective memory management.
  • Deep Dive into Data Structures: Understand the implementation and application of essential data structures like arrays, structures, and pointers.
  • Explore Advanced Features of C: Cover advanced topics such as storage classes, preprocessors, bit manipulation, and C under Windows to enhance program functionality and efficiency.
  • Develop Proficiency in File Handling: Learn how to handle files for input/output operations and understand file manipulation at a deeper level.
  • Implement Object-Oriented Concepts in C++: Transition from C to C++ programming to embrace object-oriented programming paradigms.
  • Leverage C++ for GUI Development and Graphics: Utilize C++ for graphical user interface development and graphical applications in Windows.
  • Understand Exception Handling and Templates in C++: Master advanced C++ features including templates and exception handling to write robust and high-performance software.
  • Prepare for Real-world Programming: Through practical case studies and projects, prepare Learners for actual programming scenarios in business and gaming.
  • Understand the fundamentals of Python programming and its history.
  • Explain the importance of memory management in programming languages, especially Python.
  • Install Python and set up the development environment on various operating systems.
  • Identify and use different data types and operators in Python.
  • Implement control flow statements to dictate the execution flow of Python programs.
  • Manipulate and process strings using Python's built-in methods.
  • Work with lists and understand their properties and methods in Python.
  • Handle exceptions and manage errors in Python programs.
  • Utilize Python's logging module and work with JSON data.
  • Apply object-oriented programming principles using Python.

What you'll learn ?

  • Write Efficient C Programs: Learners will be able to develop C programs using basic and advanced concepts effectively.
  • Utilize Control Structures: Learners will demonstrate the ability to use various control structures in C for building logical parts of the program.
  • Implement Functions and Pointers: Learners will understand the use of functions and pointers to reduce complexity and increase the efficiency of programs.
  • Operate with Data Structures: Learners will be skilled in implementing and manipulating data structures to solve real-world problems.
  • Apply Advanced C Concepts: Learners will integrate advanced programming techniques and storage classes in their software solutions.
  • Manage Files Effectively: Learners will acquire the ability to perform critical file operations, enhancing their capability to handle data persistently.
  • Develop Object-Oriented Applications: Learners will transition to object-oriented programming using C++ to build scalable and maintainable software.
  • Create GUI and Graphics with C++: Learners will learn to develop graphical user interfaces and simple graphics programs, preparing them for applications in various domains.
  • Handle Exceptions and Use Templates: Learners will utilize templates for generic programming and manage exceptions to build reliable applications.
  • Complete Real-world Projects: Learners will demonstrate the ability to apply their knowledge to complete substantial projects that simulate real-world tasks.
  • Describe the history and evolution of Python, its versions, features, and limitations.
  • Explain how memory is managed in Python, including memory allocation, garbage collection, and reference counting.
  • Install Python on Windows, configure environment variables, and set up IDEs such as Visual Studio and Thonny.
  • Identify and use various data types (text, numeric, sequence, mapping, etc.) and operators (arithmetic, logical, bitwise, etc.) in Python.
  • Write programs that use control flow statements such as if-else, loops (for, while), and transfer statements (break, continue, pass) to control the execution flow.
  • Perform string operations such as concatenation, slicing, formatting, and searching within strings using built-in methods.
  • Create and manipulate lists, including performing operations such as appending, inserting, extending, and using list comprehensions.
  • Implement error handling using try-except blocks, create custom exceptions, and manage multiple exceptions effectively.
  • Configure Python loggers, format log messages, and work with JSON data for reading, writing, and parsing in Python applications.
  • Implement object-oriented concepts such as classes, objects, inheritance, polymorphism, and encapsulation in Python programs.

Certification

  • KLiC courses are recognised by Yashwantrao Chavan Maharashtra Open University (YCMOU).
  • MKCL provides certificate to the KLiC learner after his/her successful course completion.
  • Yashwantrao Chavan Maharashtra Open University (YCMOU) provides mark sheet to successfully passed KLiC learners (Jurisdiction: Maharashtra).

Academic Approach

The academic approach of the courses focuses on the “work-centric” education i.e. begin with work (and not from a book!), derive knowledge from work and apply that knowledge to make the work more wholesome, useful and delightful. The ultimate objective is to empower the Learner to engage in socially useful and productive work. It aims at leading the learner to his/her rewarding career as an employee or entrepreneur as well as development of the community to which s/he belongs. Learning methodology:

  • 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!

Syllabus

    1. Brief Introduction
    1. Programming Language
    1. About C Programming
    1. C Character Set
    1. Constants, Variables & Keywords
    1. Constants in C
    1. Variables in C
    1. Writing a C Program
    1. Instructions and Assignments
    1. Basic Operators in C Programming
    1. Decisions Control Structure & the If Statement
    1. The if-else Statement
    1. Use of Logical Operators
    1. Different types of Operators
    1. Points to remember
    1. Loops and the While loop
    1. While Loop
    1. For Loop
    1. Operators in Loop
    1. The Odd Loop
    1. Break Statement
    1. Continue Statement
    1. do-while loop
    1. Tips to remember
    1. Decisions using switch
    1. The Tips and Traps
    1. Switch versus if-else Ladder
    1. The goto keyword
    1. About Functions
    1. Passing Values between Functions
    1. Scope Rule of Functions
    1. Calling Convention
    1. One Dicey Issue
    1. Advanced Features of Functions
    1. Function Declaration and Prototypes
    1. Call by Value or Call by Reference
    1. An Introduction to Pointers
    1. Pointer Notation
    1. Function Calls
    1. Basics of Call by value and call by reference
    1. Conclusions
    1. Recursion
    1. Recursion and Stack
    1. Adding Functions to the Library
    1. Data type
    1. Integer number variables
    1. Integers, signed and unsigned
    1. Chars, signed and unsigned
    1. Floats and Doubles
    1. Issues related to Data types
    1. Storage Classes in C
    1. Automatic Storage Class
    1. Register Storage Class
    1. Static Storage Class
    1. External Storage Class
    1. To study the Ground rules for the Storage Class
    1. Features of C Preprocessor
    1. Preprocessor and Macro Directives
    1. Macros with Arguments and Macros versus Functions
    1. Various Directives
    1. About Array
    1. Usage of Arras
    1. Pointers and Arrays
    1. Passing an Entire Array to a Function
    1. Two Dimensional Arrays
    1. Initializing a 2-Dimensional Array
    1. Memory Map of a 2-Dimensional Array
    1. Pointers and 2-Dimensional Arrays
    1. Pointer to an Array 295
    1. Passing 2-D array to a Function
    1. Array of Pointers
    1. Three Dimensional Array
    1. What are Strings?
    1. Pointers and Strings
    1. Standard Library String Functions
    1. Two-Dimensional Array of Characters
    1. Array of Pointers to Strings
    1. Limitations of Array of Pointers to Strings
    1. Why Use Structures?
    1. Declaring a Structure
    1. Accessing Structure Elements
    1. Array of Structures
    1. Additional Features of Structures
    1. Uses of Structures
    1. Types of I/O
    1. Formatted Console I/O Functions
    1. sprintf( ) and sscanf( ) Functions
    1. Unformatted Console I/O Functions
    1. Data Organization
    1. File Operations
    1. Opening a File
    1. Reading from a File
    1. Trouble in Opening a File
    1. Closing the File
    1. Counting Characters, Tabs, Spaces
    1. A File-copy Program
    1. Writing to a File
    1. File Opening Modes
    1. String (line) I/O in Files
    1. The Awkward Newline
    1. Record I/O inFiles
    1. Text Files and Binary Files
    1. Record I/O Revisited
    1. Database Management
    1. Low Level Disk I/O
    1. A Low Level File-copy Program
    1. I/O Under Windows
    1. Using argc and argv
    1. Detecting Errors in Reading/Writing
    1. Explanation
    1. Standard I/O Devices
    1. I/O Redirection
    1. Redirecting the Output
    1. Redirecting the Input & Both Ways at Once
    1. Binary System & Bitwise Operators
    1. Bitwise AND Operator
    1. Bitwise OR Operator
    1. Bitwise XOR Operator
    1. One's Complement Operator
    1. Shift Operator
    1. The showbits( ) Function
    1. Enumerated Data Type and its uses
    1. Understanding with a Program
    1. Renaming Data Types with typedef
    1. Typecasting
    1. Bit Fields
    1. Pointers to Functions
    1. Functions Returning Pointers
    1. Functions with Variable Number of Arguments
    1. Unions & Union of Structure
    1. Uses of Windows
    1. Integers
    1. The Use of typedef
    1. Pointers in the 32-bit World
    1. Memory Management & Device Access
    1. DOS Programming Model
    1. Windows Programming Model
    1. Event Driven Model & Windows programming
    1. The First Windows Program
    1. Hungarian Notation
    1. The Role of a Message Box
    1. Here Comes the windows
    1. More Windows
    1. A Real-World Window
    1. Creation and Displaying of Window
    1. Interaction with Window
    1. Reacting to Messages
    1. Program Instances
    1. Graphics fundamentals
    1. Device Independent Drawing
    1. Hello Windows program
    1. Drawing Shapes
    1. Types of Pens
    1. Types of Brushes
    1. Code and Resources
    1. Freehand Drawing, the Paintbrush Style
    1. Capturing the Mouse
    1. Device Context, a Closer Look
    1. Displaying a Bitmap
    1. Animation at Work
    1. WM_CREATE and On Create( )
    1. WM_TIMER and On Timer( )
    1. Points to remember
    1. Hardware Interaction
    1. Hardware Interaction, DOS Perspective
    1. Hardware Interaction, Windows Perspective
    1. Communication with Storage Devices
    1. The Read Sector( ) Function
    1. Accessing Other Storage Devices
    1. Communication with Keyboard
    1. Dynamic Linking
    1. Windows Hooks
    1. Caps Locked, Permanently
    1. Mangling Keys
    1. Key Logger
    1. What is Linux
    1. C Programming Under Linux
    1. The ‘Hello Linux’ Program
    1. Processes
    1. Parent and Child Processes
    1. More Processes
    1. Zombies and Orphans
    1. Communication using Signals
    1. Handling Multiple Signals
    1. Registering a Common Handler
    1. Blocking Signals
    1. Event Driven Programming
    1. Introduction to Memory Map
    1. Memory Organization
    1. Segmentation
    1. Loading OS & Booting Process
    1. The resident and transient memory area
    1. Program memory area at run time
    1. Memory representation of data & function objects
    1. Introduction
    1. Lexical pitfalls
    1. Exceptions, String & characters
    1. Understanding Declaration
    1. Exceptions in Operators' precedence
    1. Use of Semicolons
    1. The Switch statement
    1. Calling functions
    1. The Dangling else problem
    1. Linkages
    1. External Types
    1. Expression evaluation sequence
    1. Issues related to actual parameters
    1. Eshew Synecdoche
    1. Library Function
    1. Preprocessor
    1. Portability pitfalls
    1. Signed & Unsigned characters
    1. Random numbers
    1. Portability problems
    1. The Beginning
    1. Structured Programming
    1. Object Oriented Programing
    1. Characteristics of Object-Oriented Programing
    1. Comments
    1. Flexible Declarations
    1. Structure, union and enum Syntax
    1. Anonymous unions and enums
    1. Typecasting
    1. Void Pointers
    1. The: Operator
    1. References
    1. The const Qualifier
    1. Constructors for Intrinsic Data Types
    1. The bool Data Typecasting to C++
    1. Function Prototypes
    1. Function Overloading
    1. Default Arguments in Functions
    1. Operator Overloading
    1. Inline Functions
    1. Static, virtual and friend Functions
    1. Classes and Constructors
    1. Destructors
    1. A Complex Class
    1. Overloaded Operators Revisited
    1. The this Pointer
    1. Overloading Unary Operators
    1. Function Definition Outside The Class
    1. Function Definition outside The Class
    1. New and delete Operators
    1. Using new and delete
    1. malloc ( )/free( ) versus new/ delete
    1. The Matrix Class
    1. Classes, Objects and Memory
    1. Structures and Classes
    1. Free Store Exhaustion
    1. Custom new and delete Operators
    1. Overloading new/delete in Classes
    1. Understanding The sequence
    1. Construction at Predetermined Location
    1. One Last Issue
    1. Static Class Data
    1. Static Member Functions
    1. const and Classes
    1. Overloaded Assignment Operator, Copy Constructor
    1. Data Conversion
    1. Data Conversion between Object of Different Classes
    1. Stacks and Queues
    1. The Linked List
    1. Stacks and Queues Revisited
    1. Trees
    1. Binary Trees
    1. Traversal of a Binary Tree
    1. Deletion from a Binary Tree
    1. More Inheritance
    1. Some More Inheritance
    1. Multiple Levels of Inheritance
    1. Multiple Inheritance
    1. Constructors in Multiple Inheritance
    1. A Word of Caution
    1. Private Inheritance
    1. Protected Inheritance
    1. Functions That Are Not Inherited
    1. Incremental Development
    1. Pure Virtual Functions
    1. Virtual Functions under the Hood
    1. Why virtual Functions?
    1. Virtual Functions in Derived Classes
    1. Object Slicing
    1. Virtual Functions and Constructors
    1. Destructors and virtual Destructors
    1. Virtual Base Classes
    1. Putting it All Together
    1. The iostream Library
    1. The ios Class
    1. Manipulators
    1. Creating Our Own Manipulators
    1. User-defined Manipulators with Arguments
    1. Come GUI and…
    1. The istream Class
    1. The ostream Class
    1. The iostream Class
    1. The with assign Classes
    1. Predefined Stream Objects
    1. Outputting Strings
    1. A Brief Review
    1. File I/O with Streams
    1. A Better way
    1. A File copy Program
    1. File Opening Modes
    1. Binary I/O
    1. Elementary Database Management
    1. Class That Read/Write Themselves
    1. Errors during I/O
    1. File copy Program Revisited
    1. Overloading <>
    1. Str streams
    1. Automatic Storage Allocation
    1. Sending Output to Printer
    1. Classes Within Classes
    1. friend Functions
    1. Overloading << and >>
    1. One More Use Of friend Function
    1. friend Classes
    1. A Word of Caution
    1. Smart Pointers
    1. More Smart Pointers
    1. Pointers to Members
    1. The explicit Keyword
    1. The mutable Keyword
    1. Namespaces
    1. Using A Namespace
    1. RTTI
    1. When to Use RTTI
    1. Typecasting in C++
    1. Function Templates
    1. A Template Based Quick Sort
    1. Class Templates
    1. A Linked List Class Template
    1. Tips about List Class Template
    1. Checking Function Return Value
    1. setjmp( ) and longjmp( )
    1. Exception Handling in C++
    1. Exception with Arguments
    1. Tic Tac Toe Game
    1. Student Management System
    1. Student Attendance Management System
    1. Event Management System
    1. Hangman Game
    1. Employee Leave Management System
    1. Furniture Business System
    1. Society Management System
    1. What is Python?
    1. History of Python
    1. Versions of Python
    1. Features of Python
    1. Limitations of Python
    1. Scripting Languages vs Programming Languages
    1. Applications of Python
    1. Python2 vs Python 3
    1. What is Python used for?
    1. Flavors of Python
    1. Python compared to other Languages
    1. Python vs Java
    1. How does Python work?
    1. What is PVM?
    1. Compiler vs Interpreter
    1. Compile Time vs Run Time
    1. Future Scope of Python and Career Opportunities
    1. What is Memory Management?
    1. Memory Management in various Programming Languages
    1. Memory vs Storage
    1. Three Areas of Memory Management
    1. How important is Memory Management?
    1. Memory Management
    1. Memory management in Python
    1. Allocator Domain
    1. Allocation Domains in detail
    1. Python Memory Manager
    1. The Default Python Implementation C Python
    1. GIL
    1. Python Memory Allocation
    1. Garbage Collection
    1. Ways to make an object eligible for Garbage Collection
    1. Reference Counting in Python
    1. Cyclical Reference or Reference Cycle
    1. Generational Garbage Collection
    1. C Python Memory Management
    1. Common Ways to reduce the Space Complexity
    1. Python Installation on Windows
    1. Adding Python to Environmental Variable
    1. Checking Python Version on Windows
    1. Verifying Pip Installation
    1. What are IDE and IDLE Editors?
    1. How to run Python Program using IDLE?
    1. IDE's Installation -
  • i. How to install Visual Studio?
  • ii. Thony installation
    1. Executing Python Program
    1. Identifiers and rules to Write Identifiers
    1. Constants, Variables and Literals
    1. Keywords or Reserved Keywords
    1. Python Comments
    • i. Python comments
    • ii. Benefits of using Python comments
    1. Python Syntax
    1. Lines and Indentation
    1. Python User Input
  • Data Types in Python
    • i. Text Data Type
    • ii. Numeric Types
    • iii. Sequence Type
    • iv. Mapping Types
    • v. Set Types
    • vi. Boolean Types
    • vii. Binary Types
    • viii. None Type
    • ix. Type Casting
    1. Operators in Python
    1. Arithmetic Operators
    1. Assignment Operators
    1. Comparison Operators
    1. Logical Operators
    1. Identity Operators
    1. Membership Operators
    1. Bitwise Operators
    1. Precedence and Associativity of Operators
    1. Ternary Operator
    1. What are Control Flow Statements in Python?
    1. Decision Control Statements
    1. Simple if
    1. If else
    1. Nested If
    1. If elif else
    1. Elif ladder
    1. Shorthand if, if else
    1. Multiple Conditions using and or Operator
  • Transfer Statements
    • i. Break
    • ii. Continue
    • iii. Pass
  • Iterative statements
    • i. For
    • ii. While
    • iii. Nested For loop
  • Pattern Programs
    1. Data Types in brief
    1. How to access String and Indexing?
    1. String Slicing
    1. Mutable and Immutable
    1. Mathematical Operators for String (+,*)
    1. Comparison of String
    1. String Membership
    1. Format String
    1. Escape Character
    1. Removing Spaces from String
    1. Finding Substring
    1. Counting Substring and Len()
    1. Replacing a String
    1. Splitting and Joining of String
    1. Changing Case of a String
    1. Checking starting and ending part of the String
    1. Methods to check type of Characters present in String
    1. List and its Creation
    1. Accessing Elements of List
    1. List Mutability
    1. List Traversing
    1. Functions of List
    1. Manipulating List
    • i. append()
    • ii. insert()
    • iii. extend()
    • iv. remove()
    1. Ordering Elements of List
    1. Aliasing and Cloning of List Object
    1. Use of Mathematical Operators for List
    1. Comparison and Membership Operators
    1. Nested List
    1. List Comprehension
    1. What is Tuple
    1. Creating a Tuple
    1. Accessing through Tuple
    1. Tuple Methods
    1. Mathematical and Membership Operators
    1. Iterating through Tuple
    1. Updating Tuple
    1. Nesting of Tuple
    1. Tuple Comprehension
    1. Unpack Tuple
    1. Difference between Tuple and List
    1. Zipping of Tuples
    1. Creating Sets
    1. Modifying Sets
    1. Removing Elements from set
    1. Python set Operation
    1. Set Method
    1. Built in Functions
    1. Set Comprehension
    1. Frozen Sets
    1. How to create Dictionary
    1. Accessing Dictionary
    1. Update Dictionary
    1. Delete the elements from dictionary
    1. Python dictionary methods
    1. Membership and iterating through in dictionary
    1. Important functions in dictionary pt1
    1. Dictionary Comprehension
    1. Nested Dictionary
    1. Built in Functions
    1. User Defined Function
    1. Docstrings
    1. Calling a function in python
    1. Types of Arguments
    1. Variable Length Arguments
    1. Scope of variables
    1. Types of Variables
    1. Recursive Functions
    1. Namespaces
    1. Nested Functions
    1. Benefits of functions
    1. Anonymous function
    1. Lambda Function in detail
    1. filter, map and reduce function
    1. map()
    1. reduce()
    1. properties of function
    1. Decorators
    1. Chaining Decorators
    1. Magic Method
    1. Iterables
    1. Iterator and Iterations
    1. Yield Keyword
    1. Generators
    1. Iterators vs Generators
    1. Python Generator expression
    1. What is module?
    1. How to create a module?
    1. Possibilities of Import
    1. Built in Modules
    1. Finding Members of module
    1. The Special Variable Name
    1. Packages
    1. Library
    1. Commonly used libraries
    1. Random Module
    1. Math Module
    1. PIL
    1. Movie Py Module
    1. PyScreenShot Module
    1. Date Class
    1. Time Class
    1. Date Time Class
    1. Time Delta class
    1. Open File
    1. Properties of Files
    1. Read & Write Operation
    1. Seek and tell method
    1. OS Module
    1. Working with Directories
    1. Handling binary data
    1. CSV Files
    1. Zip and Unzip
    1. Types of Errors
    1. Exception
    1. Exception Handling Hierarchy
    1. Customized Exception Handling
    1. Control Flow in Try and Except
    1. Multiple Exceptions
    1. Default Exception
    1. Finally Block
    1. Control Flow in try except and finally
    1. Else with try except finally
    1. Types of Exception
    1. Assert Keyword
  • Python Loggers
    • i. What is log and log file in programming?
    • ii. Levels of log messages
    • iii. Using basicConfig
    • iv. Formatting
    • v. Classes and functions
    • vi. Logging Handlers
    • vii. Stream Handlers
    • viii. File Handlers
    • ix. Working with Handlers
    • x. Exception Information
  • JSON
    • i. Json
    • ii. JSON Syntax
    • iii. Datatypes in JSON
    • iv. Read ,Write and Parse JSON
    • v. Python Object Conversions
    • vi. Python to JSON
    • vii. Formatting the results
    • viii. Serializing
    • ix. Parse JSON
    • x. Deserialize
    • xi. Pickling & Unpickling
    1. What is Reg ex
    1. Character Classes
    1. Quantifiers
    1. Functions of Re-Module
    1. Find all methods - Important functions of re module
    1. Symbols
    1. Web scrapping using reg exp
    1. Multitasking
    1. Difference between Multiprocessing and multi-threading
    1. Difference between Process and Thread
    1. Ways of creating thread in python
    1. Difference in program with and without Multithreading
    1. Thread Identification Number
    1. Functions/Methods in Multithreading
    1. Daemon Thread
    1. Synchronization
    1. Difference between lock and semaphore
    1. Thread Communication
    1. Inter  Thread Communication
    1. Concurrency and parallelism
    1. Race Condition and DeadLock
    1. Collection Modules
    1. Counters
    1. Ordered dict
    1. default dict
    1. chain map
    1. Named Map
    1. DeQue
    1. User Dict
    1. UserList
    1. User String
    1. Object Oriented vs Procedural Oriented
    1. What is Class?
    1. What is Object ?
    1. Constructor
    1. Self Keyword
    1. Functions vs Method
    1. Types of Variables
    1. Static variable
    1. Local Variable
    1. Instance Variable
    1. Class Method
    1. Static Method
    1. Inner Class
    1. Garbage Collection in OOP's
    1. Destructor
  • Inheritance
    • i. Inheritance
    • ii. Built in function in oops
    • iii. Single Inheritance
    • iv. Constructor super()
    • v. Multiple inheritance
    • vi. Method Resolution Order (MRO)
    • vii. Multilevel Inheritance
    • viii. Hierarchical Inheritance
    • ix. Hybrid Inheritance
  • Polymorphism
    • i. Polymorphism
    • ii. Polymorphism with class methods
    • iii. Polymorphism with functions and objects
    • iv. Overloading
    • v. Operator Overloading
    • vi. Magic Method for operator overloading
    • vii. Method Overloading
    • viii. Constructor Overloading
    • ix. Method Overriding
    • x. Method overriding with multiple and multilevel inheritance
    • xi. Constructor Overriding
    • xii. Type System
    • xiii. Duck Typing
    1. Abstraction
    1. Types of Methods in Python
    1. How to declare an abstract method in Python
    1. Concrete Methods in Abstract Base Classes
    1. Missed Abstract methods in implementation
    1. Abstract classes contain more subclasses?
    1. Different cases for Abstract class object creation
    1. Built in Abstract Classes
    1. Interfaces
    1. Create a Python Interface
    1. Python Interfaces vs Abstract Class
    1. Encapsulation
    1. Python Access Modifiers
    1. Why we need Encapsulation
    1. Calculator
    1. Password Generator
    1. Tic Tac Toe
    1. Rock Paper Scissors
    1. Chat Bot
    1. BMI Calculator
    1. Story Generator
    1. Quiz Game
    1. Create Acronyms
    1. Intro
    1. Introduction to Tkinter
    1. Widgets in Tkinter
    1. Tkinter Geometry
    1. Python Tkinter Button
    1. Python Tkinter Canvas
    1. Python Tkinter CheckButton
    1. Python Tkinter Entry
    1. Python Tkinter Frame
    1. Python Tkinter Label
    1. Python Tkinter Listbox
    1. Python Tkinter MenuButton
    1. Python Tkinter Menu
    1. Tkinter Project Calendar
    1. Intro
    1. Python Tkinter Message
    1. Python Tkinter RadioButton
    1. Python Tkinter Scale
    1. Python Tkinter Scrollbar
    1. Python Tkinter Text
    1. Python Tkinter Toplevel
    1. Python Tkinter SpinBox
    1. Python Tkinter Paned Window
    1. Python Tkinter Label Frame
    1. Python Tkinter MessageBox
    1. Python GUI PyQt5- Part 1 intro
    1. PyQt5 Introduction
    1. Modules and tools
    • PyQt5 First Program
  • PyQt5 Layouts
    • i. QVBoxLayout and QHBoxLayout
    • ii. QGridLayout
    • iii. QFormLayout
    • iv. QStackedLayout
    1. Signals and slots
    1. PyQt5 Widgets
    • i. QLabel
    • ii. QLineEdit
    • iii. QPushButton
    • iv. QRadioButton
    • v. QCheckBox
    • vi. QComboBox
    • vii. QSpinBox
    • viii. QSlider
    • ix. QMenuBar, QMenu & QAction
    • x. QToolBar
    • xi. QInputDialog
    • xii. QFontDialog
    • xiii. QFileDialog
    • xiv. QTab
    • xv. QStacked
    • xvi. QSplitter
    • xvii. QDock
    • xviii. QStatusBar
    • xix. QList
    • xx. QScrollBar
    • xxi. QCalendar
    • xxii. Qmessagebox
    • xxiii. Multiple document interface
    • xxiv. Drag and Drop
    • xxv. Drawing API
    • xxvi. Clipboard
    • xxvii. BrushStyle Constants
    • xxviii. QPixmap Class
    • xxix. Database handling
    • xxx. Project 1- Text Editor
    • xxxi. Project 2- Calculator
    1. Python Turtle intro
    1. Introduction to Python Turtle
    1. Moving and Drawing with turtle
    1. First Turtle Program
    1. Turtle program on pen control
    1. Program- Event handling
    1. Program on working state of the turtle module
    1. Working with turtle screen
    1. Program Colourful Star Pattern
    1. Turtle Methods
    1. Program - Draw a hut using turtle module
    1. Pygame intro
    1. Pygame Introduction
    1. Basic structure of a Pygame program
    1. Basic Pygame concepts
    1. Pygame - Display Modes
    1. Pygame - Color Object
    1. Pygame - Event Objects
    1. Keyboard Events
    1. Mouse Events
    1. Pygame - Drawing Shapes
    1. Pygame - Using Image
    1. Pygame - Displaying Text
    1. Pygame - Moving an Image
    1. Pygame - Use Text as Buttons
    1. Pygame - Transforming Images
    1. Pygame - Sound Objects
    1. Playing Music
    1. Pygame - Load Cursor
    1. Pygame - The Sprite Module
    1. Snake Game
    1. Basic SQL intro
    1. Database and RDBMS
    1. Introduction to SQL
    1. SQL Subset
    1. RDBMS concepts
    1. Installing Mysql on windows
    1. Simple SQL queries
    1. SQL Expression
    1. SQL Operators
    1. DDL Operations
    1. DML Operations
    1. Functions in SQL
    1. Advanced SQL intro
    1. SQL Subqueris
    1. SQL Clause
    1. SQL Joins
    1. SQL Union
    1. SQL Group by
    1. SQL Views
    1. SQL Indexes
  • i. SQL Transactions
    1. Python Programming with MySQL intro
    1. MySQL Database
    1. Install MySQL Driver
    1. Check if Database Exists
    1. Python MySQL Create Table
    1. Check if Table Exists
    1. Primary Key
    1. Python MySQL Insert Into Table
    1. Insert Multiple Rows
    1. Python MySQL Select From
    1. Selecting Columns
    1. Python MySQL Where
    1. Python MySQL Order By
    1. Python MYSQL Delete From By
    1. Python MySQL Drop Table
    1. Python MySQL Update Table
    1. Python MySQL Limit
    1. Python MySQL Join

Evaluation Pattern

Evaluation Pattern of KLiC Courses consists of 4 Sections as per below table:

Section No. Section Name Total Marks Minimum Passing Marks
1 Learning Progression 25 10
2 Internal Assessment 25 10
3 Final Online Examination 50 20
Total 100 40
4 SUPWs (Socially Useful and Productive Work in form of Assignments) 5 Assignments 2 Assignments to be Completed & Uploaded
YCMOU Mark Sheet

Printed Mark Sheet will be issued by YCMOU on successful completion of Section 1, Section 2 and Section 3 and will be delivered to the learner by MKCL.
YCMOU Mark Sheet will be available only for Maharashtra jurisdiction learners

MKCL's KLiC Certificate

The certificate will be provided to the learner who will satisfy the below criteria:

  1. Learners who have successfully completed above mentioned 3 Sections i.e. Section 1, Section 2 and Section 3
  2. Additionally, learner should have completed Section 4 (i.e. Section 4 will comprise of SUPWs i.e. Socially Useful and Productive Work in form of Assignments)
    • Learner has to complete and upload minimum 2 out of 5 Assignments

KLiC Courses Fee Structure from 01 July, 2025 Onwards

KLiC 120 hour course fee applicable from 01 July, 2025 all over Maharashtra

KLiC Course Duration MFO
(Inclusive of GST)		 ALC Share
(Service Charges to be collected by ALC)		 MKCL Certificate YCMOU Marksheet
120 hours (Without YCMOU Marksheet) Rs. 1,000/- Rs. 5,000/- Available Not Available
120 hours (With YCMOU Marksheet) Rs. 1,118/- Rs. 5,000/- Available Available


Important Points:
* Above mentioned fee is applicable for all Modes of KLiC Courses offered at Authorised Learning Center (ALC) and at Satellite Center
* Total fee is including of Course fees, Examination fees and Certification fees
* MKCL reserves the right to modify the Fee anytime without any prior notice

KLiC Courses Fee Structure upto 30 June, 2025

From 01 January 2025 onwards, the fees for all KLiC courses in ALCs of Mumbai Metropolitan Regional Development Authority (MMRDA), Pune Metropolitan Regional Development Authority (PMRDA) and Rest of Maharashtra will be applicable as shown in the table below:

KLiC Courses of 120 Hours:

Mode Total Fee (Rupees) Single
Installment
(Rupees) 		Two
Installments
(Rupees)
Single Installment 6000/- 6000/- N/A
Two Installments 6200/- 3100/- 3100/-

Total fee is including of Course fees, Examination fees and Certification fees

Important Points:
* Above mentioned fee is applicable for all Modes of KLiC Courses offered at Authorised Learning Center (ALC) and at Satellite Center
* Total fee is including of Course fees, Examination fees and Certification fees
* MKCL reserves the right to modify the Fee anytime without any prior notice