DenkzeitWiki

Main /

Structured Query Language

BeingDBA
DBMS
MicrosoftSQLServer

TSQL

ACID

DynamicSQL
DatabaseGlossary

SQLInjection Structured Query Language
from IBM's SEQUEL (Structured English QUEry Language)

I think the use of "Sequel" actually got officially deprecated at the first standardisation conference....[1]

SQL is the new HTML. HalVarian

• Wikipedia:SQL
  • Wikipedia:SQL-92
    • Database Language SQL -- spezification
• Wiki:StructuredQueryLanguage
  
  
• http://troels.arvin.dk/db/rdbms/ --Comparison of different SQL implementations
  
  
• Languages, SQL is a Data Query Language (DQL)
  • Data Definition (DDL)
    • create
    • drop
    • alter
  • Data Manipulation (DML) -> verbs
    • insert
    • update
    • delete
    • DQL
  • Data Control (DCL) (authorization)
    • grant
    • revoke
  • Data Retrieval
    • select
  • Data Transaction
    • begin_work
    • commit
    • rollback

more Text

• Wiki:DatabaseBestPractices
• Wiki:UsingSql
• http://sqljunkies.com/
• http://tinyurl.com/cd7ky --SQL Criticism

Tutorials

• http://www.eveandersson.com/arsdigita/books/sql/ --SQL for Web Nerds by PhilipGreenspun
• http://sqlzoo.net/ --A Gentle Introduction to SQL interactive
• http://www.sql-tutorial.net/
• https://www.microsoftelearning.com/sqlserver2005/ --SQL Server 2005 with Free* Microsoft E-Learning Courses
• http://www.faqs.org/docs/ppbook/c1164.htm --Understanding SQL

Quick Reference

• SQL Language Quick Reference
• SQL Quick Reference

Optimization

• http://www.codeproject.com/cs/database/sql-tuning-tutorial-1.asp --SQL Tuning Tutorial - Understanding a Database Execution Plan (1)
• http://www.sql-server-performance.com/tips_performance.asp
  
• http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96533/sql_1016.htm --Optimizing SQL Statements (Oracle)

books

• SQL: Practical Guide for Developers by MichaelDonahoo?, GregorySpeegle?
• SQL in a Nutshell by KevinKline?, DanielKline?, BrandHunt?
• Joe Celko's SQL for Smarties: Advanced SQL Programming by JoeCelko