SQL Notes for Professionals

by Stack Overflow Community

DescriptionTable of ContentsDetailsHashtagsReport an issue

Book Description

The SQL Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow.

This open book is licensed under a Creative Commons License (CC BY-SA). You can download SQL Notes for Professionals ebook for free in PDF format (1.5 MB).

Table of Contents

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

Book Details

Subject
Computer Science
Publisher
GoalKicker
Published
2018
Pages
165
Edition
1
Language
English
PDF Size
1.5 MB
License
CC BY-SA

Related Books

Microsoft SQL Server Notes for Professionals
The Microsoft SQL Server Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
Entity Framework Notes for Professionals
The Entity Framework Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
C# Notes for Professionals
The C# Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
Excel VBA Notes for Professionals
The Excel VBA Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
MySQL Notes for Professionals
The MySQL Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
R Notes for Professionals
The R Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....