Computer Applications

Friday, April 9, 2010

CD-RW discs

CD read / write disks support the creation of CD-R and CD-RW discs, and feature the CD-ROM drive. These

drives use a low power laser "burning" of data in the active layer of the disc.

CD-R (write CD) discs are 'write once - they are writing data can not be erased or altered. However,

multisessions can be created and additional data can be added.

CD-RW (rewritable CD) discs can be written or delete several times. This two-pass process, so they

typically take twice as many CD-R disc production.

CD-RW discs, as a rule, three speed ratings - one for reading the disc, one for writing CD-R discs, and

the second for writing CD-RW discs. Speed ratings range from 1 to 52x, which means that 1x CD read /

write in "real time" - 52 minutes audio CD takes about 52 minutes to create 1x speed and speed about 1

minute 52x.

Data can be written to disk in various formats to create a CD, data, CD, CD or video file from the

CD-ROM. Audio CD, to play in most standard CD audio equipment, video and photo discs will play on many

players in the consumer DVD.

Many writers CD (also known as "vodka"), is directed to function as a combination DVD-ROM drive.

Most DVD-RW discs and CD-RW capabilities.

Memory.

Memory - Memory can be very confusing, but as a rule, one of the most simple piece of equipment in

addition to your computer. It is common to confuse the memory chip ROM. For example, the difference

between memory and storage is the difference between the table where the actual work (memory), a closet,

where the final product is stored (disk). Can be used to add a little more confusion, the hard disk and

memory, when the program needs more chips can provide.

Memory or RAM memory, which is used for temporary storage of information, which is also considered.

Processing more detailed information on more RAM in your computer needs.

Use one of the first home computers 64 kilobytes of RAM (Commodore 64). Today, modern computers should

be at least 64 MB (recommended 128 MB or more) to run the operating system or Windows 10 with modern

programs.

RAM chips have different size and speed, and can usually be expanded. For computers with 512 kilobytes

of memory, which can be expanded to a maximum of 640 KB. But perhaps the most modern computers the

memory can be expanded by adding or replacing memory chips depending on the CPU you have and the type of

memory device uses your computer. Memory chips, ranging in size from 1 MB to 4 GB. As computer

technology changes such as changes in memory, as well as making old memory chips obsolete. Check your

computer manual to find out what type of memory on your computer before buying the new memory chips.

Scanner.

Scanners, Scanners allow you to transfer pictures and photos on your computer. scans 'Scanner' icon from

the top down, on one line time and passes on the computer as a series of bits or a bitmap file. You can

take images and use them in the paint, and send it by fax or print it. With optional Optical Character

Recognition (OCR) software that can convert printed documents such as newspaper articles, and text that

can be used in a text editor. Most scanners use TWAIN software that makes the scanner accessible to

other software applications.

Digital cameras allow you to capture digital photos. Images are stored on a memory card or disk that can

be transferred to your computer. Some cameras can also capture audio and video.

Issue - the issue of houses chips and circuits that are running on your computer. Desktop models usually

sits under the control and tower models beside. They come in many sizes, including desktop, mini, midi,

and full tower. There is usually room to expand or add components at a later date. Removing the cover to

this issue can be found covered with leaves, the empty slots for adding cards. There are different types

of slots including IDE, ASI, USB, FireWire and PCI slots.

Depending on the laptop may be the type of room for expansion. Most notebook computers, as well as

connections or ports that allow expansion or connection of external and peripheral devices, such as

monitoring and portable hard drives or other devices.

Modem

Modem - a modem is used to translate information transferred through telephone lines, cable or line of

site wireless connection.

Shelf stands for modulate and demodulate the signal from analog to digital change, using computers, in

which use of phones and then back. Digital modem direct transfer of digital information, without

changing the analog.

Modems are measured by the speed that information is transferred. This tool is called the Baud rate

dimensions. Initially work quickly under the 2400 Baud modem speed but are analogous to today's

standards 56.000. Cable, wireless or digital subscriber line can transfer more information faster to

300000 Baud rates and above.

Modems use error correction, which corrects for transmission errors by constantly check whether the

information was received correctly or not, and compression, which allows faster data transfer speed.

Information is transferred in packets. Each package is checked for errors and re-sent if there is an

error.

Anyone who has used the Internet have noticed that sometimes the information travels at different

speeds. Depending on the amount of information that is transferred, the information will arrive at the

destination in time is different. The amount of information that can travel through the line is limited.

This restriction is called traffic.

There are many other variables associated with communication technology using computers, much of which

is covered on the Internet.

Mointor and Printer

Monitor - shows the monitoring information on the screen when writing. This is called the output

information. When the computer needs more information to display a message on the screen, usually

through a dialog box. Monitors come in many types and sizes. Solution sets a unit of the monitor

display. Resolution can be adjusted to control the screen ..

