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

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

Others sql Tutorials

PostgreSQL Notes for Professionals

SQL Server Concurrency

Learning MySQL

Introducing Microsoft SQL Server 2016

SQL Server Hardware

Others related eBooks about SQL Notes for Professionals

Access 2013 Lab manual

Download free Microsoft Office Access 2013 file under 115 pages,pdf manual , course tutorial training on pdf by David Murray (University at Buffalo)....

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

SQL Interview Questions free PDF

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

How to Install SQL Server 2008

With this tutorial you will learn step by step how to install SQL Server 2008 and how to check the correct configuration of the server. Download free pdf training course in 32 page intended to beginners....

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

PostgreSQL Notes for Professionals

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

Quick Guide to SQL Server Management Studio

This PDF tutorial will teachs you how to install and use SQL Server Management Studio from Home using VPN,it's a free training courses for beginners...

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

Database Design

Download free course Database Design, pdf file on 153 pages by Adrienne Watt....

Graph Databases

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