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
File type :	PDF
Downloads:	122
Created:	2022-02-03
License:	CC BY-SA
Author(s):	Stack Overflow Community

Others sql Tutorials

PostgreSQL Shell Commands free PDF

Quick Guide to SQL Server Management Studio

Essential SQL

Complete Guide to PostgreSQL

PostgreSQL Administration

Others related eBooks about SQL Notes for Professionals

SQL Server Internals: In-Memory OLTP

Download free course SQL Server Internals: In-Memory OLTP, pdf file on 201 pages by Kalen Delaney....

Microsoft Access course

This PDF tutorial shows how to construct a complex application in Microsoft Access ,free training lesson under 154 pages by Soren Lauesen designated to the intermediate level-user....

Database Design, 2nd Edition

This book covers database systems and database design concepts. It provides short, easy-to-read explanations of how to get database design right the first time. It also offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. ...

Oracle Database Notes for Professionals

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

SQL in 21 days

This tutorial is for people who want to learn the fundamentals of Structured Query Language (SQL) , a complete training courses under 412 pages for download ....

Graph Databases

Download free course Graph Databases, pdf file on 238 pages by Ian Robinson, Jim Webber, Emil Eifrem....

Complete Guide to PostgreSQL

Download free PDF tutorial about PostgreSQL , a complete training material course intended for advanced level users .Document under 2810 pages by The PostgreSQL Global Development Group....

Mastering SQL Queries for SAP Business One

SAP Business One is an integrated Enterprise Resource Planning (ERP) software which offers..., download free SQL Queries tutorial in PDF (352 pages) created by Gordon Du ....

PostgreSQL for Beginners

PostgreSQL for Beginners book is intended for those who only start getting acquainted with..., download free PostgreSQL tutorial in PDF (142 pages) created by Pavel Luzanov ....

Essential MySQL

This book written to provide clear and concise explanation of topics for programmers both starting to learn the MySQL programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....