SQL Tutorials

Introduction History Overview SQL IDE SQL standard Types of SQL

Database Basics

Database DBMS vs RDBMS Popular Database

DDL

Create Alter Drop Truncate Rename Constraints

DML

Select Insert Update Delete Merge

SQL Queries

Columns and rows Where Order by Distinct Column aliases

Advance filtering

Like Logical Operator Between Null

Functions

Aggregate String Date and Time Mathematical Conversion

Grouping Data

Group by Having Aggregating

Joins

Inner join Left join Right join Full outer join Cross join Self join Union

Subqueries

Single row Multi row Correlated Exists In and Not In

Views

Creating views Updating views Dropping views Limitations

Indexing

Types of indexes Managing indexes Strategies Advantages

Stored Procedures

Creating stored User define Differences Input and Output Error handling

Triggers

Triggers Types of triggers Managing triggers Limitations

Concurrency Control

TCL ACID properties Isolation Locking

Database Security

User management DCL Permissions Scurity

Performance Optimization

Query Explain Index Partitioning Caching

Database Design

Principles Nomalization Denormalization Relationships

Advanced SQL

CTE Window functions JSON data XML data Pivoting

Data Analysis

Data extraction Statistical Aggregation Data visualization

NoSQL and New SQL

Overview NoSQL SQL and NoSQL New SQL