SQL for Beginners Dummies Data Analysts Advanced Pdf free download, dummies, commands, examples, Microsoft SQL ServerOracle, DB2, Sybase, MySQL, Postgresql, Teradata.

SQL for BEGINNERS and DUMMIES - INDEX

What is SQL, Table, Database and RDBMS

What is Relational Database

Creating Table and Inserting Data

Data Reading SQL Funtions with Examples

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.