Books & Videos

Table of Contents

Chapter: Rational Databases

What are Databases?

07m 24s

What's the Role of Databases in Application Programming?

07m 57s

Tables and Relations

14m 40s

Primary and Foreign Keys and Other Constraints

12m 0s

Chapter: SQL Querying

What is Querying?

02m 40s

The ANSI SQL Standard

03m 59s

DML, DDL and More

05m 7s

Common Query Tools

08m 27s

Chapter: Your First Queries

The SELECT Statement

06m 17s

Limiting Output Columns

04m 57s

Formatting and Sorting Output

15m 22s

Column Aliases

06m 19s

Chapter: Filtering Your Results

The WHERE Clause

04m 57s

Creating a Filter Condition

07m 19s

Applying Multiple Filter Conditions

08m 13s

More Filter Options

11m 21s

Chapter: Consolidating Your Data

Counting Records

05m 14s

Common Aggregate Functions: SUM, AVG, MIN, MAX

08m 6s

Do's and Don'ts When Consolidating

08m 38s

Unions and Other Multiset Consolidations

10m 57s

Chapter: Grouping Your Data

The GROUP BY Clause

09m 59s

The HAVING Clause

05m 36s

Do's and Don'ts When Grouping

06m 9s

Chapter: Joining Tables

Table Aliases

06m 54s

Inner Joins

14m 58s

Outer Joins

14m 8s

Self Joins

08m 0s

Complex Multi Table Joins

19m 57s

Chapter: Subqueries

Filtering Using Subqueries

14m 9s

The EXISTS Clause

06m 49s

Subqueries as Alternative to Joins

07m 9s

Derived Tables

05m 40s

Chapter: Manipulating Your Data

The INSERT Statement

20m 46s

The UPDATE Statement

12m 50s

The DELETE Statement

06m 26s

Chapter: Transaction Control

What are Transactions?

05m 24s

Initiating a Transaction

04m 17s

The COMMIT and ROLLBACK Commands

04m 22s

Chapter: Creating Database Objects and Adding Business Logic

Creating Tables

16m 39s

Creating and Using Views

09m 15s

Developing and Calling Stored Procedures

10m 41s

Implementing Triggers

09m 25s