1. Python
- 1.1. Intro to Programming Langugae
- 1.2. Variables & Data Types
- 1.3. Operators and Methods
- 1.4. Decision statement & Looping Statement
- 1.5. Array & 2D Array
- 1.6. Object Oriented Fundamentals
- 1.7. OOPs
- 1.8. Encapsulation & Data Hiding
- 1.9. Is-A relationship Inheritance
- 1.10. Polymorphism
- 1.11. Abstraction
- 1.12. Has-A relationship
- 1.13. Object class
- 1.14. Strings
- 1.15. Exception & Exception Handling
- 1.16. Wrapper class
- 1.17. Collection Framework in Java
- 1.18. Java 8 Feature
- 1.19. Multithreading
- 1.20. Functional programming (Stream API)
2. DJango
- 2.1. Introduction to JDBC
- 2.2. What is the difference between file and database?
- 2.3. What is JDBC API
- 2.4. 5 Steps to connect to database
- 2.5. Create Statement using : Statement
- 2.6. Create Statement using : PreparedStatement
- 2.7. Execute Query using : execute method / execute-update method/ execute-query method
- 2.8. Batch Execution
- 2.9. Create maven project to perform CRUD operation using JDBC
- 2.10. Create Procedure in DB
- 2.11. Create function in DB
- 2.12. What is DB metadata
- 2.13. What is ResultSet metadata
- 2.14. Create Connection Pool Practical
3. HTML
- 5.1. Introduction to HTML
- 5.2. HTML 5 Basics
- 5.3. Helper Elements to structure web page
- 5.4. Anchor and Hyperlinks
- 5.5. HTML Multimedia and its embedding
- 5.6. HTML Frame
- 5.7. Advance Concepts in HTML
- 5.8. HTML References
4. CSS
- 6.1. CSS Selectors
- 6.2. CSS Units
- 6.3. Typography and Text Styling
- 6.4. Box Model
- 6.5. CSS Colours
- 6.6. CSS Backgrounds
- 6.7. CSS Layouts
- 6.8. CSS Animations
- 6.9. Responsive Web Design
- 6.10. CSS Frameworks
- 6.11. CSS List
- 6.12. CSS Table
- 6.13. CSS Functions
- 6.14. Specificity
- 6.15. Z-Index
- 6.16. CSS Opacity
- 6.17. CSS Image Sprites
- 6.18. CSS Entities
- 6.19. Filter
5. JavaScript
- 7.1. Introduction to JavaScript
- 7.2. JS File
- 7.3. Output methods
- 7.4. Variables
- 7.5. Tokens
- 7.6. Hoisting
- 7.7. Operators
- 7.8. Statements
- 7.9. Data types
- 7.10. Typecasting
- 7.11. Primitive and Non-primitive data types
- 7.12. JSON
- 7.13. Copying in JS
- 7.14. This keyword
- 7.15. Prototype
- 7.16. Functions prototype methods
- 7.17. OOP's
- 7.18. ES6 Class
- 7.19. Synchronicity in JS
- 7.20. Promises
- 7.21. Browser Storage
- 7.22. DOM
- 7.23. DOM events
- 7.24. Event Propagation
6. SQL
8.1. Introduction To SQL
8.2. Datatypes
8.3. Constraints
8.4. Overview of SQL Statements
8.5. Data Query Language (DQL)
- 8.5.1. Select
- 8.5.2. Projection
- 8.5.3. Selection
- 8.5.4. Joins
8.6. Operator
- 8.6.1. Concatenation Operator (||)
- 8.6.2. Logical Operator (And, Or, Not)
- 8.6.3. Special Operator (In,Not In)
- 8.6.4. Special Operator (Between, Not Between)
- 8.6.5. Special Operator (Is, Is Not)
- 8.6.6. Special Operator (Like, Not Like)
8.7. Function
- 8.7.1. What is Function & Types
- 8.7.2. Multi-Row Function
- 8.7.3. Single-Row Functions
8.8. Grouping
- 8.8.1. Group By clause
- 8.8.2. Having clause
8.9. Sorting
- 8.9.1. Order By clause
8.10. Subquery
- 8.10.1. What is Subquery & Explain
- 8.10.2. When/why do we use Subquery Case?
- 8.10.3. Max & Min
- 8.10.4. Types of Subqueries
- 8.10.5. Subquery Operator
- 8.10.6. Nested Subquery
8.11. Joins
- 8.11.1. Cartesian Join / Cross Join
- 8.11.2. Natural Join
- 8.11.3. Outer Join
- 8.11.4. Self-Join
- 8.11.5. Multiple conditions on joins
8.12. Co-Related Subquery
- 8.12.1. What is Corelated Subquery?
- 8.12.2. Example on Corelated Subquery
- 8.12.3. Exists & not exists operators
- 8.12.4. Identifying nth max Value & min Value
8.13. Data Definition Language (DDL)
- 8.13.1. Create
- 8.13.2. Rename
- 8.13.3. Alter
- 8.13.4. Truncate
- 8.13.5. Drop
8.14. Data Manipulation Language
- 8.14.1. Insert
- 8.14.2. Update
- 8.14.3. Delete
8.15. Transaction Control Language
- 8.15.1. Commit
- 8.15.2. Rollback
- 8.15.3. Save point
8.16. Data Control Language
- 8.16.1. Grant
- 8.16.2. Revoke
8.17. Normalization
- 8.17.1. Functional Dependencies & It's types
- 8.17.2. Types of Functional Dependencies
- 8.17.3. Normalization
- 8.17.4. 1st normal form
- 8.17.5. 2nd normal form
- 8.17.6. 3rd normal form & BCNF