SQL Notes for Professionals book

SQL Notes for Professionals book

SQL Notes

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

166 pages, published on April 2018

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