SQL Notes for Professionals book

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
  1. TRY/CATCH
  2. UNION / UNION ALL
  3. ALTER TABLE
  4. INSERT
  5. MERGE
  6. cross apply, outer apply
  7. DELETE
  8. TRUNCATE
  9. DROP Table
  10. DROP or DELETE Database
  11. Cascading Delete
  12. GRANT and REVOKE
  13. XML
  14. Primary Keys
  15. Indexes
  16. Row number
  17. SQL Group By vs Distinct
  18. Finding Duplicates on a Column Subset with Detail
  19. String Functions
  20. Functions (Aggregate)
  1. Functions (Scalar/Single Row)
  2. Functions (Analytic)
  3. Window Functions
  4. Common Table Expressions
  5. Views
  6. Materialized Views
  7. Comments
  8. Foreign Keys
  9. Sequence
  10. Subqueries
  11. Execution blocks
  12. Stored Procedures
  13. Triggers
  14. Transactions
  15. Table Design
  16. Synonyms
  17. Information Schema
  18. Order of Execution
  19. Clean Code in SQL
  20. SQL Injection

Credits
Thank you greatly to all the people from Stack Overflow Documentation who helped provide this content, more changes can be sent to web@petercv.com for new content to be published or updated. (See page 156 to watch all creedit over PDF file, please).


Source: goalkicker.com/SQLBook

Click to rate this post
[Total: 0 Average: 0]

Liked this post? Follow this blog to get more.