Books & Videos

Table of Contents

Chapter: Getting Started With Databases And SQL

Relational Databases And Key Terms Explained

08m 8s

About The Author

01m 31s

What Are The SQL Commands

02m 40s

Select Syntax And Examples

04m 58s

Where Can I Use SQL?

05m 35s

Installing Sample Databases And Working Files

04m 12s

How To Access Your Working Files

01m 15s

Chapter: Using SQL To Select And Filter Data

Using Select To View Data

04m 8s

Sorting The Data

05m 57s

Adding A Where Clause To Filter Data

05m 45s

Filtering Date Columns

04m 33s

Working With Null Or Empty Values

06m 50s

Using Comments Within SQL

06m 1s

Use Of Wildcards In Filtering

09m 14s

Multiple Criteria Using And Or In

06m 10s

Chapter: Functions, Grouping And Summarizing

Add A Calculating Column To A SQL Statement

03m 14s

Text Manipulation Functions

09m 4s

Differences In Date Functions Within SQL

07m 10s

Calculating Age

06m 24s

Concatenate Data Columns

05m 53s

Chapter: Joining Tables

Which Tables Can I Join And How?

06m 25s

Joining More Than Two Tables

04m 23s

Using Different Join Types

05m 50s

The Special Cross Or Cartesian Join

03m 43s

Group And Summaries Within Joined Table SQL

07m 3s

Chapter: Data Modification

Amend Data In Tables

08m 29s

Adding Data To Tables With Insert

09m 31s

Removing Data From Tables

08m 40s

Chapter: Creating And Altering Database Objects

Create A New Table

07m 9s

Changing A Tables Structure

04m 59s

What Is A View And How To Create One

07m 0s

Alter Or Delete A View

03m 12s

Chapter: SQL Summary

The Main Variances In SQL Between Databases

05m 38s

The Powerful Subquery

06m 59s

Chapter: Conclusions

Wrap Up

05m 14s