Database Fundamentals for Java Programmers Training Video [2016, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

Database Fundamentals for Java Programmers Training Video

Год выпуска: 11/2016
Производитель: O'Reilly Media / Infinite Skills
Сайт производителя: infiniteskills.com/training/database-fundamentals-for-java-programmers.html
Автор: Martin Kalin
Продолжительность: 7:00
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: 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
[spoiler="Содержание"]
01. Introduction
0101 Overview Of Database Basics Using Java
0102 About Me
0103 Software Requirements And Installation
0104 Database Flavors And Systems
0105 How To Access Your Working Files

02. JDBC As The Fundamental Java API
0201 JDBC Basics
0202 Overview Of The recClub Database
0203 Code Analysis 1 For The recClub App
0204 Code Analysis 2 For The recClub App
0205 How To Compile And Run The Code Examples
0206 Select Queries Overview
0207 Code Analysis 1 For The Select App
0208 Code Analysis 2 For The Select App
0209 Programming Exercise For Select Queries
0210 Assessment Of The Select Queries Exercise
0211 SQLite3 Client In Detail
0212 Overview Of Webifying A JDBC App
0213 A Sample Web App With JDBC
0214 More On The CRUD Operations In JDBC
0215 JDBC And Related APIs
0216 Wrapup Of JDBC And SQL Basics

03. Table Design
0301 Data Definition Language (DDL) And Data Manipulation Language (DML)
0302 Table Normalization: Overview And Motivation
0303 Normalization Basics 1
0304 Normalization Basics 2
0305 More On Join Operations 1
0306 More On Join Operations 2
0307 More On Join Operations 3
0308 Indexing And Pattern-Based Searching
0309 Wrapup Of Normalization And Joins

04. SQL Beyond The Basics
0401 Transactions: The Acid Properties
0402 Transaction Code Analysis 1
0403 Transaction Code Analysis 2
0404 Transaction Programming Exercise
0405 Assessment Of The Transaction Code Example
0406 Data Hierarchies In A Relational Database
0407 Data Hierarchy Code Analysis
0408 Triggers
0409 Wrapup Of Transactions And Triggers

05. JPA As The Java ORM API
0501 From JDBC To JPA
0502 JPA Code Example Overview
0503 JPA Code Analysis 1
0504 JPA Code Analysis 2
0505 Another JPA Code Example
0506 JPA Programming Exercise
0507 The recClub Database In JPA
0508 Wrapup Of JPA Basics

06. From SQLite3 To PostgreSQL
0601 PostgreSQL Installation And Setup
0602 A First App Against PostgreSQL
0603 Database Relationships: Overview
0604 EMP-DEPT Code Analysis 1
0605 EMP-DEPT Code Analysis 2
0606 Wrapup Of JPA With PostgreSQL

07. From Relational To NoSQL Database Systems
0701 NoSQL Databases: Overview And Motivation
0702 MongoDB: Installation And Setup
0703 MongoDB Code Example 1
0704 MongoDB Code Example 2
0705 Porting The recClub Database To MongoDB
0706 MongoDB Under The Hood
0707 MongoDB Queries Example
0708 Wrapup Of NoSQL And MongoDB

08. Course Wrapup
0801 Wrapup Of The Database Systems And APIs
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC, 1280x720, 16:9, 15fps
Аудио: AAC, 48kHz, 125kbps, stereo
[spoiler="Скриншоты"]



[/spoiler]