Books & Videos

Table of Contents

Chapter: Introduction

Welcome To The Course

04m 40s

About The Author

02m 4s

How To Access Your Working Files

01m 15s

Chapter: Creating A Database

What Is A Relational Database?

08m 13s

What Is MySQL?

06m 56s

Installing A Local Implementation Of MySQL

06m 9s

Creating And Removing Tables

08m 17s

Data Types

05m 32s

What Is A Primary Key?

05m 28s

Creating Indexes

06m 8s

Modifying Table Structures

03m 22s

Adding Data To A Table

03m 4s

Changing Data In A Table

05m 47s

Removing Data From A Table

03m 24s

Chapter: Querying Data From A Database

Retrieving Data From A Table

02m 50s

Restricting Rows With The Where Clause

03m 17s

Using Mathematical And Text Expressions

04m 44s

Sorting Results

04m 27s

Comparison Operators

02m 40s

Logical Operators

06m 30s

Dealing With Null Values

02m 43s

What Is A Foreign Key?

03m 55s

Joins With The Using Clause

05m 32s

Joins With The On Clause

03m 51s

Chapter: Using Functions And Summarizing Data

Aggregate Functions

07m 29s

Single Row Functions

09m 13s

Using The Group By Clause

03m 53s

Using The Having Clause

02m 24s

Chapter: Advanced Database Queries

Many To Many Relationships

07m 36s

Join Multiple Tables With The Using Clause

05m 51s

Join Multiple Tables With The On Clause

03m 10s

Eliminating Duplicate Rows From The Results

03m 57s

Using The Like Operator For Pattern Matching

04m 33s

Using The In Operator

02m 7s

How Subqueries Work

04m 55s

Subqueries With The In Operator

05m 27s

Creating And Using Views

07m 44s

Combining SQL Results

03m 55s

Chapter: Conclusion

Legacy SQL Techniques

06m 37s

Wrap Up And Thank You

03m 31s