INSPIREWEBSOFT
Home
CS-Revision-XI
CS-Concepts
CS-Board-Questions
CS-Practice-Questions
CS-Videos
Topics
Python-Data Structure
Introduction
Stack
Stack Implementation
Example using List
Example using Dictionary
Python-Functions
Functions in Python
Function Definition And Function Call
Nature of Functions
Types of Functions
Flow of Execution in a Function Call
Arguments and Parameters in Python
Positional / Required / Mandatory Argument in Functions
Default Arguments in Functions
Keyword / Named Arguments in Function
Scope of Variable and LEGB Rule
Python-Exception Handling
Errors and Debugging in Python
Exception Handling
try-except Block
try with multiple except Block
try-except-finally Block
Python-File Handling
Introduction To File
Introduction to Text Files
File Modes in Python
Relative Path And Absolute Path
Introduction to Read and Write Data in Files
Text File - write() function
Text File - writelines() Function
Text File - read() Function
Text File - readline() Function
Text File - readlines() Function
Introduction to Binary File
Binary File - dump() Function
Binary File - load() Function
Introduction to CSV File
CSV File - writer(), writerow() and writerows() function
CSV File - reader( ) function
DBMS-MySQL
Introduction
Types of Database
Advantages
Application Areas
Basic Terminologies
Keys
SQL and MYSQL
SQL Statements
SQL Datatypes
SQL Constraints
Database Commands
Table Commands
ALTER Table Commands
INSERT RECORD
MODIFY RECORD
REMOVE RECORD
SELECT Statement
DISTINCT Clause
SQL Operators
Arithmetic Operators
Relational Operators
Logical Operators
Special Operators
LIKE keyword
ORDER BY
AGGREGATE FUNCTIONS
GROUP BY
JOINS
Python-MySQL Connectivity
Introduction To Connectivity
Establishing a Connection
Creating a Database
Creating a table
USE OF %s format specifier OR format() TO PERFORM QUERIES
Inserting data into table
Updating record
Deleting record
Fetching data from the table
Computer Networks
Introduction to Computer Networks
Elementary Terminology of Network
Data Communication
Network Devices
Network Switching
Transmission Media
Types of Network
Network Topologies
Network Protocols
Web Services
SQL Operators
☞ There are four types of SQL operators:
Arithmetic Operators
Relational Operators
Logical Operators
Special Operators
