Introduction:
In this tutorial, we are going to understand basics of SQL, importance, types of sql commands and tools.
Covered Topic:
History, Importance,Types of SQL Commands, Popular RDBMS, Creating Databases and Tables, INSERT, SELECT, UPDATE, DELETE,Basic WHERE Clause and Conditions, DISTINCT, LIMIT, BETWEEN, IN, LIKE
SQL Functions:
Aggregate Functions (COUNT, SUM, AVG, MIN, MAX),String Functions (CONCAT, LENGTH, SUBSTR, TRIM), Date Functions (NOW, DATE_ADD, DATEDIFF), Conversion Functions (CAST, CONVERT)
SQL Clauses:
ORDER BY, GROUP BY and HAVING, ALIAS, LIMIT and OFFSET.
Set Operations:
INNER JOIN, LEFT JOIN
RIGHT JOIN, FULL OUTER JOIN, SELF JOIN, CROSS JOIN,
UNION and UNION ALL
Subqueries and Nested Queries
Subqueries with SELECT, WHERE, FROM,
Correlated Subqueries,
EXISTS and NOT EXISTS
SQL Set Operations:
UNION, INTERSECT, MINUS, Usage Examples and Differences.
Views and Indexes:
Creating and Dropping Views, Simple and Complex Views, Clustered and Non-clustered Indexes.
Data Constraints:
NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT ON DELETE and ON UPDATE Actions
Advanced SQL:
Stored Procedures and Functions, Triggers and Events, Transactions and ACID Properties,
Locks and Isolation Levels
Performance Optimization:
Query Optimization Techniques,
Execution Plan Analysis,
Indexing Strategies
