---

🚀 100% Offline / In-Person Classroom and Online Training Course: Python (Core Python, Advanced Python, Data Structures & Algorithms (DSA), Numpy, Pandas, SciPy, Matplotlib, MySQL, MongoDB)

---

Group Training Fee: ₹10,000/- ➡️ Offer: ₹5,000/-

One-On-One Training Fee: ₹20,000/- ➡️ Offer: ₹10,000/-

Duration: 3 Months

Course Curriculum

• Core Python
• Advanced Python
• NumPy
• Pandas
• SciPy
• Matplotlib
• MongoDB
• MySQL
• ChatGPT, CoPilot, HackerRank, LeetCode, CodeChef
• Project: PYTHON

---

Python

• Python Get Started
• Python Syntax
• Python Comments
• Python Variables
  • Python Variables
  • Variable Names
  • Assign Multiple Values
  • Output Variables
  • Global Variables
• Python Data Types
  • Python Numbers
  • Python Casting
• Python Strings
  • Python Strings
  • Slicing Strings
  • Modify Strings
  • Concatenate Strings
  • Format Strings
  • Escape Characters
  • String Methods
• Python Booleans
• Python Operators
• Python Lists
  • Python Lists
  • Access List Items
  • Change List Items
  • Add List Items
  • Remove List Items
  • Loop Lists
  • List Comprehension
  • Sort Lists
  • Copy Lists
  • Join Lists
  • List Methods
• Python Tuples
  • Python Tuples
  • Access Tuples
  • Update Tuples
  • Unpack Tuples
  • Loop Tuples
  • Join Tuples
  • Tuple Methods
• Python Sets
  • Python Sets
  • Access Set Items
  • dd Set Items
  • Remove Set Items
  • Loop Sets
  • Join Sets
  • Set Methods
• Python Dictionaries
  • Python Dictionaries
  • Access Items
  • Change Items
  • Add Items
  • Remove Items
  • Loop Dictionaries
  • Copy Dictionaries
  • Nested Dictionaries
  • Dictionary Methods
• Python If...Else
• Python While Loops
• Python For Loops
• Python Lambda
• Python Arrays
• Python Classes/Objects
• Python Inheritance
• Python Iterators
• Python Scope
• Python Modules
• Python Dates
• Python Math
• Python JSON
• Python RegEx
• Python PIP
• Python Try...Except
• Python String Formatting
• File Handling
  • Python File Handling
  • Python Read Files
  • Python Write/Create Files
  • Python Delete Files

NumPy

• Introduction
• Getting Started
• Creating Arrays
• Array Indexing
• Array Slicing
• Data Types
• Copy vs View
• Array Shape
• Array Reshape
• Array Iterating
• Array Join
• Array Split
• Array Search
• Array Sort
• Array Filter
• Random
• ufuncli

MongoDB:

• Introduction to MongoDB
  • What is MongoDB?
  • NoSQL databases vs. traditional databases
  • Document-oriented data model
  • Advantages of MongoDB
• Installation and Setup
  • Downloading and installing MongoDB
  • Starting and stopping the MongoDB server
  • Basic configuration options
  • Connecting to MongoDB from the shell
• Working with the MongoDB Shell
  • Basic MongoDB shell commands
  • Creating and managing databases
  • CRUD operations (Create, Read, Update, Delete)
  • Querying and filtering data
• Data Modeling in MongoDB
  • Document structure and BSON format
  • Embedding documents vs. referencing documents
  • Normalization vs. denormalization
  • Designing schema for your application
• Indexes and Performance Optimization
  • Creating and managing indexes
  • Query optimization
  • Profiling and analyzing queries
  • Aggregation framework for complex queries
• CRUD Operations in MongoDB
  • Inserting documents
  • Querying for documents
  • Updating documents
  • Deleting documents
• Advanced MongoDB Features
  • Geospatial queries and indexing
  • Text search and indexing
  • Working with large datasets (GridFS)
  • Transactions and data consistency
• Replication and High Availability
  • Understanding replica sets
  • Configuring and managing replica sets
  • Automatic failover and data redundancy
  • Read preferences and write concerns
• Sharding and Scalability
  • Horizontal scaling with sharding
  • Shard key selection and strategies
  • Configuring and managing sharded clusters
  • Load balancing and distribution of data
• Security in MongoDB
  • Authentication and authorization
  • Role-based access control (RBAC)
  • Securing MongoDB deployments
  • Encryption at rest and in transit
• Backup and Disaster Recovery
  • Backup strategies and tools
  • Point-in-time recovery
  • Restoring data from backups
  • Disaster recovery planning
• Using MongoDB with Programming Languages
  • MongoDB drivers for various programming languages
  • Connecting and interacting with MongoDB in applications
  • Using Object-Document Mapping (ODM) libraries
  • Best practices for working with MongoDB in code
• Real-world Applications and Use Cases
  • Examples of MongoDB usage in web applications
  • IoT and sensor data storage and processing
  • Content management systems (CMS)
  • Logging and analytics platforms

2. MySQL:

• Introduction to MySQL
  • What is MySQL?
  • Relational database management system (RDBMS)
  • Features and benefits of MySQL
  • Installation and setup of MySQL
• SQL Fundamentals
  • Structured Query Language (SQL)
  • Basic SQL syntax and statements
  • CRUD operations (Create, Read, Update, Delete)
  • Working with tables and records
• Data Types and Operators
  • Common data types in MySQL
  • Arithmetic and comparison operators
  • String functions and operations
  • Date and time functions
• Database Design
  • Database normalization
  • Primary keys, foreign keys, and indexes
  • Creating and altering tables
  • Defining relationships between tables
• Querying and Retrieving Data
  • SELECT statements and clauses
  • Filtering and sorting data
  • Aggregating and grouping data
  • Joining multiple tables
• Modifying Data
  • INSERT, UPDATE, and DELETE statements
  • Transaction management
  • Rollbacks and commits
  • Locks and concurrency control
• Advanced SQL Concepts
  • Subqueries and derived tables
  • Common Table Expressions (CTEs)
  • Window functions and ranking
  • Stored procedures and functions
• Indexes and Performance Optimization
  • Understanding indexes and their types
  • Optimizing queries with indexes
  • Query execution plans
  • Performance tuning and profiling
• Working with Views and Indexes
  • Creating and managing views
  • Using indexes in views
  • Updating and deleting views
  • Materialized views
• Stored Procedures and Functions
  • Creating and executing stored procedures
  • Parameters and variables in procedures
  • Error handling and control flow
  • User-defined functions (UDFs)
• Triggers and Events
  • Creating and using triggers
  • Events and scheduled tasks
  • Audit logging with triggers
  • Managing triggers and events
• Security and Permissions
  • Authentication and authorization
  • User account management
  • Privileges and roles
  • Security best practices
• Backup and Recovery
  • Database backup strategies
  • Restoring data from backups
  • Point-in-time recovery
  • Disaster recovery planning
• Working with MySQL Clients and Tools
  • MySQL command-line client
  • MySQL Workbench and other GUI tools
  • Database administration and monitoring
  • Query optimization tools
• Advanced Topics (Optional)
  • Replication and high availability
  • Sharding and partitioning
  • Using MySQL in web applications
  • Integration with programming languages (e.g., Python, Node.js)