Java Database Course Outline

Java Database Programming
Series: Java
Weeks: 8
Cost: $200
CEU Credits: 3.0


Java is an industry tool of choice for software development in today's corporate environment. This 8 week course is for aspiring programmers who have had some previous exposure to Java programming, and would like to be able to write their own Java programs that interact with Databases.


  • To learn about Relational Databases
  • To learn how to design a Database
  • To learn how to use Java to make a Database connection
  • To learn how to use Java to create a Database
  • To learn how to work with Database Indexes
  • To learn how to retrieve Database records
  • To learn how to Insert, Update and Delete Database records
  • To learn advanced Database programming techniques


  • Introduction to Java or comparable experience




  • Free download of Sun's Java from the Sun Microsystems Website

Table of Contents

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
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
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

  John Smiley  



Contact Us