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

Size1.51 MB
File typepdf
Downloads776
Created2019-04-30
Cover of SQL queries Tutorial
Preview PDF

Download

  • Database Design, 2nd Edition

    This book covers database systems and database design concepts. It provides short, easy-to-read explanations of how to get database design right the first time. It also offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. ...

  • MySQL Notes for Professionals

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

  • Complete Guide to PostgreSQL

    Download free PDF tutorial about PostgreSQL , a complete training material course intended for advanced level users .Document under 2810 pages by The PostgreSQL Global Development Group....

  • Protecting SQL Server Data

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

  • Getting started with Oracle 8

    This pdf tutorial is about fundamental of relational database with Oracle , a free training document for Beginners....

  • Learning Microsoft SQL Server

    Download free course Learning Microsoft SQL Server, pdf file on 361 pages by Stack Overflow Community....

  • Microsoft Access course

    This PDF tutorial shows how to construct a complex application in Microsoft Access ,free training lesson under 154 pages by Soren Lauesen designated to the intermediate level-user....

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

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

  • SQL Server Metadata Succinctly

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