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
description
- CREATE Database
- Use database
- Show database
- Drop database
- Show tables
- CREATE Table
- Describe Table
- Drop Tables
- ALTER Table
- Add primary key to a relation
- Add foreign key to a relation
- Add constraint UNIQUE to an existing attribute
- Add an attribute to an existing table
- Modify datatype of an attribute
- Modify constraint of an attribute
- Add default value to an attribute
- Remove an attribute
⇒ Remove primary key from the table
- DROP Statement
If you would like to contribute notes or other learning material, please submit them using the button below.
Related QuestionsVIEW ALL [16]
Case Based
Consider the table STUDENT with the following detail.
| STU_ID | NAME | STREAM | MARKS | CLASS |
| 1. | Aditya | Science | 87.5 | 12A |
| 2. | Vikram | Commerce | 88.7 | 12B |
| 3. | Astha | Humanities | 76.8 | 12C |
| 4. | Varsha | Science | 79.5 | 12A |
| 5. | Kanishka | Science | 77.9 | 12A |
| 6. | Anand | Commerce | 86.7 | 12B |
Now answer the question given below:
Command to select all Science students from the table STUDENT
Case Based
Consider the table STUDENT with the following detail.
| STU_ID | NAME | STREAM | MARKS | CLASS |
| 1. | Aditya | Science | 87.5 | 12A |
| 2. | Vikram | Commerce | 88.7 | 12B |
| 3. | Astha | Humanities | 76.8 | 12C |
| 4. | Varsha | Science | 79.5 | 12A |
| 5. | Kanishka | Science | 77.9 | 12A |
| 6. | Anand | Commerce | 86.7 | 12B |
Now answer the question given below:
Delete records that belongs to 'Humanities' stream.
Advertisement Remove all ads
