Skip to main content

Database Management system and SQL , Boolean Algebra and Network and open source software

Database management system and SQL
Database Concepts :
Introduction to data base concepts and its need.
Relational data model :  Concept of domain, tuple, relation, key, primary key, alternative key, candidate key;
Relational algebra :  Selection, Projection, Union and Cartesian product;
Structured Query Language : 
General concepts :  Advantages of using SQL, Data Definition Language and Data Manipulation Language;
Data types : NUMBER/DECIMAL, CHARACTER/VARCHAR/VARCHAR 2, DATE;
SQL Commands :
CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE...SET..., INSERT, DELETE;
SELECT, DISTINCT, FROM, WHERE, IN, BETWEEN, GROUP BY, HAVING, ORDER BY;
SQL functions : SUM( ), AVG( ), COUNT( ) and MIN( ); Obtaining result (SELECT query) from 2 tables using equi-join, Cartesian Product and Union 
Note : implementation of the above mentioned commands could be done on any SQL supported software on one ar two tables 
Boolean Algebra 
Role of Logical Operations in Computing.
Binary-valued Quantities, Boolean Variable, Boolean Constant and Boolean Operators : AND, OR, NOT ; Truth Tables ; Closure Property, Commutative Law, Associative Law, Identity Law, Inverse law, Principal of Duality, Idempotent Law, Distributive Law, Absorption Law, Involution law, DeMorgan's Law and their applications ;
Obtaining sum of Product (SOP) and Product of sum (POS) form from the truth table, Reducing Boolean Expression (SOP and POS) to its minimal form, use of Karnaugh Map for minimisation of Boolean Expression (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 statement.
Use of Boolean operators (AND, OR) in search engine queries.
Network and Open Source Software 
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, Gbps);
Transmission Media :
Twisted pair cable, coaxial cable, optical fiber, infrared, radio link, microwave link and satellite link.
Network Device :
Modem, RJ45 connector, Ethernet Card, Router, Repeater, switch, Gateway, wifi card.
Network topologies and types :
Bus, Star, Tree, PAN, LAN, WAN, MAN;
Network protocol :
TCP/IP, file Transfers Protocol (FTP), PPP, SMTP, POP3, Remote Login (Telnet), Internet Wireless/mobile communication protocol such as GSM, CDMA, GPRS, WILL.
Mobile Telecommunication technologies 
1G, 2G, 3G and 4G ; Mobile Communication Technologies ; Mobile Processor 
Electronic mail protocols such as SMTP, POP3
Protocols for chat and video Conferencing VOIP
Wireless technologies such as Wi-Fi and WiMax 
Network security Concepts :
Threats and prevention from viruses, Worms, Trojan horse, Spams 
Use of cookies, Protection using Firewall.
India IT Act, Cyber Law, Cyber Crimes, IPR issues, Hacking 
Introduction to Web Services 
WWW, Hyper Text Markup Language (HTML), eXtensible Markup Language (XML); Hyper Text Transfer Protocol (HTTP); Domain names; URL; Website, Web browser, Web Servers; Web Hosting, Web Scripting-Client side (VB Script, Java Script, PHP) and server side (ASP, JSP, PHP), Web2.0 (for social networking)
E-commerce 
Payment transaction using online banking, mobile banking and payment apps and services.

Comments

Post a Comment

Popular posts from this blog

Object oriented programming in C++ and Data structure

Object-oriented programming: Concept of object oriented programming- Data hiding, Data encapsulation, Class and Object, Abstract class and concrete, Polymorphism (Implementation of polymorphism using Function overloading as an example in C++) ; Inheritance, Advantages of object oriented programming over earlier programming methodologies, Implementaion of object oriented programming concepts in C++ Defination of a class, Members of a class -Data Members and member Functions ( methods), Using private and public visibility modes, default visibility mode (private); Member Function definition : inside class definition and outside class definition using scope resolution operator (::); Declaration of objects as instance of a class ; accessing members from object (s), Objects as function arguments-pass by value and pass by reference; Pointers : Introduction to pointers, Declaration and initialisation of pointers ; Dynamic memory allocation/deallocation operators : new, delete; Pointers and Ar...
Post a Comment
Read more

C++ Revision Tour: introduction, C++ Basics(C++ character set and tokens)

1. C++ Revision Tour 1.1 INTRODUCTION :: The C++ programming language was developed at AT&T Bell Laboratories in the early 1980s by Bjarne Stroustrup. He found 'C' lacking for simulations and decided to extend the language by adding features from his favourite language, Simula 67. Simula 67 was one of the earliest object-oriented languages. Bjarne Stroustrup called it "C with classes" originally. The name C++ (Pronounced C plus plus) was coined by Rick Mascitti where "++" is the C increment operator. Ever since its birth, C++ evolved to cope with problems encountered by users, and through discussions at AT&T. However, the maturation of the C++ language was attested to by two events:  The formation of an ANSI (American National Standard institute) C++ committee  The publication of the Annotated C++ Reference Manual by Ellis and Stroustrup. The latest C++ standards document was issued by ANSI/ISO in year 2011 namely C++11 or formally C++0x . The m...
Post a Comment
Read more