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