sql

LevSelector.com

New York

home > SQL

SQL

• sql tutorials
• books
• useful commands

SQL Tutorials home - top of the page -

Today SQL is the standard for getting information from and updating to a database. All serious databases support it (Oracle, Sybase, DB2, and many others). SQL queries let you select, insert, update, find out the location of data, and so forth.
Assignment - look up what is SQL (it is a special programming language) on www.whatis.com

SELECT DISTINCT you FROM ALL_PEOPLE
WHERE database_knowledge > 0

Transact SQL - extention of standard SQL supported by 3 big databases:
Sybase, DB2 ver.7, and Microsoft SQL Server
PL/SQL - Procedural Language extension to SQL supported by Oracle

SQLJ - an alternative to JDBC - a way to include SQL into java (Oracle, IBM, etc.)

Read these 2 short SQL tutorials:
• sql_tut - short SQL introduction (using Microsoft syntax)
• sql_sybase - short SQL intro (Sybase SQL server)
Solve these SQL problems:
• sql_test0 - 6 SQL problems with answers
• sql_test1 - more than 60 problems with answers (from SQL tutor software)
• www.mssqlserver.com/tsql/ - download a course: TSQL, SQL, database design, data warehousing, replication, and OLAP
• www.cosc.canterbury.ac.nz/~tanja/sql-tut.html - download SQL tutor program (FREE and good)
• nainternet.net/softwares/sql/sqlenglish.shtml - yet another SQL tutorial
• www.dcs.napier.ac.uk/~andrew/sql/ - SQL tutorial and tests
• sqlcourse.com/ - SQL tutorial
• www.arsdigita.com/books/sql/ - good course by Philip Greenspun
• cesspool.crseo.ucsb.edu:8679/tutorial.htm -
• www.google.com/search?q=tutor+SQL -
• directory.google.com/Top/Computers/Programming/Languages/SQL/ - SQL on Google

books home - top of the page -

SQL:
• Lan Times Guide to Sql • James R. Groff, Paul N. Weinberg
• The Practical Sql Handbook : Using Structured Query Language • Judith S. Bowman et al (1996)
• Joe Celko's SQL for Smarties: Advanced SQL Programming - by Joe Celko. Paperback (October 8, 1999)

some useful commands home - top of the page -

Some useful commands:

select * from ABC where 1=2

Sybase: Oracle: DB2: MySQL:

isql sqlplus db2 mysql
cat file | mysql > result

set rowcount 5
select * from ABC select * from EMP
where rownum <= 5 select * from ABC
fetch first 5 rows only select * from ABC
limit 5,10; # Retrieve rows 6-15
select * from ABC
limit 5; # retrieve first 5 rows, equivalent to: limit 0,5

use some_db
go connect user@con_string use some_db;

sp_help
sp_help some_table
sp_helpdb
sp_helptext help
select tname from tab;
select table_name from dict where table_name like '%USER%';
... show databases;
show tables;

-------------------------------------

Sybase:	Oracle:	DB2:	MySQL:
isql	sqlplus	db2	mysql cat file \| mysql > result
set rowcount 5 select * from ABC	select * from EMP where rownum <= 5	select * from ABC fetch first 5 rows only	select * from ABC limit 5,10; # Retrieve rows 6-15 select * from ABC limit 5; # retrieve first 5 rows, equivalent to: limit 0,5
use some_db go	connect user@con_string		use some_db;
sp_help sp_help some_table sp_helpdb sp_helptext	help select tname from tab; select table_name from dict where table_name like '%USER%'; ...		show databases; show tables;