CORE and Advanced PYTHON along with MYSQL Database:
Mr. Nageswar Rao Mandru (MNRAO) is an industrial Expert with over 20 years of Development and Training experience.
Trained 50,000+ + Students and completed 16 Projects in development on PYTHON, Java, Linux, BigData, Spark, Hadoop, Oracle, and MYSQL Databases.
Course Details:
- Course Name: Core and Adv PYTHON
- Duration: 50 days
- Date: 16th June 2025
- Timings: 6:00 to 7:15 PM IST
- Demo classes: 4 days ( free )
- Live classes including Recorded Videos and material, Interview Questions and Software.
- 24/7 Whatsapp support for Coding issues.
- Non-IT students, Pre-grad, Under-Graduates can also understand my classes
Join into PYTHON WhatsApp group with below link
For more Details WhatsApp on. +91- 8179 189 123.
Please pay the Course Fee of Rs.500 on 8179 189 123 (Either Phone Pay or Google Pay) and please provide the Payment Screenshot in the Group without fail.
PYTHON Course content as below:
1.Software Basics
• System Software
• Application Software
• Operating System
• Frontend Software and Backend software
• Languages
• Compiler Vs Interpreter
2. Python Basics
• What is Python
• Why Python?
• History of python
• Applications of Python
• Features of Python
• Advantages of Python
• Versions of Python
• Installation of Python
3. Python Operations
• Python Modes of Execution
• Interactive mode of Execution
• Batch mode of Execution
• Python Editors and IDEs
• Python Data Types
• Python Constants
• Python Variables
• Comments in python
• Output Print(),function
• Input() Function :Accepting input
• Type Conversion
• Type(),Id() Functions
• Comments in Python
• Escape Sequences in Python
4. Operators in Python
• Arithmetic Operators
• Relational Operators
• Logical Operators
• Assignment Operators
• Short Hand Assignment Operators
• Bitwise Operators
• Membership Operators
• Identity Operators
5. Python IDE’s
• Pycharm IDE Installation
• Working with Pycharm
• Pycharm components
• Installing Anaconda
• What is Conda?
• Anaconda Prompt
• Anaconda Navigator
• Jupyter Notebook
• Jupyter Features
• Spyder IDE
• Spyder Featueres
• Conda and PIP
6. Control statements
• If Statements
• Block/clause
• Indentation in Python
• while loop,
• while … else,
• for loop
• Range() in for loop
• Nested for loop
• Break statement
• exit() statement
• continue statement
• Pass statement
7. Python Arrays
• Single Dimension Arrays
• Searching Techniques
• Sorting Techniques
• Multi Dimension Arrays
8. Strings in Python
• Creating Strings
• String indexing
• String slicing
• String Concatenation
• String Comparison
• String splitting and joining
• Finding Sub Strings
• String Case Change
• Split strings
• String methods
• Strings in Python
• String indices and slicing
9. Collections in Python
• Introduction
• Lists
• Tuples
• Sets
• Dictionaries
• Operations on collections
• Functions for collections
• Methods of collection
• Nested collections
• Differences Between list tuple and set and Dictionary
10. Python Lists
• List properties
• List Creation
• List indexing and slicing
• List Operations
• List addresses
• List functions
• Different ways of creating lists
• Nested Lists
• List modification
• List insertion and deletion
• List Methods
11. Python Tuples
• Tuple properties
• Tuple Creation
• Tuple indexing and slicing
• Different ways of creating tuples
• Tuple Operations
• Tuple Addresses
• Tuple Functions
• Nested Tuples
• Tuple Methods
• Differences b/w List and Tuple
12. Python Sets
• Set properties
• Set Creation
• Set Operations
• Set Functions
• Set Addresses
• Set Mathematical Operations
• Set Methods
• Insertion and Deletion operation
13. Python Dictionary
• Dictionary properties
• Dictionary Creation
• Dictionary Operations
• Dictionary Addresses
• Nested Dictionaries
• Dictionary Methods
• Insertion and Deletion of elements
• Differences b/w list tuple and set and Dictionary
14. Functions in Python
• Defining a function
• Calling a function
• Properties of Function
• Examples of Functions
• Categories of Functions
• Argument types
o default arguments
o non-default arguments
o keyword arguments
o non keyword arguments
• Variable Length Arguments
• Variables scope
• Call by value and Call by Reference
• Passing collections to function
• Local and Global variables
• Recursive Function
• Boolean Function
• Passing functions to function
• Anonymous or Lamda function
• Filter() and map() functions
• Reduce Function
15. Modules in Python
• What is a module?
• Different types of module
• Creating user defined module
• Setting path
• The import statement
• Normal Import
• From … Import
• Module Aliases
• Reloading a module
• Dir function
• Working with Standard modules -Math, Random, Date time and os modules,
16. Packages
• Introduction to packages
• Defining packages
• Importing from packages
• --init--.py file
• Defining sub packages
• Importing from sub packages
17. OOPs Concepts
• OOPS Features
• Encapsulation
• Abstraction
• Class
• Object
• Static and non static variables
• Defining methods
• Diff b/w functions & methods
• Constructors
• Parameterized Constructors
• Built –in attributes
• Object Reference count
• Destructor
• Garbage Collection
• Inheritance
• Types of Inheritances
• Object class
• Polymorphism
• Overriding
• Super() statement
18. Errors and Exception Handling
• Types of errors
• Compile-Time Errors
• Run-Time Errors
• What is Exception?
• Need of Exception handling
• Predefined Exceptions
• Try,Except, finally blocks
• Nested blocks
• Handling Multiple Exceptions
• User defined Exceptions
• Raise statement
19. File Handling
• Introduction
• Types of Files in Python
• Opening a file
• Closing a file
• Writing data to files
• Tell( ) and seek( ) methods
• Reading a data from files
• Appending data to files
• With open statement
• Various functions
• Working with CSV files
• Working with XML files
• Working with JSON files
• Excel Workbook
• Excel Sheet Data Parsing
• Excel Sheet Generators
20. Regular Expressions
• What is regular expression?
• Special characters
• Forming regular expression
• Compiling regular expressions
• Grouping
• Findall() function
• Finditer() function
• Sub() function
• Match() function
• Search() function
• Matching vs searching
• Splitting a string
• Replacing text
• validations
21. Python Networking
• Networking Terminology
• TCP Vs UDP
• TCP Application Development
• UDP Application Development
22. Database Access
• Introduction
• Installing mysql database
• Creating database users,
• Establishing connection with mysql
• Closing database connections
• Connection object
• Cursor object
• Executing SQL queries
• Simple statement
• Prepared statement
• Retrieving data from Database.
• Using bind variables executing
• SQL queries
• Transaction Management ( commit and rollback )
• Handling errors
23. Python Date and Time
• How to Use Date &DateTime Class
• Time and date Objects
• Calendar in Python
• The Time Module
• Python Calendar Module
24. Operating System Module
• Introduction
• getcwd
• listdir
• chdir
• mkdir
• rename file/dir
• remove file/dir
• rmtree()
• Os help
• Os operations
25. Python Pandas
• Introduction to Pandas
• Creating Pandas Series
• Creating Data Frames
• Pandas Data Frames from dictionaries
• Pandas Data Frames from list
• Pandas Data Frames from series
• Pandas Data Frames from CSV, Excel
• Pandas Data Frames from JSON
• Pandas Data Frames from Databases
• Pandas Data Functionality
• Pandas Timedelta
• Creating Data Frames from Timedelta
• Pandas Groupings and Aggregations
• Converting Data Frames from list
• Creating Functions
• Converting Different Formats
• Pandas and Matplotlib
• Pandas usecases
26. Python Numpy
• Introduction to Numpy
• Numpy Arrays
• Numpy Array Indexing
• 2-D and 3Dimensional Arrays
• Numpy Mathematical operations
• Numpy Flattening and reshaping
• Numpy Horizontal and Vertical Stack
• Numpy linespace and arrange
• Numpy asarray and Random numbers
• Numpy iterations and Transpose
• Numpy Array Manipulation
• Numpy and matplotlib
• Numpy Linear Algebra
• Numpy String Functions
• Numpy operations and usecases
• Numpy Working Examples
