Home » Database » SQL queries Tutorial

SQL queries Tutorial

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

Paperback :
eBook : 1.51 MB
Downloads: 311
Submitted On: 2019-04-30
License:
Author(s):

Take advantage of this course called SQL queries Tutorial to improve your Database skills and better understand SQL.

This course is adapted to your level as well as all SQL pdf courses to better enrich your knowledge.

All you need to do is download the training document, open it and start learning SQL for free.

This tutorial has been prepared for the beginners to help them understand basic SQL Database. After completing this tutorial you will find yourself at a moderate level of expertise in SQL from where you can take yourself to next levels.

This tutorial is designed for SQL students who are completely unaware of SQL concepts but they have basic understanding on Database training.

Preview Download

Tutorials in the same categorie :