by | Released October 2013 | ISBN: 9781771371674

In this Java Database Programming training course, expert author Mike McMillan shows you the concepts and tools you will work with in order to successfully build functional database programs using the popular programming language. You will start out by setting up a database using MySQL. You will learn how to CREATE TABLE IF NOT EXISTSs, insert and query data, and update and remove records. From there, Mike will show you how to use Java to connect to MySQL. This video tutorial will also teach you advanced database techniques, including installing, setting up, and creating tables in NetBeans. You will learn how to create a Java/MySQL App and a NetBeans Platform App. Finally you will learn how to use the built-in Derby database in NetBeans. By the completion of this computer based training course, you will have developed the necessary knowledge and skills needed to create exceptional database programs with Java. Working files are included, allowing you to follow along with the author throughout the lessons. Show and hide more Publisher resources Download Example Code

1. Getting Started
   • What This Course Covers 00:02:09
   • Installing Java In Windows 00:02:46
   • Installing MySQL In Windows 00:03:53
   • Installing Java On Mac 00:00:54
   • Installing MySQL On Mac 00:01:05
   • Installing The Connector J Driver 00:02:27
2. Using MySQL
   • Setting Up A Database 00:02:24
   • Creating Tables 00:01:55
   • Inserting Data 00:01:46
   • Querying Data 00:01:50
   • Updating Records 00:01:37
   • Removing Records 00:01:55
   • Using MySQL - Exercise 1 00:01:37
   • Using MySQL - Exercise 2 00:03:10
3. Using Java To Connect To MySQL
   • Testing Driver Function 00:01:56
   • Connecting To Database 00:03:18
   • Querying Table 00:03:40
   • Updating Table 00:03:21
   • Inserting Data Into Table 00:03:43
   • Removing Data From Table 00:03:14
   • Using Java To Connect To MySQL - Exercise 1 00:03:16
   • Using Java To Connect To MySQL - Exercise 2 00:03:18
   • Using Java To Connect To MySQL - Exercise 3 00:01:49
   • Using Java To Connect To MySQL - Exercise 4 00:02:35
4. Advanced Database Techniques
   • Installing NetBeans 00:01:34
   • Setting Up NetBeans 00:01:49
   • Creating Table In NetBeans 00:03:19
   • Insert, Update And Delete Using NetBeans 00:03:17
   • Advanced Database Techniques - Exercise 1 00:02:19
   • Advanced Database Techniques - Exercise 2 00:02:02
5. Java/MySQL App In NetBeans
   • Creating A Database - CRUD Application 00:02:20
   • Creating A Java/MySQL App 00:02:20
   • Creating A NetBeans Platform App 00:03:47
6. Using The Built-In Derby Database In NetBeans
   • Starting A Java DB Application In NetBeans 00:03:35
   • Wrapping Jars in Modules 00:01:45
   • Designing The User Interface 00:02:22
   • Creating A Java/Derby App 00:03:14
   • Building A NetBeans/Java DB App 00:03:36
7. About The Author
   • About Mike McMillan 00:02:22
Show and hide more