| Week 1: |
Everything is Relative
Designing a Database |
- Keeping Track of Things
the Database Way
- Down and Dirty Inside a
Database
- Keeping the Data Orderly
- Building a Good
Relationship with a Relational Database
- The System of
Understanding Systems
- Attributes: The Best Part
of Any Entity
- From Attributes to Data,
The Decomposing Tale
- Describing Data to the
DBMS
- Putting the Pieces of Data
Together
- Dealing with Duplicate
Data
|
| Week 2: |
Data Normalization
Finding Data Quickly with an Index
Client/Server Architecture |
- Simplifying Things with
Normalization
- Removing Repeated Data
with the First Normal Form
- Identifying Dependent Data
with Second Normal Form
- Removing Transitive Data
with the Third Normal Form
- Letting the Key Open the
Door to Your Data
- Storing Data
- Retrieving Data with the
Index Table
- Creating Primary Key
- Making Finds Faster with
Secondary Keys
- Concatenation
- Selecting Indexes
- Too Many Indexes Can Cause
a Slowdown
- The Standalone Database
Application
- Everyone can share data
- Who changed the data
- Whose data is it anyway
- Client/server architecture
|
| Week 3: |
Planning a Database
application
JDBC
Connecting to the Database
Writing Your First Java Database Program |
- Planning Your Database
Application
- Defining the Parts of
Every Database Application
- Inserting data
- Retrieving data
- Modifying data
- Deleting data
- JDBC
- Inside JDBC: An
Application Programmer's Guide
- The Three-Tier Database
Application Model
- Using JDBC to Program
- Creating the Database
- Connecting the Database to
ODBC
- Connecting to the database
and sending a query
- Displaying the results
- Moving down the ResultSet
- Disconnecting from the
database
|
| Week 4: |
Creating and Dropping Tables
Basic Index Etiquette
Stuffing Data into a Table |
- Database Management
- Before Creating a Table
- Creating a Table
- Dropping a Table
- Maintaining Your Index
- Creating a Primary Index
- Creating a Secondary Index
- Creating a Clustered Index
- Before Inserting Data
- Inserting your first row
of data
- Verifying that data was
inserted
- Inserting data into
specific columns
|
| Week 5: |
Selecting Data from a Table |
- Before You Select Data
- Finding data
- Selecting the Columns You
Want to See
- Selecting a single column
- Selecting multiple columns
- Selecting Rows and Columns
- Getting to Know AND, OR,
and NOT
- Making Sure Data Passed
Your Test
- Finding Almost the Perfect
Match with LIKE
- Looking for Nothing with
NULL
- Weeding Out Duplicates
with DISTINCT
- Searching for One of Many
with IN
|
| Week 6: |
Displaying Data from Tables
Updating Data in Tables |
- Finding Data to Update
- Making changes one row at
a time
- Making changes in multiple
rows
- Updating an Entire Table
- Updating Multiple Rows
- Updating Multiple Columns
- Updating with a
Calculation
|
| Week 7: |
Deleting Data in Tables
Picking Data from This Table and That Table |
- Finding Data to Delete
- Deleting a Single Row of
Data
- Deleting Multiple Rows
- Setting up the Database
for Joins
- Knowing the Rules of the
Join
- Joining Two Tables
- Joining Three or More
Tables
- Creating a column name
qualifier
- Creating a table alias
|
| Week 8: |
Grouping and Ordering Data
Subqueries
Ten Most Common Mistakes
10 Things that Didn't Fit into the Book |
- Grouping single columns
- Grouping multiple columns
- Knowing the group
restrictions
- Conditional searches
- Sorting Results
- Subqueries
- Conditional Tests
- Ten Most Common Mistakes
- Ten Things That Didn't Fit
into the Book
|
