Chapter 1 : Revision of Python
- Introduction to Python
- Execution modes in Python
- Executing hello world program
- Python Tokens(Keywords, Identifiers)
- Python Tokens(Literals, Separators)
- Python Tokens(Operators)
- Python Variables
- Concept of L-value & R-value
- Comments in Python
- Comments in Python
Chapter 2 : Functions
- 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)
Chapter 3 : Exception Handling
- Introduction to Exception handling
- Handling exceptions using try except finally blocks
Chapter 4 : File Handling (Part 1)
- Introduction to Files
- Types of Files (Text file, Binary file , CSV Files)
- Relative and absolute path
- Creating Text files
- Text file modes(r , r+, w , w+ , a , a+)
- Closing a Text file
- Writing in Text file using write( ) and writeline( )
- Reading from text file using read( ) , readline( ) and readlines( )
- seek and tell method
- Opening file using with clause.
- import csv module
- Creating and closing CSV Files
- Write in CSV using writer( ), writerow( ) and writerows( )
- Reading from CSV using reader( )
Chapter 4 : Binary File Handling (Part 2)
- Introduction to Binary files
- Creating and closing binary files
- Binary file modes(rb , rb+ ,wb , wb+ , ab , ab+)
- Import pickle module
- Write in binary files using dump( ) method
- Reading binary file using load( ) method
- Searching operation in binary file
- Update operation in binary file
- append operation in binary file
- Opening file using with clause.
Chapter 5 : Data Structure
- Introduction to Stacks
- Operations on Stack(push & pop)
- Implementation of Stack using list
Chapter 6 : Computer Networks
- Introduction to Computer Networking
- Benefits of Computer Networking
- Evolution of Networking (ARPANET , NSFNET , INTERNET)
- Concept of Communication
- Components of Data communication
- Measuring capacity of communication media
- IP address
- Switching techniques (Circuit switching, Packet switching)
- Transmission media
- Wireless media (Twisted pair cable)
- Wired media (Co-axial cable)
- Wired media (Fibre optic cable)
- Wireless media (Radio waves)
- Wireless media (Micro waves)
- Wireless media (Satellite)
- Wireless media (Infrared)
- Network device : Modem
- Network device : Ethernet Card , RJ45 and WIFI Card
- Network device : Repeater
- Network device : Hub and Switch
- Network device : Router and Bridge
- Network types : PAN, LAN, MAN, WAN
- Network Topologies : Star , Bus and Tree
- Network Protocol : HTTP, HTTPS, FTP , SMTP , TELNET , VoIP
- Network Protocol : TCP/IP , PPP , POP3
- World Wide Web
- HTML and XML
- Domain names and URL
- Web browsers , Website and Web pages
- Web servers and web hosting
- 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)
Chapter 7 : Database Management
- Introduction to Database, concepts and its need
- Relational Data model : relation, attribute, tuple, domain
- Relational Data model : Degree , cardinality
- Relation Data model : Keys
- Introduction to SQL
- Types of SQL commands(DDL, DML)
- Data type (char(n) and varchar(n) , int , float, date)
- Constraints (not null , unique , primary key)
- Database commands
- Describe table command
- Alter table command
- Drop table command
- Delete command
- Insert command
- Update command
- Select command
- Where clause
- Distinct clause
- Aliasing
- in , not in operator in SELECT command
- between , not between operator
- Meaning of null , is null , is not null
- Like operator
- Aggregate Functions
- Group by clause
- Having clause
- Joins in SQL
- Cartesian Join
- Equi-Join
- Natural Join
- Interface of Python with SQL database
- Connecting SQL with Python
- Insert operation using cursor
- Update operation using cursor
- Delete rows using cursor
- Display data using fetchall( ), fetchone( ), fetchmany( )
- %s specifier or format( ) to perform queries