Most desktop computers use a device with a cathode ray tube or LCD screen. Most of the use of laptop

computers with liquid crystal display monitor.

To take full advantage of the programs today with full-color graphics and animation, computers need a

monitor with a color screen or video card.

Printer - a printer receives information on the screen, and transferred to paper or hard copy. There are

many different types of printers with various levels of quality. Three basic types of the printer; dot

matrix, inkjet and laser.
Dot matrix printers work like a typewriter ink transfer from the tape to the paper with string or

'Matrix' of small nails.
Printers, ink jet printers work like a bitmap, but unleash a torrent of ink from the cartridge directly

on paper.
Laser printers use the same technology to a photocopier using heat to transfer ink on paper.

Types of Computer Hardware.

Computer hardware is a physical piece of hardware inside a computer program. This is in contrast to

computer programs or data that change frequently, modified or removed in a computer. Computer hardware

is not changed and is stored in devices such as read only memory (ROM) where it does not change easily.

Most computer hardware is embedded and so is not visible to ordinary users. Here are the different types

of hardware in a computer.

- Motherboard: This is the central or primary circuit board making a complex electronic system such as a

computer. A motherboard is also known as a key board, logic board or system board.
- Central processing unit, a CPU is the main component of a digital computer that interprets

instructions and process data in computer programs.
- Random Access Memory: a memory stored data can be found in any way. RAM is considered the main memory

of the computer where the work area to display and manipulation of data is used.
- Basic Input Output System: BIOS, software programs to download, execute and control the computer.
- Power supply: Power supply electricity to provide an output load or group of taxes.
- Video Display Controller: It converts the logical representation of visual information in a signal

that can serve as input for a secondary display is used.
- Business Computer: It is used for data or power between computer components to transfer to a computer

or between computers.
- CD-ROM drive: It contains data available from computer
- Floppy Disk: This is a data storage device
- Zip Drive, "This is a medium-capacity removable disk storage system.
- Hard Disk: This is a non-volatile data storage system that stores data on a magnetic surface layer on

the hard disk clean.

Tuesday, March 16, 2010

Web Hosting

A web hosting service is a type of Internet hosting service that allows individuals and organizations to make their own website accessible via the World Wide Web.
In large companies who are not internet service providers also need a computer permanently connected to the web so they can send email, files, etc. to other sites. They may also use the computer as a website host so they can provide details of their goods and services to anyone interested.

Categories Of Web Hostings

Free web hosting service
Shared web hosting service
Reseller web hosting
Virtual Dedicated Server
Dedicated hosting service
Managed hosting service
Colocation web hosting service

Cloud Hosting: is a new type of hosting platform that allows customers powerful, scalable and reliable hosting based on clustered load-balanced servers and utility billing.

Grid hosting: this form of distributed hosting is when a server cluster acts like a grid and is composed of multiple nodes.

Domain

1.Domain Name System (DNS), an hierarchical naming system for computers or any resource connected to the Internet.
2.Domain model, a conceptual model of a system that describes the various entities involved and their relationships
3.Domain name registrar, an organization that manages the reservation of Internet domain names in one or more domains.

Web Site

A web site is a collection of related web pages, images, videos or other digital assets that are addressed relative to a common Uniform Resource locator (URL), often consisting of only the domain name, or the IP address, and the root path ('/') in an Internet Protocol-based network.

A web page is a document, typically written in plain text interspersed with formatting instructions of Hypertext Markup Language (HTML,XHTML).

Saturday, January 23, 2010

What is MySQL?

1.MySQL is a database.
2.The data in MySQL is stored in database objects called tables.
3.A table is a collections of related data entries and it consists of columns and rows.

Queries:

A query is a question or a request.

With MySQL, we can query a database for specific information and have a recordset returned.

Create a Connection to a MySQL Database

Code:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
?>

Closing a Connection in PHP & MySQL.

Code:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_close($con);
?>

Create Database and Tables in MySQL

Code:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_close($con);
?>

Create a Table in MySQL

Code:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE Persons
( FirstName varchar(15),
LastName varchar(15),
Age int )";
mysql_query($sql,$con);
mysql_close($con);
?>

Insert Data Into a Database Table In MySQL

Code:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
mysql_query("INSERT INTO Persons (FirstName, LastName, Age)VALUES ('Peter','Griffin', '35')");
mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Glenn', 'Quagmire', '33')");
mysql_close($con);
?>

Select Data From a Database Table in PHP,MySQL

Code :

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
$result = mysql_query("SELECT * FROM Persons");
while($row = mysql_fetch_array($result))
{
echo $row['FirstName'] . " " . $row['LastName'];
}
mysql_close($con);
?>

The Where Clause in MySQL

