Database fundamentals for Java Programmers [Video]

[Bo0mB0oma]

 

 

Database fundamentals for Java Programmers [Video]

English | Size: 2.00 GB

Category: Tutorial

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

 

All MP4 video files in one ZIP archive.

 

Table of Contents

 

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

More On Join Operations 1 00:06:17

More On Join Operations 2 00:06:28

More On Join Operations 3 00:06:29

Indexing And Pattern-Based Searching 00:07:14

Wrapup Of Normalization And Joins 00:06:39

 

SQL Beyond The Basics

 

Transactions: The Acid Properties 00:07:05

Transaction Code Analysis 1 00:06:10

Transaction Code Analysis 2 00:04:36

Transaction Programming Exercise 00:03:54

Assessment Of The Transaction Code Example 00:08:08

Data Hierarchies In A Relational Database 00:06:18

Data Hierarchy Code Analysis 00:07:50

Triggers 00:07:10

Wrapup Of Transactions And Triggers 00:04:59

 

JPA As The Java ORM API

 

From JDBC To JPA 00:06:19

JPA Code Example Overview 00:05:47

JPA Code Analysis 1 00:08:35

JPA Code Analysis 2 00:09:19

Another JPA Code Example 00:12:15

JPA Programming Exercise 00:06:47

The recClub Database In JPA 00:11:23

Wrapup Of JPA Basics 00:05:25

 

From SQLite3 To PostgreSQL

 

PostgreSQL Installation And Setup 00:05:16

A First App Against PostgreSQL 00:08:04

Database Relationships: Overview 00:06:18

EMP-DEPT Code Analysis 1 00:06:20

EMP-DEPT Code Analysis 2 00:08:35

Wrapup Of JPA With PostgreSQL 00:04:29

 

From Relational To NoSQL Database Systems

 

NoSQL Databases: Overview And Motivation 00:06:09

MongoDB: Installation And Setup 00:03:46

MongoDB Code Example 1 00:05:07

MongoDB Code Example 2 00:04:09

Porting The recClub Database To MongoDB 00:06:37

MongoDB Under The Hood 00:06:29

MongoDB Queries Example 00:07:52

Wrapup Of NoSQL And MongoDB 00:05:47

 

Course Wrapup

 

Wrapup Of The Database Systems And APIs 00:05:34

DOWNLOAD

(Buy premium account for maximum speed and resuming ability)

 

http://nitroflare.com/view/10CE050F2946BCE/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part1.rar

http://nitroflare.com/view/757184752CF1140/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part2.rar

http://nitroflare.com/view/E4CB1E45E7EC34F/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part3.rar

http://nitroflare.com/view/A51C794691665D3/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part4.rar

 

https://rapidgator.net/file/a2bc0e0d13ca35032c90e75c55c96f30/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part1.rar

https://rapidgator.net/file/9bd2a2994a98f3473f5ba67b97a64e27/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part2.rar

https://rapidgator.net/file/1c6725060d7b84830f196b68ca288611/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part3.rar

https://rapidgator.net/file/3492e0b16d55f1d4cc19aade56ae353f/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part4.rar

 

http://turbobit.net/h9c1flsgdu39/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part1.rar.html

http://turbobit.net/n2fkpw79nzlk/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part2.rar.html

http://turbobit.net/rwucowoxcck0/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part3.rar.html

http://turbobit.net/i3cqniwzv4q8/7r5lr.Database.fundamentals.for.Java.Programmers.Video.part4.rar.html