SQL Notes for Professionals

by GoalKicker

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....