Topics
Exceptional Handling in Python
- Introduction of Exception Handling in Python
- Syntax Errors
- Exceptions
- Built-in Exceptions
- Raising Exceptions
- Handling Exceptions
- Finally Clause
- Types of Function
- Creating User Defined Function
- Arguments and Parameters
- Default Parameters
- Positional Parameters
- Function Returning Values
- Flow of Execution
- Scope of a Variable
Object Oriented Programming with Python
- Concept of Object Oriented Programming with Python
- Data Hiding in Python
- Data Encapsulation in Python
- Class and Object in Python
- Polymorphism in Python
- Inheritance in Python
- Advantages of Object Oriented Programming Over Earlier Programming Methodologies in Python
- Defining Classes (Attributes, Methods)
- Creating Instance Objects
- Accessing Attributes and Methods
- Using Built in Class Attributes (Dict, Doc, Name, Module, Bases)
- Constructor(_Init()_ _, _ _Del()_ _ and _ _ Str()_ _) Methods in a Class
- Private Attributes (Limited Support)
- Importance of "Self" (Acts as a Pointer to Current Calling Object) Operator Overloading with Methods
- Concept of Base Class and Derived Class
- Single, Multilevel and Multiple Inheritance
- Overriding Methods
- Using Super() in Derived Class to Invoke _ _Init()_ _ Or Overridden Methods of Parent Class
Unit 1: Computational Thinking and Programming
File Handling in Python
- Introduction to Files
- Types of Files in Python
- Types of Path in Python
- Opening and Closing a Text Files
- Text File Open Modes
- Writing to a Text File
- Reading from a Text File
- Setting Offsets in a File
- Creating and Traversing a Text File (Data Manipulation)
- The Pickle Module
- Opening and Closing a Binary File in Python
- Binary File Open Modes
- Writing to a Binary File
- Reading from a Binary File
- Appending in a Binary Files
- Searching a Binary File
- Update Operations in a Binary File
- Import CSV Module
- Opening and Closing a CSV File in Python
- Read and Write a CSV File Using Python
Unit 2: Database Management
Advance Programming with Python
- Linear List Manipulation
- Sequential Allocation
- Traversal
- Insertion of an Element in a Sorted List
- Deletion of an Element from the List
- Searching (Linear, Binary)
- Sorting (Insertion, Selection, Bubble)
- Introduction to Stack in Python (LIFO Operations)
- Operations on Stack (PUSH and POP) and Its Implementation in Python
- Converting Expressions from INFIX to POSTFIX Notation and Evaluation of Postfix Expression in Python
- Queues (List Implementation)
- Introduction to Queue in Python (FIFO)
- Operations on Queue (INSERT and DELETE) and Its Implementation in Python
- Need for Data File in Python
- Types of Files in Python
- Opening and Closing a Text Files
- Access Modes (Output, Input, Default)
- File Object
- Reading and Writing a File - Read(), Readline(), Readlines(), Write(), Writelines
- File Positions (Seek(), Tell())
- Renaming and Deleting a File.,Flush()
- Searching for Particular Data from a File
- Insertion and Deletion of Data from an Already Existing File
- Modification of Data in File
- Error and Exceptions - NameError, IndexError, TypeError, IO Error, ImportError, ValueError, EOFError
- Generator Function Using Yield
Unit 3: Computer Networks
Stack
Python - Databases and SQL
- Introduction to Database Concepts
- Relational Data Model
- Relational Algebra
- Structured Query Language Advantages of Using SQL
- Data Definition Language and Data Manipulation Language
- Data Types - NUMBER/DECIMAL, CHARACTER/VARCHAR/VARCHAR2, DATE
- SQL COMMANDS - CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE ….SET…., INSERT, DELETE; SELECT, DISTINCT, FROM, WHERE, IN, BETWEEN, GROUP BY, HAVING, ORDER BY
- Functions in SQL
- Obtaining Results (Select Query) from 2 Tables Using equi-join
- Cartesian Product and Union
Python - Boolean Algebra
- Binary-valued Quantities
- Boolean Variable
- Boolean Constant and Boolean Operators - AND, OR, NOT
- Truth Tables (Boolean Algebra)
- Closure Property
- Commutative Law
- Associative Law
- Identity Law
- Inverse Law
- Principle of Duality
- Idempotent Law
- Distributive Law
- Absorption Law
- Involution Law
- DeMorgan’S Law/Theorem and Their Applications
- Obtaining Sum of Product (SOP) and Product of Sum (POS) Form the Truth Table
- Reducing Boolean Expression (SOP and POS) to Its Minimal Form
- Use of Karnaugh Map for Minimization of Boolean Expressions (Up to 4 Variables)
- Application of Boolean Logic - Digital Electronic Circuit Design Using Basic Logic Gates (NOT, AND, OR, NAND, NOR)
- Use of Boolean Operators (NOT, AND, OR) in SQL SELECT Statements
- Use of Boolean Operators (AND, OR) in Search Engine Queries
Queue
Project
Python - Communication Technologies
- Evolution of Networking
- ARPANET
- Internet
- Interspace Different Ways of Sending Data Across the Network with Reference to Switching Techniques (Circuit and Packet Switching)
- Data Communication Terminologies
- Concept of Channel
- Bandwidth (Hz, KHz, MHz) and Data Transfer Rate (Bps, Kbps, Mbps, Gbps, Tbps)
- Twisted Pair Cable
- Coaxial Cable
- Optical Fiber
- Infrared
- Radio Link
- Microwave Link
- Satellite Link
- Network Devices
- Networking Topologies
- Network Protocol - TCP/IP
- Network Protocol - File Transfer Protocol (FTP)
- Network Protocol - PPP
- Network Protocol - SMTP
- Network Protocol - POP3 Remote Login (Talent)
- Internet Wireless/Mobile Communication Protocol - GSM, CDMA, GPRS, and WLL
- Mobile Telecommunication Technologies
- Mobile Processors
- Electronic Mail Protocols Such as SMTP, POP3
- Protocols for Chat and Video Conferencing VOIP
- Wireless Technologies Such as Wi-Fi and WiMax
- Network Threats and Its Prevention
- Cookies
- Protection Using Firewall
- https
- India IT Act
- Cyber Law
- Cyber Crimes
- IPR Issues
- Hackers and Crackers (Hacking)
- World Wide Web (WWW)
- Hyper Text Markup Language (HTML)
- Extensible Markup Language (XML)
- Hyper Text Transfer Protocol (HTTP)
- Domain Name System
- URL
- Website
- Web Browser
- Web Servers
- Web Hosting
- Web Scripting - Client Side (VB Script, Java Script, PHP)
- Server Side (ASP, JSP, PHP)
- Web 2.0 (For Social Networking)
- E-commerce Payment Transactions Using Online Banking
- Mobile Banking and Payment Apps and Services
Sorting
Searching
Understanding Data
Database Concepts
- Introduction to Database Concepts
- File System
- Limitations of a File System
- Database Management System (DBMS)
- Applications of DBMS
- File System to Database Management System (DBMS)
- Key Concepts in Database Management System (DBMS)
- Relational Data Model
- Terminologies in Relational Data Model
- Properties of a Relational Data Model
- Keys in a Relational Database
Structured Query language (SQL)
- Introduction of Structured Query Language (SQL)
- Structured Query Language (SQL)
- Data Types and Constraints in MySQL
- SQL for Data Definition
- SQL for Data Manipulation
- SQL for Data Query
- Data Updation and Deletion
- Functions in SQL
- GROUP BY Clause in SQL
- Operations on Relations
- Using Two Relations in Query
- Connecting SQL with Python
- Performing Insert, Update, Delete Queries Using Cursor
- Display Data by Using Fetchone(), Fetchall(), Rowcount
- Creating Database Connectivity Applications
Computer Networks
- Introduction to Computer Networks
- Evolution of Networking
- Types of Computer Networks
- Network Devices
- Networking Topologies
- Types of Networking Topologies
- Identifying Nodes in a Networked Communication
- Internet, Web and the Internet of Things
- Domain Name System
- Hyper Text Markup Language (HTML)
- Extensible Markup Language (XML)
- URL
- Website
- Web Browser
- Web Servers
- Web Hosting
Data Communication
Security Aspects
Project Based Learning
- Firewall
- Types of Firewall
1) Network Firewall
2) Host-based Firewall
If you would like to contribute notes or other learning material, please submit them using the button below.
Related QuestionsVIEW ALL [1]
MakeInIndia Corporation, a Uttarakhand-based IT training company, is planning to set up training centres in various cities in the next 2 years. Their first campus is coming up in the Kashipur district. At the Kashipur campus, they are planning to have 3 different blocks for App development, Web designing, and Movie editing. Each block has a number of computers, which are required to be connected to a network for communication, data, and resource sharing. As a network consultant of this company, you have to suggest the best network-related solutions for the issues/problems raised in questions keeping in mind the distances between various blocks/locations and other given parameters.
Distance between various blocks/locations:
| Block | Distance |
| App development to Web Designing | 28 m |
| App development to Movie Editing | 55 m |
| Web designing to Movie Editing | 32 m |
| Kashipur Campus to Mussoorie Campus | 232 km |
Number of computers
| Block | Number of Computers |
| App development | 75 |
| Web Designing | 50 |
| Movie editing | 80 |
- Suggest the most appropriate block/location to house the SERVER in the Kashipur campus (out of the 3 blocks) to get the best and most effective connectivity. Justify your answer.
- Suggest a device/software be installed in the Kashipur Campus to take care of data security.
- Suggest the best-wired medium and draw the cable layout (Block to Block) to economically connect various blocks within the Kashipur Campus.
- Suggest the placement of the following devices with appropriate reasons:
a. Switch/Hub
b. Repeater - Suggest a protocol that shall be needed to provide a Video Conferencing solution between Kashipur Campus and Mussoorie Campus.
Advertisement Remove all ads
