SQL Overview
SQL is also the top and most popular language among data scientists or data engineers. Despite lots of hype around NoSQL, Hadoop, and other technologies, it’s one of the most-used languages in the entire tech industry, and one of the most popular languages for developers of all sorts.
Main Concepts:
Creating Database
Creating Tables and adding data
SELECT Clause
FROM Clause
WHERE Clause
DELETE Statement
INSERT INTO
AND and OR operator
Drop and Truncate
NOT Operator
WITH Clause
FETCH Clause
Arithmetic Operators
Wildcard Operators
UPDATE Statement
ALTER Table
LIKE Clause
BETWEEN and IN operator
CASE Statement
EXISTS
DISTINCT Clause
Count Function
Average Function
Minimum Function
Maximum Function
ORDER BY
GROUP BY
ALL and ANY Clause
TOP Clause
Union Clause
Intersection Clause
Aliases
Cartesian Join and Self Join
Inner, Left, Right and Full Joins
Division Clause
Using Clause
Combining values
MINUS Operator
Joining 3 or more tables
Advance Concepts:
Views
Creating Roles
Constraints
Transactions
Mathematical functions
Date functions
Conditional Expressions
General functions
String functions
Conversion Function
Top-N Queries
Advanced Functions
Summing Up
SQL is an very important database language, and is used by most of the companies.