C & C++ Programming and Python with MYSQL Fundamentals
Track Software Development
Duration 120 hours
Skill Level Foundation
Language English

About this Course

Build a strong programming foundation in C, C++, Python, and connect with MySQL databases.
Learning Mode: Learn at ALC or at Home

Detailed Course Curriculum

Hands-on module breakdown aligned with MKCL production standards and industry requirements.

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

Ready to start C & C++ Programming and Python with MYSQL Fundamentals?

Join our upcoming batch at ZICA Kalyani center with certified instructors.