SQL queries Tutorial

Download free SQL tutorial course in PDF, training file in 62 chapters and 166 pages. Free unaffiliated ebook created from Stack OverFlow contributor.

Table of contents

  • About
  • Getting started with SQL
  • Overview
  • Identi?er
  • Unquoted identi?ers
  • Data Types
  • DECIMAL and NUMERIC
  • FLOAT and REAL
  • Integers
  • MONEY and SMALLMONEY
  • BINARY and VARBINARY
  • CHAR and VARCHAR
  • NCHAR and NVARCHAR
  • UNIQUEIDENTIFIER
  • NULL
  • Filtering for NULL in queries
  • Nullable columns in tables
  • Updating ?elds to NULL
  • Inserting rows with NULL ?elds
  • Example Databases and Tables
  • Auto Shop Database
  • Library Database
  • Countries Table
  • SELECT
  • Using the wildcard character to select all columns in a query
  • SELECT Using Column Aliases
  • Select Individual Columns
  • Selecting speci?ed number of records
  • Selecting with Condition
  • Selecting with CASE
  • Select columns which are named after reserved keywords
  • Selecting with table alias
  • Selecting with more than 1 condition
  • Selecting without Locking the table
  • Selecting with Aggregate functions
  • Select with condition of multiple values from column
  • Get aggregated result for row groups
  • Selection with sorted Results
  • Selecting with null
  • Select distinct (unique values only)
  • Select rows from multiple tables
  • GROUP BY
  • Basic GROUP BY example
  • Filter GROUP BY results using a HAVING clause
  • USE GROUP BY to COUNT the number of rows for each unique entry in a given column
  • ROLAP aggregation (Data Mining)
  • Identifier
  • NULL
  • SELECT
  • ORDER BY
  • CASE
  • IN clause
  • SKIP TAKE (Pagination)
  • EXPLAIN and DESCRIBE
  • JOIN
  • CREATE Database
  • CREATE FUNCTION
  • UNION / UNION ALL
  • INSERT
  • cross apply, outer apply
  • TRUNCATE
  • DROP or DELETE Database
  • GRANT and REVOKE
  • Primary Keys
  • Row number
  • Finding Duplicates on a Column Subset with Detail
  • Functions (Aggregate)
  • Functions (Analytic)
  • Common Table Expressions
  • Materialized Views
  • Foreign Keys
  • Subqueries
  • Stored Procedures
  • Transactions
  • Synonyms
  • Order of Execution
  • SQL Injection

It is a free SQL ebook created for beginners. The content is extracted from Stack Overflow pltaform, which is written by many SQL developers and contributors.

The content is released under Creative Commons BY-SA

Size : 1.51 MB
File type : pdf
Downloads: 763
Created: 2019-04-30

Others SQL Tutorials

Learning SQLite

Essential SQL

SQL Server Metadata Succinctly

Data Science with Microsoft SQL Server 2016

MySQL Notes for Professionals

Others related eBooks about SQL queries Tutorial

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

SQL Server Metadata Succinctly

Download free course SQL Server Metadata Succinctly, pdf file on 85 pages by Joseph D. Booth....

Essential SQL

This book written to provide clear and concise explanation of topics for programmers both starting to learn the Structured Query Language (SQL) 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....

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

Protecting SQL Server Data

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

RavenDB in Action

The data you encounter in the real world is usually easier to think of as objects or docum..., download free RavenDB tutorial in PDF (221 pages) created by Itamar Syn-Hershko ....

Oracle Advanced PL/SQL Developer Professional Guide

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural ..., download free PL/SQL tutorial in PDF (440 pages) created by Saurabh K. Gupta ....

SQL Server Internals: In-Memory OLTP

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

Graph Databases

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

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