commands and functions
There are many commands and functions that are often used in SQL, including:
CREATE DATABASE (create database)
ALTER DATABASE (database change)
DROP DATABASE (delete the database)
CREATE TABLE (create table)
CREATE TABLE (create table)
ALTER TABLE (changing the structure of the table)
DROP TABLE (delete the table)
CREATE VIEW (to view)
ALTER VIEW (view change)
DROP VIEW (clear view)
CREATE PROCEDURE Read the rest of this entry »
DDL and DML
1. DDL (data definition language), the languages which have the ability to define datarelating to the creation and deletion of objects such as tables, indexes, and even their own data bases. For example, CREATE, DROP, and ALTER.
2. DML Read the rest of this entry »
What is Row and Key ?
This post I will discuss about the Row and the Keys.
DEFINITION ROW
Data in the table are also stored in: Each record is stored in its own row. Like the previous way, imagine the table as a spreadsheet model grid. Vertical columns in the grid are the table columns and horizontal rows are the rows of the table.
DEFINITION KEY
Each row in the table can have Read the rest of this entry »
No Comments »
What is Column and Data Type ?
DEFINITION COLUMN
The table is composed of several columns. Column contains the information in the table. An easy way to understand this is to imagine a database table as a grid (similar to a spreadsheet). Each column in the grid contains a certain part of the information. In the customer table for example, one column contains the number of customers and other columns contain the name of the customer. Address, Read the rest of this entry »
No Comments »
What is Database and Table ?
In previous post we discussed the basic concepts of databases, this time we will discuss about the meaning of the terms that exist in SQL.
Database
Read the rest of this entry »
No Comments »
Basic concept
SQL is the language used to interact with the data-base. But before we learn more about SQL, we need to understand the basic concepts of databases and database technology.
Actually in daily life we always use the database. While we find the name email address book,
Read the rest of this entry »
No Comments »
History of SQL
The history of SQL begins from an article that does EF Codd of IBM research laboratory,the article discusses the idea of making a relational database in mid 1970, precisely in June. This post also discussed the possibility of making a standard languagefor accessing data in the database. Language is
Read the rest of this entry »