SQL COMMANDS - CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE ….SET…., INSERT, DELETE; SELECT, DISTINCT, FROM, WHERE, IN, BETWEEN, GROUP BY, HAVING, ORDER BY

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

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

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

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