Structured Query Language (SQL) is the set of statements with which all programs and users access data in a database. SQL is the standard query language to fetch, modify, update & process the data in Relational Database Management System. Relational Database Management System A relational database is a database that is treated as a set of tables and manipulated in accordance with the relational model of data. It contains a set of objects used to store, manage, and access data. Examples of such objects are tables, views, indexes, functions, triggers, and packages. And the software used for Relational Database is known as Relational Database Management System.
Table of Contents
1 History of SQL
2 SQL Components: An Overview
3 Data Types in SQL
4 Planning a Database: An Example: -
5 Creating Tables
6 Inserting Data using Insert
7 Getting Data with Select Statement
8 Working with Operators
9 Selecting Unique rows with Distinct
10 Arraging Data with Order by
11 Working with Strings
12 SQL AND
13 Basic SQL Funtion
14 Sub-Queries, Nested Queries
15 Constraints in the Table
16 SQL UPDATE
17 View
18 Relationships in a RDBMS
19 Structure Modification,Updation and Deletion
