Dublin Core
Title
SQL Notes for Professionals book
Subject
SQL Notes
Description
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
166 pages, published on April 2018
Text Item Type Metadata
Text
Chapters
- Getting started with SQL
- Identifier
- Data Types
- NULL
- Example Databases and Tables
- SELECT
- GROUP BY
- ORDER BY
- AND & OR Operators
- CASE
- LIKE operator
- IN clause
- Filter results using WHERE and HAVING
- SKIP TAKE (Pagination)
- EXCEPT
- EXPLAIN and DESCRIBE
- EXISTS CLAUSE
- JOIN
- UPDATE
- CREATE Database
- CREATE TABLE
- CREATE FUNCTION
- TRY/CATCH
- UNION / UNION ALL
- ALTER TABLE
- INSERT
- MERGE
- cross apply, outer apply
- DELETE
- TRUNCATE
- DROP Table
- DROP or DELETE Database
- Cascading Delete
- GRANT and REVOKE
- XML
- Primary Keys
- Indexes
- Row number
- SQL Group By vs Distinct
- Finding Duplicates on a Column Subset with Detail
- String Functions
- Functions (Aggregate)
- Functions (Scalar/Single Row)
- Functions (Analytic)
- Window Functions
- Common Table Expressions
- Views
- Materialized Views
- Comments
- Foreign Keys
- Sequence
- Subqueries
- Execution blocks
- Stored Procedures
- Triggers
- Transactions
- Table Design
- Synonyms
- Information Schema
- Order of Execution
- Clean Code in SQL
- SQL Injection
Document Viewer
Embed
Copy the code below into your web page
Social Bookmarking
Added by Vassilis Perantzakis
Comments