What is SQL?
SQL Stands for Structured Query Language
SQL is a language to perform actions on databases like MYSQL, OracleDB, MongoDB, SQL Server etc.,
SQL is an ANSI Standard.
All Database use SQL as the standard database language.
Note: SQL is just a language, not a database where most people get confused by it as a database.
What is SQL Used for?
SQL is used:
To create a Database, tables, views.
To insert and retrieve records into database
To update records in database
To delete records in database
What can SQL do?
SQL can create, delete, update database.
SQL can create, delete, update, alter and drop new tables in a database.
SQL can insert, retrieve and update data records in a database.
What is Database?
The database is the collection of organized data.
The database is mainly used to operate a large amount of data by storing, retrieving and managing.
Every dynamic website on the WWW (World Wide Web) uses a Database to operate data of the site. For Example, e-commerce sites use the database for their operations.
There are many databases available. MYSQL, Oracle DB, Mongo DB, SQL Server, etc..
What is DBMS?
DBMS stands for Database Management System.
DBMS is used for managing the data like storing, retrieving data in an organized manner.
What is RDBMS?
RDBMS stands for Relational Database Management System.
It is as same as DBMS but it is based on the Relational model by E.F. CODD.
Databases like MYSQL, Oracle, SQL Server, IBM DB2, MS ACCESS are based RDBMS.
How RDMS works?
RDBMS is the most commonly used Database.
The data is stored in a number of tables in the terms of rows (tuples). Every table will have a primary key to retrieve data easily.
Data can be easily managed in RDBMS as the data is well organized in tables.
R.F.Wilson responds to the news yesterday about Buckingham Palace and Prince Andrew. Today's entry in the journal is about Scotland Yard, Prince Philip, Corgis and Prince William walking in the Palace grounds, all in the news for more info see the links below. If you live near Clapham Common or Hampstead Heath and curious to know more about dating and meeting up with people who have a sense of humorous understanding, then this post is for you. Go over to Stirring Trouble Internationally and enter in your comment in the comments box at the bottom of the entry or if you are on your mobile phone and have a QR Code scanner, scan the code attached to the right.