Now whats dis RDBMS

Allows u to access and manipulate data within their databases, protect the data from corruption and inconsistence

Difference b/w DBMS and RDBMS

RDBMS is specific to relational databases and it not only supports storage of data in table like structure but also relationships b/w those tables

Managing Databases...

• Creating
• Modifying
• Deleting

Creating database

Syntax : create database <databasename>;

>>>create database sfd;

Using database

Syntax : use <databasename>;

>>> use sfd;

Deleting database

Syntax : drop <databasename>;

drop sfd;

Creating table

Syntax : create table<tablename>(

<columnname1> <datatype>(<size>) <constraints>

..............

.............);

Managing Tables...

• Creating
• Modifying
• Deleting

Some basic commands...

• create : to create
• delete : to delete
• drop : to remove
• select : used to view the data in the table
• update: to update the data in any existing column
• insert: to insert a new row
• alter : to add a new column or modify the existing one

Clauses of Select statement

• Where
• Group By
• Having
• Order By