cdac 2010 database presentation

Database technology Part-2

THERE ARE MANY UPCOMING TECHNOLOGY DATABASE ABOUT ACCESS DATABASE
what is database
what is database system
what is database development will all be covered in this database presentation

web database technolgy is based on sql database and upcoming database are the fusion oracle database .
Smallest db is couchdb used in Iphone apps and in html5 .

Structured Query Language

It’s a relational database language
SQL commands are the means of communication with DBMS
SQL can be categorized as

DDL(Data Definition Language):Those SQL commands that
Operate on structure of database objects (table)?
Create,Alter,Drop.

DML(Data Manipulation Language): Those SQL commands
that operate on the data stored in the database objects.
Insert,Update,Delete,Select

DCL(Data Control Language): Those SQL commands that
Control the behavior of database objects
Commit,Rollback,Save point

Data types

Character data types
-CHAR(size):Stores fixed length character data.
Max size is 2000 bytes. Default & min size is 1 byte.

-VARCHAR2(size): Stores variable length character strings.
Max size is 4000 bytes, Min size is 1 byte. Must specify size.

-LONG:Columns defined as LONG can store variable-length
character data containing up to two gigabytes of information.

Number data types
-NUMBER(p,s): Stores numbers (fixed or floating point).

DATE: stores date & time. Standard format is
DD-MON-YY HH:MI:SS

Data types

LOB data types: Stores large blocks of unstructured
data (such as text, graphic images, video clips, and
sound waveforms) up to four gigabytes in size.
-BLOB: stores up to four gigabytes of binary data
-CLOB: stores up to four gigabytes of character data.
-BFILE:stores a file locator that points to an external file
containing the data.

RAW/LONG RAW:used to store binary data such as picture
image .
RAW max length 2000 bytes.
LONG RAW: 2gigabytes.

DML consist of-

Create
Alter
Drop

here is the link to download
download original cdac ppt

10g databaseaccess databasec# access databaseclient databaseconnecting databaseconnection databaseconvert access to sqlcopy technologydatabase advantagesdatabase codedatabase comparisondatabase conceptsdatabase connectdatabase engineeringdatabase fromdatabase indiadatabase installationdatabase introductiondatabase programsdatabase querydatabase replicationdatabase stored proceduresdatabase systemdatabase tablesdatabase technologiesdatabase technologydatabase withdatabases for dummiesdb databasedbms databasedelete databasedesigning databaseexample databasehow to databaseinstall databaselinux databasemicrosoft sqlmicrosoft sql servermicrosoft technologyms sql server databasemssql databasenew database technologiesperformance sqlperformance sql serverperformance sql server 2000performance tuning sql serverppt databaseselect databaseserver databasesql 2000sql databasesql database designsql generatorsql scriptssql serversql server 2000sql server 2000 tutorialsql server applicationssql server copy tablesql server database designsql server databasessql server dbasql server programmingsql server toolssql server tutorialssql technologysqlserver databasetable databasetechnology databasestrigger databaseusing databaseweb database applicationweb database technologies