sql

Register Now

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