JDBC - Java Database Connectivity Training

Answers to Popular Questions:

 
Yes, this class can be tailored to meet your specific training needs.
Yes, we provide Java Programming consulting services.
Yes, group discounts are provided.

Course Description

 
DBC is a Java technology for accessing SQL databases. It is a core part of J2EE, and it works with every major database product. This hands-on course covers all the details that you will need to use JDBC to access the information in your databases using Java. It also talks about real world issues in using JDBC.
Course Length: 1 Days
Course Tuition: $690.00 (US)

Prerequisites

Programmers with experience in working with Java and Object - Oriented (OO) programming.

Course Outline

 
Hands-on: 50% hands-on, 50% lecture
 
 
Skills Gained:
 
Understand the JDBC architecture
Connect to different databases with JDBC
Understand the JDBC API
Execute SQL statements using JDBC, and retrieve results
Call stored procedures from JDBC
Understand and control transactions with JDBC
Retrieve information about database structure using DatabaseMetaData
Use Advanced JDBC features
 
Course Details:
Introduction
Relational Database and JDBC Overview
Overview, Table Relationships, Web Based Data Access, JDBC Characteristics
JDBC Architecture, JDBC API Overview
DriverManager, JDBC Drivers
Naming databases with JDBC URLs
Connecting to a database
Connection interface, Establishing a connection
DataBaseMetaData
Handling Database Exceptions
 
Data Access
DAO – Data Access Objects, O-R Mapping, Value Objects
Processing Database Data
Executing statements, precompiled statements and stored procedures
Processing ResultSets,
Dealing with Null data
Updating, inserting, retrieving data
Controlling Transactions
JDBC Driver Types
DataSource
J2EE and DataSource
Using JNDI
Connection Pooling
Overview, Usage, Advantages, Statement Pooling
 
Advanced Topics
Other Database Access Technologies
SQLJ, O-R Mapping Tools, JDO (Java Data Objects), EJB Entity Beans
Advanced JDBC Features
Batch Updates, Srollable Result Sets, Rowsets, User Defined Types, BLOBS, CLOB
 

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Java Programming Uses & Stats

Java Programming is Used For:
Android & IOS Development Software Products Video Games Desktop GUI's
Difficulty
Popularity
Year Created
1995
Pros

Most Commonly Used: 
According to Oracle, three billion devices run on Java.  And, because of its real-world applications, it consistently ranks at the top of the TIOBE Programming Community Index. 

Great Career Choice: 
Some of the fastest-growing salaries in the U.S. in 2018 are for Java developers.  (Glassdoor)  

Android Apps Development:
Developers predominatly use their Java skills in building apps for Google's Android. The Android platform is the number one mobile paltform in the world

It Can Run On Any Platform:
Java can compile on Windows and run the same compiled file on Linux, Windows and Mac.

Great Supporting IDE's:
Over the years, coding in Java has become simpler with the introduction of open source development tools, i.e. Eclipse and NetBeans that use Java capabilities for debugging.  
 

Cons

Uses a Lot of Memory:
Performance can be significantly slower with Java and more memory-consuming than natively compiled languages such as C or C++.

Difficulty in Learning: 
Learning Java can be a bit challenging if you are a beginner.  However, once you get the hang of Object Oriented Programming and a decent grasp of the syntax, you will be well on your way.

Slow Start Up Times:
There is quite a bit of one-time initialization done by JDK classes before compiling as well as loading classes and verification (making sure code doesn't do evil things, all of which takes longer that some other languages such as C. 

Verbose and Complex Code:
Long, over-complicated sentences make code less readable and scannable. Compare to let's say Python, we can see how clear Python code appears: It doesn’t require semicolons; uses “and,” “or,” and “not” as operators instead of Java’s “&&,” “||,” and “!”; and generally has fewer bells and whistles such as parentheses or curly braces.

Commercial License Cost:
Companies have to prepare for the changes that Oracle will institute in 2019 . Today, the current version of Java is free and available for redistribution for general purpose computing. However, If you are a DEVELOPER, Oracle recommends you review the roadmap information for Java SE 8 and beyond and take appropriate action depending on the type of application you develop and your distribution mode.

Java Programming Job Market
Average Salary
$102,000
Job Count
26,856
Top Job Locations

New York City 
San Jose
Washington D.C, 

Complimentary Skills to have along with Java Programming

- If you are an experienced Java developer, learning a complimentary language to Java should come much more naturally.  As an example JetBrains recently created the Kotlin programming language which is officially supported by Google for mobile development.  Kotlin compiles to Java bytecode and runs on the JVM; it's purported to address many of Java's shortcomings...

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.