SQL Basic Concepts

PAGE UNDER CONSTRUCTION
What is SQL
What is RDBMS
What is DBMS
RDBMS v/s DBMS
What is a Transaction
Different types of keys
What is a Batch
What is a Function, name a few
What is a Stored Procedure
Function v/s Stored Procedure
Normalistion/De-Normalisation
Types of Statement (DML, DDL, DCL, TCL)
What are triggers ? Types ?
Define indexes
Different objects in DBMS
What is a schema / Data Dictionary
Joins, Types of Joins
What are Constraints
What are Views.

 

2011 ·Code-Studio by yrus.