Interesting to Queries

Avoid Duplicate Records
SELECT DISTINCT SALARY
FROM EMPLOYEE
Union of two Records-Duplicates are removed

SELECT Date FROM Store_Information
UNION

Union All -Here Duplicates are not removed

Pattern Matching-comparison on condition
%- zero or more characters
_underscore -Single character
SQL IN –

SELECT “column_name”
FROM “table_name”
WHERE “column_name” IN (‘value1′, ‘value2′, …)

An SQL JOIN clause combines records from two or more tables in a database.




Introduction to Linux

GNU/Linux-GNU is a free software foundation founded by Richard stallsman and Linux is a free opensource operating system founded by Linus torvalds.

Complete Unix-compatible software system was the aim GNU ,Richard stalls man, he founded the free software foundation and wrote GNU GPL many of the programs required for an operating system were completed

Minix was cheap minimal operating system,torvalds began to work on a non-commercial replacement of minix,Later Linux matured and it became possible for Linux to be developed under itself.Also GNU applications replaced all Minix ones because, with code from the GNU system freely available, it was advantageous if this could be used with the fledgling OS. Code licensed under the GNU GPL can be used in other projects, so long as they also are released under the same or a compatible license. In order to make the Linux kernel compatible with the components from the GNU Project, Torvalds initiated a switch from his original license (which prohibited commercial redistribution) to the GNU GPL.Developers worked to integrate GNU components with Linux to make a fully functional and free operating system.

So the Linux is a free open source operating system founded by Linus torvalds, Under Linux Kernel it handled networking,process control and peripherals

User Interface:Users can control a Linux-based system through a command line interface (or CLI), a graphical user interface(or GUI), or through controls attached to the associated hardware (this is common for embedded systems)

KDE, GNOME and xfc are the most common user interfaces, Most top of the user interfaces run on the top of the X-windows system

The primary difference between Linux and many other popular contemporary operating systems is that the Linux kernel and other components are free and open source software. Linux is not the only such operating system, although it is by far the most widely used. Some free and open source software licenses are based on the principle of copyleft, a kind of reciprocity: any work derived from a copyleft piece of software must also be copyleft itself. The most common free software license, the GNU GPL, is a form of copyleft, and is used for the Linux kernel and many of the components from the GNU Project.

A distribution is largely driven by its developer and user communities. Some vendors develop and fund their distributions on a volunteer basis, Debian being a well-known example. Others maintain a community version of their commercial distributions, as Red Hat does with Fedora.

Most Linux distributions support dozens of programming languages like PHP,Perl,Python,Ruby and other dynamic languages.

Many types of applications available for windows and Mac OS X are also available for Linux. Commonly, either a free software  application will exist which does the functions of an application found on another operating systems, or that application will have a version that works on Linux (such as Skype) (Eg:Wine tool,Openoffice.org,mozilla firefox etc:)

Many applications are initially developed for Linux later it had come the windows also (such as Pidgin, and GIMP)

Linux distributions have long been used as server operating systems

The Linux market is growing rapidly, and the revenue of servers, desktops, and packaged software running Linux was expected to exceed $35.7 billion by 2008

The Linux kernel and most GNU software are licensed under the GNU General Public License (GPL). The GPL requires that anyone who distributes the Linux kernel must make the source code (and any modifications) available to the recipient under the same terms. In 1997, Linus Torvalds stated, “Making Linux GPL’d was definitely the best thing I ever did.” Other key components of a Linux system may use other licenses; many libraries use the GNU Lesser General Public License (LGPL), a more permissive variant of the GPL, and the X Window System uses the MIT License.

Remember:In the United States, the name Linux is a trademark registered to Linus Torvalds.

Interesting topic

The Free s/w Foundation views Linux distributions which use GNU software as GNU variants and they ask that such operating systems be referred to as GNU/Linux or a Linux-based GNU system The media and common usage, however, refers to this family of operating systems simply as Linux, as do many large Linux distributions (e.g. Ubuntu and SuSE Linux). Some distributions use GNU/Linux (particularly notable is Debian GNU/Linux, on which Ubuntu is based), but the term’s use outside of the enthusiast community is limited. The naming issue remains controversial. Linus Torvalds does not support the use of the term GNU/Linux

