SQL Tutorial
SQL stands for Structured Query Language.
SQL is a standard programming language designed for storing, retrieving, managing, and manipulating data in a relational database management system (RDBMS).
SQL is the most widely implemented language and is supported by the popular relational database systems, like MySQL, SQL Server, Oracle, IBM DB2, MS Access, Sybase, Informix, Postgres, etc.,
However, some of the SQL features are implemented differently in different database systems.
History of SQL
SQL was originally developed in the early 1970s at IBM, which was initially called SEQUEL (stands for Structured English Query Language).
Later, it was changed to SQL (pronounced as S-Q-L), which stands for Structured Query Language.
In this tutorial, we will go through everything you need to know about SQL, from basics to advanced concepts.
Here is the list of topics we are going to explore with examples in this tutorial.
SQL Basics
SQL Introduction helps us understand what it is, why we need it, how to use it, etc.,
- SQL Introduction
- SQL Getting Started
- SQL Syntax
- SQL Create Database
- SQL Hello World
- SQL Create Table
- SQL Constraints
- SQL INSERT Statement
- SQL SELECT Statement
- SQL DISTINCT Clause
- SQL WHERE Clause
- SQL Comments
- SQL AND & OR Operators
- SQL IN & BETWEEN Operators
- SQL LIKE Operator
- SQL NULL Operators
- SQL ORDER BY Clause
- SQL TOP Clause
- SQL LIMIT Clause
- SQL UPDATE Statement
- SQL DELETE Statement
- SQL TRUNCATE TABLE Statement
- SQL DROP Statement
- SQL ALTER TABLE Statement
- SQL CASE Statement
- SQL Aliases
- SQL Aggregate Functions
- SQL GROUP BY Clause
- SQL HAVING Clause
SQL Joins
SQL Advanced
- SQL UNION Operator
- SQL SubQueries
- SQL EXISTS Operator
- SQL ANY & ALL Operators
- SQL SELECT INTO Statement
- SQL INSERT INTO SELECT Statement
- SQL Create View
- SQL Create Index
- SQL Dates and Times
- SQL Cloning Tables
- SQL Temporary Tables
- SQL Injection
SQL References
- SQL Keywords
- SQL Functions
- SQL Data Types
- SQL Statements
- SQL Clauses
- SQL Operators
SQL Others
- SQL Examples
- SQL Questions
Overall
We promise that you will go through an extensive list of topics to understand both basic and advanced concepts of SQL.
The topics covered in this tutorial will make you confident enough to easily crack a job interview or develop an application that interacts with databases.
We hope you will enjoy this tutorial.
Learning is always fun and we should never stop learning.
Happy Learning!!