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: 137
Created: 2022-02-03
License: CC BY-SA
Author(s): Stack Overflow Community
SQL Notes for Professionals

Others sql Tutorials

Microsoft SQL Server ebook for professionals

Complete Guide to PostgreSQL

Tutorial PostgreSQL in pdf

SQL Server Backup and Restore

PostgreSQL Notes for Professionals

Others related eBooks about SQL Notes for Professionals

MongoDB tutorial for professionals

Download free MongoDB tutorial course in PDF, training file in 23 chapters and 73 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

Introducing Microsoft SQL Server 2016

Download free course Introducing Microsoft SQL Server 2016, pdf file on 215 pages by Stacia Varga, Denny Cherry, Joseph D'Antoni....

Microsoft Access Tutorial

Downloaf Microsoft Access Tutorial in PDF , it'a a free training document intended for beginner's to learn the basics of Microsoft Access database....

MongoDB Tutorial free PDF

Download free course MongoDB Tutorial free PDF, pdf file on 5 pages by tutorialkart.com....

Introduction to Oracle

This PDF tutorial about Oracle/SQL provides a detailed introduction to SQL (Structured query language),free training document under 64 pages for all level users....

SQL Server Internals: In-Memory OLTP

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

MySQL – Create Database free PDF

Download free course MySQL – Create Database free PDF, pdf file on 3 pages by tutorialkart.com....

SQL Server Hardware

Download free course SQL Server Hardware, pdf file on 318 pages by Glen Berry....

PostgreSQL Shell Commands free PDF

Download free course PostgreSQL Shell Commands free PDF, pdf file on 8 pages by tutorialkart.com....

Structured Query Language

Tutorial in PDF about Structured Query Language (SQL) ,free training document under 78 pages for download....