HOUR 1: Understanding the Relational Database and SQL
Thriving in a Data-Driven World
Understanding the Relational Database
The Relational Database Continues to Lead the Way
HOUR 2: Exploring the Components of the SQL Language
HOUR 3: Getting to Know Your Data
The BIRD Database: Examples and Exercises in This Book
HOUR 4: Setting Up Your Database
Getting Set Up for Hands-on Exercises
HOUR 5: Understanding the Basics of Relational (SQL) Database Design
Understanding What Database Design Has to Do with SQL
Choosing a Database Design Methodology
Using a Simple Process to Think Through the Design of the BIRDS Database
Logical Model vs. Physical Design
HOUR 6: Defining Entities and Relationships
Creating a Data Model Based on Your Data
Employing Referential Integrity
Creating an Entity Relationship
HOUR 7: Normalizing Your Database
Exploring the Most Common Normal Forms of the Normalization Process
Applying Normalization to Your Database
HOUR 8: Defining Data Structures
Understanding Basic Data Types
Using Data Types in the BIRDS Database
HOUR 9: Creating and Managing Database Objects
Tables: The Primary Storage for Data
Getting an Overview of Data Manipulation
Populating Tables with New Data
HOUR 11: Managing Database Transactions
Dealing with Poor Transactional Control
HOUR 12: Introduction to Database Queries
HOUR 13: Using Operators to Categorize Data
HOUR 14: Joining Tables in Queries
Selecting Data from Multiple Tables
HOUR 15: Restructuring the Appearance of Data
Miscellaneous Character Functions
HOUR 16: Understanding Dates and Times
Understanding How a Date Is Stored
HOUR 17: Summarizing Data Results from a Query
Understanding the Difference Between GROUP BY and ORDER BY
Using CUBE and ROLLUP Expressions
HOUR 18: Using Subqueries to Define Unknown Data
HOUR 19: Combining Multiple Queries into One
Differentiating Single Queries and Compound Queries
Using Compound Query Operators
Using ORDER BY with a Compound Query
Using GROUP BY with a Compound Query
HOUR 20: Creating and Using Views and Synonyms
Understanding the Performance Impact of Nested Views
HOUR 21: Managing Database Users and Security
Managing Users in the Database
Understanding the Management Process
Maximizing Tools Utilized by Database Users
Understanding Database Security
Controlling Privileges Through Roles
HOUR 22: Using Indexes to Improve Performance
Understanding How Indexes Work
Using the CREATE INDEX Command
Knowing When to Consider Using an Index
HOUR 23: Improving Database Performance
Comparing Database Tuning and SQL Statement Tuning
Identifying Other Performance Considerations
HOUR 24: Working with the System Catalog
Determining What Is Contained in the System Catalog
Identifying System Catalog Tables by Implementation
Updating System Catalog Objects
HOUR 25: Bonus Workshop for the Road
Workshop: Describing Your Tables
Workshop: Comparison Operators
Workshop: Conjunctive Operators
Workshop: Arithmetic Operators
Workshop: Creating Tables from Existing Tables
Workshop: Inserting Data into a Table from Another Table
Workshop: Embedding Subqueries
Workshop: Creating Views from Subqueries
Workshop: Generating SQL Code from a SQL Statement
APPENDIX A: Common SQL Commands
APPENDIX B: Popular Vendor RDBMS Implementations
Installing the Oracle Database Software Used for Examples and Hands-On Exercises
APPENDIX C: Answers to Quizzes and Exercises
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”