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.
Computer Applications
Friday, April 9, 2010
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.
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.
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.
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.
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.
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.
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.
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.
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).
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.
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());
}
?>
$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);
?>
$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);
?>
$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);
?>
$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);
?>
$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);
?>
$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'];
}
?>
$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);
?>
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);
?>
$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);
?>
$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.
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.
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.
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
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.
("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)
SYNTAX
("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')
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
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}
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 :
Subscribe to:
Posts (Atom)