What is SQL, Table, Database and RDBMS.

SQL for BEGINNERS
and DUMMIES

What is SQL, Table,
Database and RDBMS

What is Relational Database

PRIMARY KEY
FOREIGN KEY

Creating Tables and
Inserting Data

CREATE
ALTER
INSERT

Data Reading SQL
Funtions with Examples

SELECT
COUNT
DISTINCT
SUM | MIN | MAX
LIKE
WHERE

What is SQL ( Definition ) ?

BIG Data is ‘Unstructured Data’. We can define unstructured data as the data which is not organized in the form of COLUMNS and ROWS.

SQL - Is a STRUCTURED QUERY LANGUAGE which is mainly to used to interact with the following RDBMS databases such as:
Oracle
DB2
Sybase
Microsoft SQL Server
MySQL
PostgreSQL etc.


What is RDBMS ?

RDBMS - Relational Database Management Systems. These Databases are collection of related tables.
Example - SALES_DB this database by name contains all the tables in relation with the sales. They can be sales tables, payment tables, vendor tables etc.



What is TABLE ?

TABLE - Collection of COLUMNS and ROWS.


What is DATABASE ?

DATABASE - Collection of TABLES.