Flip PDF Professionalhttp://www.flipbuilder.com
Click to view in fullscreen.

Table of Contents

  • About

  • Chapter 1: Getting started with SQL

  • Chapter 2: ALTER TABLE

  • Chapter 3: AND & OR Operators

  • Chapter 4: Cascading Delete

  • Chapter 5: CASE

  • Sample data

  • Query

  • Results

  • Explanation

  • Chapter 6: Clean Code in SQL

  • Table/Column Names

  • Keywords

  • Chapter 7: Comments

  • Chapter 8: Common Table Expressions

  • Chapter 9: CREATE Database

  • Chapter 10: CREATE FUNCTION

  • Chapter 11: CREATE TABLE

  • PostgreSQL and SQLite

  • SQL Server

  • Chapter 12: cross apply, outer apply

  • Chapter 13: Data Types

  • Chapter 14: DELETE

  • Chapter 15: DROP or DELETE Database

  • Chapter 16: DROP Table

  • Chapter 17: Example Databases and Tables

  • Chapter 18: EXCEPT

  • Chapter 19: Execution blocks

  • Chapter 20: EXISTS CLAUSE

  • Get all customers with a least one order

  • Get all customers with no order

  • Purpose

  • Chapter 21: EXPLAIN and DESCRIBE

  • Chapter 22: Filter results using WHERE and HAVING

  • Chapter 23: Finding Duplicates on a Column Subset with Detail

  • Chapter 24: Foreign Keys

  • A few tips for using Foreign Keys

  • Chapter 25: Functions (Aggregate)

  • MySQL

  • Oracle & DB2

  • PostgreSQL

  • SQL Server

  • SQLite

  • Chapter 26: Functions (Analytic)

  • Chapter 27: Functions (Scalar/Single Row)

  • Chapter 28: GRANT and REVOKE

  • Chapter 29: GROUP BY

  • Chapter 30: Identifier

  • Chapter 31: IN clause

  • Chapter 32: Indexes

  • Chapter 33: Information Schema

  • Chapter 34: INSERT

  • Chapter 35: JOIN

  • So how does this work?

  • So how does this work?

  • Inner Join

  • Left outer join

  • Right outer join

  • Full outer join

  • Inner Join

  • Left Outer Join

  • Right Outer Join

  • Full Outer Join

  • Left Semi Join

  • Right Semi Join

  • Left Anti Semi Join

  • Right Anti Semi Join

  • Cross Join

  • Self-Join

  • Chapter 36: LIKE operator

  • Chapter 37: Materialized Views

  • Chapter 38: MERGE

  • Chapter 39: NULL

  • Chapter 40: ORDER BY

  • Chapter 41: Order of Execution

  • Chapter 42: Primary Keys

  • Chapter 43: Relational Algebra

  • SELECT

  • PROJECT

  • GIVING

  • NATURAL JOIN

  • ALIAS

  • DIVIDE

  • UNION

  • INTERSECTION

  • DIFFERENCE

  • UPDATE ( := )

  • TIMES

  • Chapter 44: Row number

  • Chapter 45: SELECT

  • Average

  • Minimum

  • Maximum

  • Count

  • Sum

  • Chapter 46: Sequence

  • Chapter 47: SKIP TAKE (Pagination)

  • Chapter 48: SQL CURSOR

  • Chapter 49: SQL Group By vs Distinct

  • Chapter 50: SQL Injection

  • Chapter 51: Stored Procedures

  • Chapter 52: String Functions

  • Chapter 53: Subqueries

  • Chapter 54: Synonyms

  • Chapter 55: Table Design

  • Chapter 56: Transactions

Search