Car Sales Analysis Using SQL
SQL- access and manipulate datbase
MYSQL-storing and managing data
JOINS:
INNER JOIN,LEFT JOIN, RIGHT JOIN, FULL JOIN
KEYS:
PRIMARY KEY,UNIQUE KEY, FOREIGN KEY
SUBQUERY: A subquery is a query within another query.The outer query is main query and inner query is subquery.
STORED PROCEDURE:A function consists of many SQL statement to access the databse system.
TRIGGER: A DB Trigger is a code or program that automatically execute with response to some events on a table or view in a database.
CONSTRAINT: NOT NULL, CHECK,DEFAULT,UNIQUE,PRIMARY KEY,FOREIGN KEY.
DDL- Data Definition Language
DQL-Data Query Language
DML- Data Manipulation Language
DCL- Data Control Language
TCL-Transaction Control Language