Database Fundamentals for Java Programmers

Video description

Database Fundamentals for Java Programmers

Video description

Database programming and design are core competencies expected of every Java programmer. This code-oriented course moves you toward competency by providing a detailed overview of how to program for the two most common types of database systems used today: The traditional relational RDBMS systems (e.g. Oracle, SQL Server, and PostgreSQL) and the now popular non-relational NoSQL systems (e.g. Mongo DB and Apache Cassandra).

Filled with hands-on action, you'll work with three databases: SQLite3 (relational), PostgreSQL (relational), and MongoDB (NoSQL) and three APIs: JDBC, JPA, and the Java API for MongoDB. In addition, the course also covers the basics of schema design and normalization in RDBMSes.

Acquire the database and design knowledge every Java programmer must possess
Understand the distinctions in programming for relational systems vs. NoSQL systems
Go hands-on with three popular database systems: SQLite3, PostgreSQL, and MongoDB
Gain experience programming with the Java JDBC, JPA, and MongoDB APIs
Explore the basics of schema design and normalization for RDBMS systems
Learn to evaluate the trade-offs between lightweight and heavyweight database systems
Course is designed for learners with basic Java skills and access to Java 8 or later

Martin Kalin has a Ph.D. from Northwestern University and is a professor in the College of Computing and Digital Media at DePaul University who's worked with Java since 1995. In addition to teaching, Martin is a commercial programmer who specializes in writing large software systems related to production planning and scheduling. He has co-written a series of books on C and C++ and is the author of six O'Reilly titles, including "Beginning Java Web Development" and "Learning Apache Tomcat".

Publisher resources

Download Example Code

Introduction

Overview Of Database Basics Using Java 00:03:06

About Me 00:01:39

Software Requirements And Installation 00:05:48

Database Flavors And Systems 00:08:34

JDBC As The Fundamental Java API

JDBC Basics 00:06:41

Overview Of The recClub Database 00:05:06

Code Analysis 1 For The recClub App 00:08:26

Code Analysis 2 For The recClub App 00:10:56

How To Compile And Run The Code Examples 00:06:35

Select Queries Overview 00:07:03

Code Analysis 1 For The Select App 00:06:41

Code Analysis 2 For The Select App 00:11:57

Programming Exercise For Select Queries 00:03:37

Assessment Of The Select Queries Exercise 00:03:42

SQLite3 Client In Detail 00:08:24

Overview Of Webifying A JDBC App 00:05:03

A Sample Web App With JDBC 00:05:27

More On The CRUD Operations In JDBC 00:07:29

JDBC And Related APIs 00:06:07

Wrapup Of JDBC And SQL Basics 00:06:02

Table Design

Data Definition Language (DDL) And Data Manipulation Language (DML) 00:06:08

Table Normalization: Overview And Motivation 00:09:02

Normalization Basics 1 00:08:00

Normalization Basics 2 00:04:35