About
SQL is a database computer language designed for the retrieval and management of data in a relational database. SQL stands for Structured Query Language. This tutorial will give you a quick start to SQL. It covers most of the topics required for a basic understanding of SQL and to get a feel of how it works.
Audience
This tutorial is prepared for beginners to help them understand the basic as well as the advanced concepts related to SQL languages. This tutorial will give you enough understanding on the various components of SQL along with suitable examples.
Prerequisites
Before you start practicing with various types of examples given in this tutorial, I am assuming that you are already aware about what a database is, especially the RDBMS and what is a computer programming language.
Lesson 1: sql – overview
Lesson 2: sql – rdbms concepts
Lesson 3: sql – rdbms databases
Lesson 4: sql – syntax
Lesson 5: sql – data types
Lesson 6: sql – operators
Lesson 7: sql – expressions
Lesson 8: sql – create database
Lesson 9: sql – drop or delete database
Lesson 10: sql – select database, use statement
Lesson 11: sql – create table
Lesson 12: sql – drop or delete table
Lesson 13: sql – insert query
Lesson 14: sql – select query
Lesson 15: sql – where clause
Lesson 16: sql – and and or conjunctive operators
Lesson 17: sql – update query
Lesson 18: sql – delete query
Lesson 19: sql – like clause
Lesson 20: sql – top, limit or rownum clause
Lesson 21: sql – order by clause
Lesson 22: sql – group by
Lesson 23: sql – distinct keyword
Lesson 24: sql – sorting results
Lesson 25: sql – constraints
Lesson 26: sql – using joins
Lesson 27: sql – unions clause
Lesson 28: sql – null values
Lesson 29: sql – alias syntax
Lesson 30: sql – indexes
Lesson 33: sql – alter table command
Lesson 34: sql – truncate table command
Lesson 35: sql – using views
Lesson 36: sql – having clause
Lesson 37: sql – transactions
Lesson 38: sql – wildcard operators
Lesson 39: sql – date functions
Lesson 40: sql – temporary tables
Lesson 41: sql – clone tables
Lesson 42:sql – sub queries
Lesson 43: sql – using sequences
Lesson 44: sql – handling duplicates
Lesson 45: sql – injection
Lesson 46:sql – database tunning
Lesson 47: sql – questions and answers
Lesson 48: sql – useful functions
Lesson 49: sql – useful resources