sql9 - SQL Handout Douglas Shook 03/01/05 (1) 5/13/2009...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: SQL Handout Douglas Shook 03/01/05 (1) 5/13/2009 6:22 a5/p5 TABLE OF CONTENTS 1. REQUISITE FEATURES OF A COMPREHENSIVE RELATIONAL LANGUAGE ................................................. 3 2. DATA DEFINITION LANGUAGE (DDL) - BASIC DDL STATEMENTS ................................................................. 3 3. DATA DEFINITION LANGUAGE (DDL) - BASIC TABLE DEFINITIONS .............................................................. 3 4. DATA DEFINITION LANGUAGE (DDL) - CURRENT DATA TYPES ....................................................................... 4 5. DATA DEFINITION LANGUAGE (DDL) - COLUMN CONSTRAINTS ............................................................. 4 6. DATA DEFINITION LANGUAGE (DDL) - TABLE CONSTRAINTS ................................................................ 5 7. DATA DEFINITION LANGUAGE (DDL) - ADDING COLS AND CONSTRAINTS .............................................. 6 8. DATA DEFINITION LANGUAGE (DDL) – CUSTOMER ORDER ERD FOR TABLES .............................................. 7 9. DATA DEFINITION LANGUAGE (DDL) - TABLES WITH CONSTRAINTS .......................................................... 8 10. DATA DEFINITION LANGUAGE (DDL) - Enforcing Cardinality and Business Rules .............................................. 9 12. DATA MANIPULATION LANGUAGE (DML) - QUERY FORMAT ........................................................... 12 13. DATA MANIPULATION LANGUAGE (DML) - SINGLE TABLE QUERIES ..................................................... 14 14. DATA MANIPULATION LANGUAGE (DML) - IMPLICIT JOINS ............................................................... 14 15. DATA MANIPULATION LANGUAGE (DML) - NESTED JOINS ............................................................. 15 16. DATA MANIPULATION LANGUAGE (DML) - UNION AND OUTER JOIN ..................................................... 16 17. DATA MANIPULATION LANGUAGE (DML) - MINUS AND INTERSECT ...................................................... 17 18. DATA DEFINITION LANGUAGE (DDL) - VIEW DEFINITION .................................................................... 17 19. DATA DEFINITION LANGUAGE (DDL) - INDEXING .......................................................................... 18 20. DATA DEFINITION LANGUAGE (DDL) - CLUSTERING ...................................................................... 18 21. DATA MANIPULATION LANGUAGE (DML) – CHARACTER FUNCTIONS ................................................... 19 22. DATA MANIPULATION (DML) – GROUP VALUE NUMBER FUNCTIONS .......................................................... 19 23. DATA MANIPULATION LANGUAGE (DML) – WORKING WITH NULLS ...................................................... 19 24. DATA CONTROL LANGUAGE (DCL) - SECURITY CONTROL .................................................................. 19 25. SESSION CONTROL COMMANDS ................................................................................. 20 26. COMPARISON OPERATORS IN SQL ....................................................................................
View Full Document

This note was uploaded on 03/05/2008 for the course IOM 435 taught by Professor Shook during the Spring '05 term at USC.

Page1 / 33

sql9 - SQL Handout Douglas Shook 03/01/05 (1) 5/13/2009...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online