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

Others sql Tutorials

A Primer on SQL, 3rd Edition

SQL Server Backup and Restore

PostgreSQL Administration

SQL Interview Questions free PDF

Protecting SQL Server Data

Others related eBooks about SQL Notes for Professionals

Graph Databases

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

Oracle database tutorials for professionals

Download free Oracle tutorial course in PDF, training file in 45 chapters and 118 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

Tutorial Oracle Database 11g: SQL Fundamentals in PDF

Download tutorial in PDF about Oracle Database 11g: SQL Fundamentals, free training document for beginners....

PostgreSQL Notes for Professionals

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

Protecting SQL Server Data

Download free course Protecting SQL Server Data, pdf file on 232 pages by John Magnabosco....

Graph Databases, 2nd Edition

Discover how graph databases can help you manage and query highly connected data. With thi..., download free Graph Databases tutorial in PDF (238 pages) created by ....

Microsoft SQL Server Notes for Professionals

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

MySQL Notes for Professionals

MySQL's popularity has brought a flood of questions about how to solve specific problems, and that's where this MySQL Notes for Professionals is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out exampl...

Download PLSQL tutorial in pdf

Download free PLSQL tutorial course in PDF, training file in 14 chapters and 47 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

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