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

*La edición digital no incluye códigos de acceso a material adicional o programas mencionados en el libro.