Sunday, August 26, 2007

My Right Nut Hurts Masterbatd

HackxCrack PDF Perl Manual (III): First Basic Program Manual SQL

Like with the Manual of Perl, I will start a series of articles to learn the language of SQL databases. It is a very basic manual aimed at those who do not have knowledge about it or a very basic knowledge. I appreciate any suggestions or corrections. Introduction
SQL stands for Structured Query Language , language communication standard widely used databases. Some of its features is the saving of time, flexibility and security in the maintenance of data. Most
management systems modern relational databases like MySQL , MS SQL Server, Microsoft Access, MSDE, Oracle, DB2, Sybase, Postgres and Informix use SQL as a language standard. Despite being used by major RDBMS , each of which implements specific functions which need not necessarily work in others.
This manual will explain the most common SQL commands and how to apply on the basis of known data.
defined functions defined in the standard SQL: SELECT
 




DELETE CREATE ALTER

DROP DISTINCT
GROUP BY ORDER BY

SUM

MAX MIN AVG


  • JOIN UNION
  • SubQuery
  • Concatenation
  • BETWEEN NVL
  • IN
  • Related articles:
  • Perl Manual: Introduction

0 comments:

Post a Comment