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
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 ) ?

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.