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

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.


SQL INTERVIEW QUESTIONS - INDEX

Explain different types of JOINS in SQL ?