Structured Query Language

by Wikibooks contributors

Read here Read at Wikibooks

A book Wikibooks counts as complete, from its open-content textbook collection.

Description from Wikibooks.

Publisher
Wikibooks contributors
Subjects
SQL
Licence
CC BY-SA 4.0, as Wikibooks states it
Who can read
Tweens profiles and older, judged from its title and subjects

Contents

  1. Structured Query Language
  2. printable version
  3. About the Book
  4. Database Management Systems (DBMS)
  5. Relational DBMS (rDBMS)
  6. SQL: A Language for Working with rDBMS
  7. SQL: The Standard ISO IEC 9075 and various Implementations
  8. Language Elements
  9. Learning by Doing
  10. SELECT code FROM examples WHERE topic = ...
  11. Create a simple Table
  12. Handle Data
  13. Example Database Structure
  14. Example Database Data
  15. SELECT Fundamentals
  16. Join Operation
  17. Grouping
  18. IS NULL Predicate
  19. Predefined Functions
  20. Set Operations
  21. Case Expression
  22. Subquery
  23. Views
  24. INSERT
  25. INSERT, using Subqueries
  26. UPDATE
  27. UPDATE, using Subqueries
  28. DELETE
  29. DELETE, using Subqueries
  30. MERGE
  31. TRUNCATE
  32. COMMIT and ROLLBACK
  33. CREATE TABLE
  34. Data Types
  35. Foreign Key
  36. Alter Table
  37. Drop Table
  38. Temporary Table
  39. Indexes
  40. Managing Rights (GRANT / REVOKE)
  41. Pattern Matching (LIKE Predicate and much more)
  42. IN, SOME/ANY, ALL, EXISTS
  43. Advanced Grouping: Rollup / Cube
  44. Window functions (Data Warehouses, OLAP)
  45. With Clause (Common Table Expression CTE)
  46. Recursions
  47. NULLs and the Three Valued Logic
  48. Transactions / Isolation Levels
  49. Retrieve Top N Rows per Group
  50. Eliminate Duplicates
  51. Warnings and Exceptions (SQLSTATE)
  52. Glossary