Structure Query Language
SQL is a database computer language designed for the retrieval and management of data in a relational database. SQL - stands for Structured Query Language. Actual name is SEQUEL – Structured English Query Language. It was first developed at IBM in the early 1970. It became the industry standard of relational database querying languages in 1980. In 1987 Computerworld magazine published an article about SQL after that only it boomed. High traffic websites including Facebook, Twitter, and YouTube use SQL to handle billions of user interactions.
-
Key elements of Database (Creation, Alteration etc.,)
-
Keys
-
Select Queries
-
Joins & Type of joins
-
Relationship between Tables
-
Fact and Dimension Table Types
-
Stored Procedure
-
Comments & Operators
-
DDL basics
-
DML basic