• Books
• Code
• Design
• Guides
• Hosting
• Lists
• Marketing
• Security
• Software

• Forum
• Contact us
• Links
• Site map

Home / code / sql

SQL,Structured Query Language

Structured Query Language is a language that is used to communicated with databases. Both ASP and CGI use it.
The actual management of the data is done by Relational DataBase Management System(RDBMS). With SQL we give orders to RDBMS.
There are 3 categories of SQL instructions: Data Manipulation Language (DML), Data Definition Language (DDL) and Data Control Language (DCL).

DML is used to select, add, change and delete contents of the database

DDL creates and manage databases, tables, views and indexes.

DCL is used to secure the database. Everyone may read, but only some persons can change the data.

• Select data
  • Aggregate functions
  • Calculations
  • Select data from more then 1 table
  • Insert into a new table
  • Union
  • Subqueries
• Add/Change/delete data
• Management of tables and relations
• Users
• Views

 

TOP

Latest script:

• No scripts yet



• More

Books:

• SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL
• MySQL High Availability: Tools for Building Robust Data Centers
• SQL Antipatterns: Avoiding the Pitfalls of Database Programming
• MySQL (4th Edition)
• Head First SQL: Your Brain on SQL -- A Learner's Guide



• More