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: 765
Created: 2019-04-30

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

Others SQL Tutorials

SQL in 21 days

SQL Server Backup and Restore

SQL injection: attacks and defenses

MySQL tutorial for professionals

Guide to NoSQL with Azure Cosmos DB

Others related eBooks about SQL queries Tutorial

SQL Server Backup and Restore

Download tutorial about SQL Server Backup and Restore, it's a free PDF version in 381 pages proposed by Red Gate....

Migrating SQL Server Databases to Azure

Download free course Migrating SQL Server Databases to Azure, pdf file on 174 pages by Carl Rabeler....

Tutorial Oracle Database 11g: SQL Fundamentals in PDF

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

SQL Server Hardware

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

Data Science with Microsoft SQL Server 2016

Download free course Data Science with Microsoft SQL Server 2016, pdf file on 90 pages by Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, Wee-Hyong Tok....

Learning access-vba PDF course

Download free Access vba tutorial course in PDF, training file in 5 chapters and 207 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

Microsoft Access 2013 course

Download free Microsoft Office Access 2013 file under 448 pages,step by step to learn Access and build your skills , course tutorial training on pdf by Joyce Cox and Joan Lambert....

MongoDB Tutorial free PDF

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

Oracle Database Notes for Professionals

Download free course Oracle Database Notes for Professionals, pdf file on 117 pages by Stack Overflow Community....

Introduction to SQL Server 2008

This pdf course is designed to teach you Microsoft SQL Server. This is a practical training to learn the basics of the Microsoft Database Management System, in its 2008 version....