PostgreSQL

Adding rows to a table with identity column

INSERT statement

CHAR and VARCHAR

Notes about data types

DATEADD function

T-SQL Datetime functions

Paging records

About window functions

Recursive CTE

Common table expressions (CTE)

The number-sequence generation

Typical problems

DATEDIFF function

T-SQL Datetime functions

Float(n)

Notes about data types

PostgreSQL query plan explanation

Optimizing

What do you need to work with the textbook?

Introduction

About integer division

Notes about data types

DATEPART function

T-SQL Datetime functions

Intersect and Except

Conventional set-theoretic operations and the SELECT statement

PostgreSQL CROSSTAB

PIVOT and UNPIVOT Operators

DELETE statement

Data modification statements

Renaming the columns and calculations in the result set

SELECT statement

Exercise #10 (tips and solutions)

Tips & solutions

The sorting and NULL values

Getting summarizing values

Aggregate function to aggregate function

Getting summarizing values