HOUR 1 Understanding the Relational Database and SQL
HOUR 2 Exploring the Components of the SQL Language
HOUR 3 Getting to Know Your Data
HOUR 4 Setting Up Your Database
HOUR 5 Understanding the Basics of Relational (SQL) Database Design
HOUR 6 Defining Entities and Relationships
HOUR 7 Normalizing Your Database
HOUR 8 Defining Data Structures
HOUR 9 Creating and Managing Database Objects
HOUR 11 Managing Database Transactions
HOUR 12 Introduction to Database Queries
HOUR 13 Using Operators to Categorize Data
HOUR 14 Joining Tables in Queries
HOUR 15 Restructuring the Appearance of Data
HOUR 16 Understanding Dates and Times
HOUR 17 Summarizing Data Results from a Query
HOUR 18 Using Subqueries to Define Unknown Data
HOUR 19 Combining Multiple Queries into One
HOUR 20 Creating and Using Views and Synonyms
HOUR 21 Managing Database Users and Security
HOUR 22 Using Indexes to Improve Performance
HOUR 23 Improving Database Performance
HOUR 24 Working with the System Catalog
HOUR 25 Bonus Workshop for the Road
B Popular Vendor RDBMS Implementations