Chapter 1 : Data Handling using Pandas
- Introduction to Pandas
- Data Structure in Pandas
- Introduction to Series
- Creation of Series
- Series Attributes
- Mathematical operations on Series
- Head and Tail Function
- Slicing in Series
- Selection in Series
Chapter 2 : DataFrame in Pandas
- Introduction to DataFrame
- Creation of DataFrame
- DataFrame Attributes
- DataFrame operations
- loc function in Dataframe
- Adding row & column in DataFrame
- Deleting row & column in DataFrame
- rename function in DataFrame
- Head and Tail functions
- Boolean indexing
- Importing Data between CSV and DataFrames
Chapter 3 : Data Visualization
- Purpose of Plotting
- Plotting Line Graph
- Customize Line Graph
- Plotting Bar Graph
- Customize Bar Graph
- Plotting Histogram
- Customize Histogram
Chapter 4 : Revision of Database Concepts
- Introduction to Database Concepts and its need
- Database Management
- Relational data model : Concepts of Domain
- Terminologies in RDBMS
- Keys
- Introduction to SQL
- Types of SQL Commands (DDL & DML)
- Introduction to MySQL
- Database Commands
- Data Types in SQL
- Create Table command
- Drop Table command
- Alter Table command
- Select Command
- Where Clause
- Between and not between operator
- Logical operators in SQL
- Null, is null and not null
- Insert into command
- Delete command
- Update command
Chapter 5 : Functions in SQL
- Introduction to Functions
- Math Functions
- Text Functions (Part 1)
- Text Functions (Part 2)
- Date Functions
- Aggregate Functions
- Group by clause
- having clause
- Order by Clause
- Joins & its types
- Equi Join
Chapter 6 : Introduction to Computer Networks
- Introduction to networks
- Types of Network
- Network Device : Modem
- Network Device : Hub
- Network Device : Switch
- Network Device : Repeater
- Network Device : Router
- Network Device : Gateway
- Network Toplogy : Star
- Network Toplogy : Bus
- Network Toplogy : Tree and Mesh
- Introduction to Internet
- URL
- WWW and its applications
- Website and Webpage
- Static vs Dynamic Webpage
- Web server and hosting
- Web Browsers
- Add-ons and plugins
- Cookies
Chapter 7 : Societal Impacts
- Digital Footprints
- Net and Communication etiquettes
- Data Protection
- Intellectual Property Rights
- Plagiarism
- Licensing and copyright
- Free and open source software
- Cybercrime and cyber laws
- Hacking
- Phishing
- Cyber Bullying
- Overview of Indian IT Act
- E-waste & its Management
- Health concerns related to the usage of technology
- Introduction to Functions
- Types of Functions
- Creating user defined functions
- arguments and parameters
- Default parameters
- Positional parameters
- Functions returning value(s)
- Flow of execution
- Scope of a Variable (Local)
- Scope of a Variable (Global scope)