Sunday 19 February 2017

Microsoft SQL Made Easy

Microsoft SQL Made Easy

Prepared by Shri. O.Madhavaraj, Sr. AO CC Computer





Some basic facts about computer :

Hardware:
·         Physical parts of the computer are called hardware.
·         You can touch, see and feel hardware.
·         Hardware is constructed using physical materials or components.
·         Computer is hardware, which operates under the control of a software.
·         If hardware is damaged, it is replaced with new one.
·         Hardware is not affected by computer viruses.
·         Hardware cannot be transferred from one place to another electronically through network.
·         User cannot make new duplicate copies of the hardware.
Software:
·         A set of instructions given to the computer is called software.
·         You cannot touch and feel software.
·         Software is developed by writing instructions in programming language.
·         The operations of computer are controlled through software.
·         If software is damaged or corrupted, its backup copy can be reinstalled.
·         Software is affected by computer viruses.
·         Software can be transferred from one lace to another electronically through network.
·         User can make many new duplicate copies of the software.

Types of Software:
·         System software - device drivers, operating systems, servers, utilities, window systems
·         Programming software - compilers, debuggers, interpreters, linkers, text editors
·         Application software - accounting software, office suites, databases, media players, web browser

                 Difference between System & Application Software
System Software

Application Software

1. It is a set of programs to control computer components and operations.

1. It is used to solve particular problems of user.

2.  It is general-purpose software.

2. It is specific purpose software.

3. It executes all the time in computer. Because it controls overall operations and components of computer.

3. It executes as and when required. For example, if we need to write a letter, we will open Microsoft Word - an application software. And after we have written and printed the letter, we will close Microsoft Word.

4. The number of system software is less than application software.

4. The number of application software is much more than system software.

5. System software is essential for a computer to work. Without System software (like operating systems), a computer is useless. We cannot use computer hardware without system software. That is why we install an operating system first of all, after buying a new computer.

5. Application software is not essential for a computer to work. For example, if we need to play some games then we buy a game CD or download games from internet, and install in our computer.

6. Examples are: Windows, Dos, Unix, Linux, Norton Antivirus etc.
6. Examples are: MS Word, MS Excel, MS Power point etc.

What is operating system ?

It is an interpreter between the user and the computer. It converts the alphabets and numeric etc what we keying in to bits to communicate with the computer.

Some of the operating systems

DOS
Windows 95
Windows 98
Windows 2000
Windows XP
Windows 7
Windows server 2000
Windows server 2003
Windows server 2008
Unix
Linux

Bit consists of 1,0 only

8 bits = 1 Byte ie 1 bit =0.125 byte
1024 bytes = 1 Kilo bytes (KB )
1024 KB     = 1 MB
1024 MB     =1 GB 



Prepared by Shri. O.Madhavaraj, Sr. AO CC Computer

0 comments:

Post a Comment