INFORMATICES PRACTICES ClassXII
Python
- Introduction to Python libraries- Pandas
- Data structures in Pandas - Series and data frames.
- Series Creating Ways
- Series Attributes and Data Types
- Arithmetic and Relational operations on Series
- head and tail functions
- selection, indexing and slicing on Series
- Operation on Series(add,delete,update)
- Data Frame Creating Ways
- Data Frame attribute and Data Types
- Operation on rows(Select/add/Delete/Update/rename)
- Operation on Column (Select/add/Delete/Update/rename)
- Deleting and Renaming Index
- Head and Tail functions
- indexing using labels&Boolean indexing;
- joining, merging and concatenation of data frames.
- Descriptive Statistics: max, min, count, sum,
mean, median, mode, quartile, Standard deviation, variance.
- Aggregation, group by, Sorting
- Pivoting. Handling missing values – dropping and filling.
- Importing/Exporting Data between CSV files and Data Frames.
- Importing/Exporting Data between MySQL database and Pandas.
- Understanding all topic via Command (Minimum 110Command)
Database
- Introduction to Database
- Basic Term logy and Keys
- Show, Use and Describe Command
- Select, From and Where Command
- SQL Data Types
- SQL Operator (Relational ,Logical Between, In, Like)
- Is Null, Distinct, All and As Command
- Order by Clause
- DDL Command(Create ,Alter Drop)
- DML Command(Insert,Update,Delete)
- Types of Predefined Function(Single Row & Multi Row)
- Group by and Having Clause
- Different Type of Joining of Tables
- Single Row Numeric Function
- Single Row String Function
- Single Row Date & Time Function
- Understanding all topic via Query (Minimum 100 Query)
Computer Network
- Introduction to networks and Advantage & Disadvantage
- Types of network:PAN, LAN, MAN, WAN.
- Network Devices: modem, hub, switch, repeater, router, gateway
- Network Topologies: Star, Bus, Tree, Mesh.
- Introduction to Internet, URL, WWW and its applications- Web, email, Chat, VoIP.
- Introduction to website, difference between a website and webpage
- static vs dynamic web page
- web server and hosting of a website.
- Introduction to Web Browsers, commonly used browsers
- browser settings, add-ons and plug-ins, cookies.
