TCL also known as Transaction Control Language.It is used to manage different transactions occurring within a database.Various statements included under this category are:
1) COMMIT
2) ROLLBACK
COMMIT:
This is used to commit or saving the changes permanently you have made.Syntax:
COMMIT;
ROLLBACK:
It is used to discard the changes you have made.Syntax:
ROLLBACK;
IMPORTANT POINTS:
1) In case of Mysql,always use START TRANSACTION at the beginning.
2) When you use commit/rollback.It...
DCL is also known as DATA CONTROL LANGUAGE.It is used to create roles, permissions, and referential integrity.Moreover,It is used to control access to database by securing it.Statements included under DCL are:
1)GRANT
2)REVOKE
GRANT:
It is used to grant privileges at specified access level. Syntax:
GRANT privilege[....]
ON object[,.....]
TO { PUBLIC | GROUP | USERNAME};
REVOKE:
The REVOKE statement enables system administrators to revoke privileges from...
DML also known as Data Manipulation Language.It is used to retrieve, store, modify, delete, insert and update data in database.Various statements or commands included under this category are:
1)INSERT
2)SELECT
3)UPDATE
4)DELETE
INSERT:
This statement is used to insert data into a table. Syntax:
INSERT INTO <table name>(<column name1>,.....)
VALUES('a','b','c');
*(column name1,....) is an optional part.
*If you are writing a column names make sure count of no. of...
DDL refers to Data Definition Language.This is used for defining a database.
Commands or Statements included under this category are:
1)CREATE
2)ALTER
3)DROP
CREATE:
CREATE statement is used to create databases or tables.
Creating a Database:
CREATE DATABASE <database name>;
Creating a table:
CREATE TABLE <table name>
(
<column name> <data type> <constraint>,
...
...
);
ALTER:
ALTER statement is basically used to modify a table.Modifying a table means modifying...
E-R MODEL:
The Entity-Relationship model is based on a perception of the world as a collection of basic objects(entities) and relationships amongh these objects.
RELATIONAL MODEL:
Data and Relationships are represented by a collection of tables.Each table has a number of columns with unique names.For example:customer,account.
NETWORK MODEL:
Data are represented by collection of records.Relationships among data are represented by links.Organization...
SQL refers to "Structured Query Language". It is basically used to retrieve data from databases with the help of select statement.Moreover,You can create databases using create commands.
Some Important terms Of MYSQL are:
DATABASE(DB):
A database is a collection of logically related data.It is used to search data to answer queries.A database may be designed for batch processing,real time processing,or online processing.
DATABASE MANAGMENT SYSTEM(DBMS):
Database System is a set of software or...