The Linux kernel and most GNU software are licensed under the GNU General Public License (GPL). The GPL requires that anyone who distributes the Linux kernel must make the source code (and any modifications) available to the recipient under the same terms. In 1997, Linus Torvalds stated, “Making Linux GPL’d was definitely the best thing I ever did.”[80] Other key components of a Linux system may use other licenses; many libraries use the GNU Lesser General Public License (LGPL), a more permissive variant of the GPL, and the X Window System uses the MIT License.

Introduction to Internet and WWW

Welcome to the Internet

The Internet is a global network of networks.

The Terms which related to  internet are

IPC-Inter Process Communication

Web Client-Web browsers like IE,Firefox etc:

Web Servers-Like IIS ,Apache(Most used server)

Domains/IP/URL-www.wordpress.com/IP denoting IP no/URL-Uniform Resource Locator(Unique Identifier of a web page)

First registered domain name was symbolics.com 1985

CTSS -was one of the first time sharing operating systems(1962) ; it was developed at MIT’s Computation Center,Used in IBM  7094(1965)

Internet,first it was ARPANET in 1969,Internet has started using at 1973 by NASA,commonly the first internet interface was using for gaming

MMORPG (Massively multiplayer online role-playing game) was first shooting game invented late 1970′s

Late 1970′s started news group era(first form of social networking sites) and Usenet 1979(News group 1979)

1976– Networking comes to many-Queen Elizabeth sends out an e-mail

UUCP (Unix-to-Unix CoPy) developed at AT&T Bell Labs and distributed with UNIX.

City bank has implemented first Virtual banking on late 1981.

In 1990 www is a system of interlinked hypertext documents accessed via the Internet. With a web browser, one can view web pages that may contain text, images,videos, and othermultimedia and navigate between them using hyperlinks.

World-Wide Web released by CERN on late 1992

<RFC – Request for Comments>

Mosaic Web browser introduced in 1993

Wiki applications in 1994

Stanford Federal Credit Union – First Internet Banking in 1994

Southerland was the first blogger

Backrub was the first search engine (Interesting Tips:Google means one followed by 100 zero’s)

Hotmail was introducd in 1996 july 4 (first ISP based Email)

ICQ(I Seek You)-was the internet wide instant messenger

Delphi was the first national commercial online service to offer Internet access to its subscribers. It opened up an email connection in July 1992 and full Internet service in November 1992.

Netscape Navigator in 1994 also commercialization begins

Slashdot launched in 1997  like a digg ( is a social news website  made for people to discover and share content from anywhere on the internet)

Microsoft’s full scale entry into the browser, server, and Internet Service Provider market completed the major shift over to a commercially based Internet. The release of Windows 98 in June 1998 with the Microsoft browser well integrated into the desktop shows Bill Gates’ determination to capitalize on the enormous growth of the Internet.

Movies Marketing Online started in 1999

Fixed Wireless has come at 2000

2001-Wikipedia evolution, Apple released i pods,Amazon books

2003 Second life(virtual world),skype,ebay(Online shopping)

2004-Web 2.0 evolution-commonly associated with web development and web design that facilitates interactive information sharing, interoperability, user-centered design[1] and collaboration on the World Wide Web. Examples of Web 2.0 include web-based communities, hosted services, web applications, social-networking sites, video-sharing sites, wikis, blogs, mashups and folksonomies. A Web 2.0 site allows its users to interact with other users or to change website content, in contrast to non-interactive websites where users are limited to the passive viewing of information that is provided to them. Eg:Face book,Twitter,Link in,Flickr,second life etc:

In our initial brainstorming, we formulated our sense of Web 2.0 by example:

Web 1.0 Web 2.0
DoubleClick –> Google AdSense
Ofoto –> Flickr
Akamai –> BitTorrent
mp3.com –> Napster
Britannica Online –> Wikipedia
personal websites –> blogging
evite –> upcoming.org and EVDB
domain name speculation –> search engine optimization
page views –> cost per click
screen scraping –> web services
publishing –> participation
content management systems –> wikis
directories (taxonomy) –> tagging (“folksonomy”)
stickiness –> syndication

http://oreilly.com/web2/archive/what-is-web-20.html

2005-The Web become platform i.e WWW is a platform

Present-Going on Invention , Be the Part



Innovation of Technology-Open source Tech

Welcome to Lamp Book for getting ideas about LAMP technologies, start updating you in LAMP  with my blog

Follow

Get every new post delivered to your Inbox.