Code:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
$result = mysql_query("SELECT * FROM Persons WHERE FirstName='Peter'");
while($row = mysql_fetch_array($result))
{
echo $row['FirstName'] . " " . $row['LastName'];
}
?>

The ORDER BY Keyword in MySQL

It is is used to sort the data in a record-set.

Code:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
$result = mysql_query("SELECT * FROM Persons ORDER BY age");
while($row = mysql_fetch_array($result))
{
echo $row['FirstName']; echo " " . $row['LastName']; echo " " . $row['Age'];
}
mysql_close($con);
?>

Update Data In a Database in PHP,MySQL

Code :
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("my_db", $con);
mysql_query("UPDATE Persons SET Age = '36' WHERE FirstName = 'Peter' AND LastName = 'Griffin'");
mysql_close($con);
?>

Delete Data In a Database in PHP,MySQL

Code:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
mysql_query("DELETE FROM Persons WHERE LastName='Griffin'");
mysql_close($con);
?>

Tuesday, January 5, 2010

JavaScript Tutorial

JavaScript is The Scripting Language of the Web.

Example:


script type="text/javascript"
document.write("This is my first JavaScript!");
script


Output Is : This is my first JavaScript!

JavaScript is an easy-to-use programming language that can be embedded in the header of your web pages. It can enhance the dynamics and interactive features of your page by allowing you to perform calculations, check forms, write interactive games, add special effects, customize graphics selections, create security passwords and more.

C Tutorial.

C is a programming language of many different dialects, similar to the way that each spoken language has many different dialects.

Example:
#include
int main()
{
int this_is_a_number;
printf( "Please enter a number: " );
scanf( "%d", &this_is_a_number );
printf( "You entered %d", this_is_a_number );
getchar();
return 0;
}

Output Is:
a = 4 * 6;
a = a + 5;
a == 5.
There are several common compilers: in particular, Borland C++, Microsoft C++, and GNU C. There are also many front-end environments for the different compilers the most common is Dev-C++ around GNU's G++ compiler.

C++ Tutorial

C++ is an object oriented language, which combines the best of the structured programming techniques of C, thus making it a very powerful language.
Example:
# include
int main()
{
std:: cout << “My first C++ program ” << std::endl;
return 0;
}

Output Is: My first C++ program

C++ is a superset of C; therefore most of C language constructs apply in C++ as well. A program in C++ can be written in both C style and Object Oriented style.

SQL (Structured Query Language).

SQL is a standard language for accessing databases.

1. SQL stands for Structured Query Language
2. SQL lets you access and manipulate databases
3. SQL is an ANSI (American National Standards Institute) standard

SQL can do

It can execute queries against a database
It can retrieve data from a database
It can insert records in a database
It can update records in a database
It can delete records from a database
It can create new databases
It can create new tables in a database
It can create stored procedures in a database
It can create views in a database
It can set permissions on tables, procedures, and views

SQL can be divided into two parts:
1.The Data Manipulation Language (DML)
2. The Data Definition Language (DDL).

DML

The query and update commands form the DML part of SQL:
SELECT - extracts data from a database
UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database

DDL

CREATE DATABASE - creates a new database
ALTER DATABASE - modifies a database
CREATE TABLE - creates a new table
ALTER TABLE - modifies a table
DROP TABLE - deletes a table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index

Creating Table in SQL

Each row represents one piece of data, and each column can be thought of as representing a component of that piece of data. So, for example, if we have a table for recording customer information, then the columns may include information such as First Name, Last Name, Address, City, Country, Birth Date, and so on.

SYNTAX

CREATE TABLE "table_name"
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2",
... )

Example

CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
Birth_Date date)

Insert Values into Table in SQL

One is to insert it one row at a time, the other is to insert multiple rows at a time. Let's first look at how we may INSERT data one row at a time.

Syntax

INSERT INTO "table_name" ("column1", "column2", ...)
VALUES ("value1", "value2", ...)

Example

INSERT INTO Store_Information (store_name, Sales, Date)
VALUES ('Los Angeles', 900, 'Jan-10-1999')

Select from Table

A common use is to select data from the tables located in a database. Immediately, we see two keywords: we need to SELECT information FROM a table.

Syntax

SELECT "column_name" FROM "table_name"

Example

SELECT store_name FROM Store_Information
Result:
store_name
Los Angeles
San Diego
Los Angeles
Boston

Update Command

   We can use the UPDATE command for modifying the data.

Syntax:

UPDATE "table_name" SET "column_1" = [new value] WHERE {condition}

Example:

UPDATE Store_Information SET Sales = 500 WHERE store_name = "Los Angeles"AND Date = "Jan-08-1999".

Delete Command

    We may wish to use a query to remove records from a table.

Syntax:

DELETE FROM "table_name" WHERE {condition}

Example :

DELETE FROM Store_Information WHERE store_name = "Los Angeles"