SQL Notes for Professionals

Download free course SQL Notes for Professionals, pdf file on 165 pages by Stack Overflow Community.

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

Table of contents

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

Pages :	165
Size :	1.5 MB
Downloads:	151
Created:	2022-02-03
License:	CC BY-SA
Author(s):	Stack Overflow Community

Warning: Trying to access array offset on false in /home/tutovnfz/public_html/amp/article-amp.php on line 263

Download file

Others related eBooks about SQL Notes for Professionals

Learning Microsoft SQL Server

Download free course Learning Microsoft SQL Server, pdf file on 361 pages by Stack Overflow Community.

PostgreSQL Notes for Professionals

This book is the definitive guide to undocumented and partially-documented features of the PostgreSQL server. It helps you learn to apply the right solution at the right time, about avoiding risk, about making robust choices related to PostgreSQL databases. It is packed with of experience over decad

Learning SQLite

Download SQLite tutorial in PDF format, document created by StackOverFlow intended to beginners.

Microsoft SQL Server 2012

This PDF tutorial will teachs you how to use SQL Server Data Tools to develop and deploy an Analysis Services project with examples,it's a free training course under 169 pages by Microsoft.

SQL Interview Questions free PDF

Download free course SQL Interview Questions free PDF, pdf file on 17 pages by tutorialkart.com.