SQL Notes for Professionals book

SQL Book preview
SQL Notes for Professionals book

If you found this SQL book useful,
then please share it ❤

Chapters

  1. Getting started with SQL
  2. Identifier
  3. Data Types
  4. NULL
  5. Example Databases and Tables
  6. SELECT
  7. GROUP BY
  8. ORDER BY
  9. AND & OR Operators
  10. CASE
  11. LIKE operator
  12. IN clause
  13. Filter results using WHERE and HAVING
  14. SKIP TAKE (Pagination)
  15. EXCEPT
  16. EXPLAIN and DESCRIBE
  17. EXISTS CLAUSE
  18. JOIN
  19. UPDATE
  20. CREATE Database
  21. CREATE TABLE
  22. CREATE FUNCTION
  23. TRY/CATCH
  24. UNION / UNION ALL
  25. ALTER TABLE
  26. INSERT
  27. MERGE
  28. cross apply, outer apply
  29. DELETE
  30. TRUNCATE
  31. DROP Table
  32. DROP or DELETE Database
  33. Cascading Delete
  34. GRANT and REVOKE
  35. XML
  36. Primary Keys
  37. Indexes
  38. Row number
  39. SQL Group By vs Distinct
  40. Finding Duplicates on a Column Subset with Detail
  41. String Functions
  42. Functions (Aggregate)
  43. Functions (Scalar/Single Row)
  44. Functions (Analytic)
  45. Window Functions
  46. Common Table Expressions
  47. Views
  48. Materialized Views
  49. Comments
  50. Foreign Keys
  51. Sequence
  52. Subqueries
  53. Execution blocks
  54. Stored Procedures
  55. Triggers
  56. Transactions
  57. Table Design
  58. Synonyms
  59. Information Schema
  60. Order of Execution
  61. Clean Code in SQL
  62. SQL Injection

Example book pages

SQL Example Page 1SQL Example Page 2

SQL Example Page 3SQL Example Page 4

What people are saying about Notes for Professionals books

The SQL Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified

Book created for educational purposes and is not affiliated with SQL group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners

164 pages, published on February 2018

View More Programming Books

To support continued development and improvements to this book, please consider a small bitcoin donation: 1H63m55bw6KDYUaKU1mYLGrzDf4wcrVzhX