Java and SQL Course Outline


This Intermediate Java and SQL Programming training course gives developers a review of Java foundational concepts before moving on to intermediate and advanced topics in Java and OO development. Participants learn functional programming with lambdas and streams, as well as the Java Platform Module System (JPMS). UML, Design Patterns, and the use of composition versus inheritance are taught, as is unit testing. On top of that participants will also learn ANSI/ISO standard SQL, with examples in SQL Server, Oracle, DB2 LUW and z/OS, and MySQL, with emphasis on SQL Server and Oracle. Labs can be done in any of those database environments.

Enquiry Us Now


After you have completed the course, you should be able to:

  • Solidify their Java foundational knowledge, including the important contracts of class Object.
  • Understand the uses and consequences of inheritance and composition, and reinforce the role of interfaces.
  • Leverage fundamental OO principles such as cohesion, coupling, and polymorphism.
  • Use the JUnit testing framework and become fluent in writing assertions to verify correct program behavior.
  • Understand UML modeling in class diagrams and sequence diagrams.
  • Use advanced techniques for object creation, including factories and singletons.
  • Use established design patterns for object composition, including Strategy, Decorator, and Facade.
  • Write and use generic classes and methods.
  • Leverage the use cases for inner classes and refactor existing code to use them when appropriate.
  • Create and use custom annotations.
  • Use reflection and how to use it.
  • Understand the role of functional interfaces.
  • Understand lambda expressions and method references, and use them to pass behavior (methods).
  • Use the Stream API to perform complex processing of collections and other input sources.
  • Create and use Java modules, understanding module descriptors, modular JARs, exports and dependencies, and the module path.


Programmers with experience working in Java or SQL environments.

Training Methodology: Virtual via Zoom, smart whiteboard, Software Tools.
Duration: 4 Days Interactive Training


Introduction: Java State of the Union

– Java Release Cycle
– New Java Versions

Review – Basics

– Java Environment
– Classes and Objects
(i) Instance Variables, Methods, Constructors, Static Members
(ii) OO Principles: Data Encapsulation, Cohesion
(iii) Object Contracts: toString(), equals() and hashCode(), Comparable and Comparator
– Packages, Enums, Arrays
– Exceptions
– Date and Time API
– New Language Features

Review (Inheritance and Interfaces)

– UML Overview
– Inheritance
(i) Definition and IS-A Relationship
(ii) Method Overriding, @Override
(iii) OO Principles: Principle of Substitutability, Polymorphism and Encapsulation of Type, Coupling, Open-Closed Principle
(iv) Constructor Chaining
– Interfaces
(i) Defining and Implementing, Interface Types
(ii)Interface Inheritance
– New Interface Features (Java 8+)
(i) Default Methods, Static Methods
(ii) Functional Interfaces
– Guidelines


– Overview
– Tests, Assertions, and Fixtures
(i) Writing and Running Tests
(ii) Assertions
(iii) Test Fixtures, @Before and @After, @BeforeClass and @AfterClass
(iv) Testing for Exceptions
– Best Practices and Test-Driven Development Overview (TDD)

Collections and Generics

– Collections Overview
(i) Generics and Type-Safe Collections
(ii) Diamond Operator
– Lists, Sets, and Maps
(i) Interfaces and Contracts
(ii) Iteration and Autoboxing
(iii) Utility Classes – Collections and Arrays
– Writing Generic Classes
(i) Inheritance with Generic Types
(ii) Wildcard Parameter Types
(iii) Type Erasure

Techniques of Object Creation

– Design Patterns Overview
– Controlling Object Creation
(i) Limitations of new Operator, Alternative Techniques
– Singleton Pattern
– Simple Factory
– Factory Method Pattern
– Other Techniques
(i) Named Objects, JNDI
(ii) Dependency Injection Frameworks

Using Composition and Inheritance Effectively

– Inheritance and Composition – Pros and Cons
(i) Composition and Delegation
(ii) HAS-A, USES Relationships
– Strategy Pattern
– Decorator Pattern
– Façade and Other Patterns
(i) Façade, Proxy, Template Method

Inner Classes

– Overview and Motivation
(i) Stronger Encapsulation, Rules and Caveats
– Defining and Using Inner Classes
(ii) Member-Level, Method-Local, Anonymous Classes
– Static Nested Classes
(iii) Nested Classes, Nested Interfaces, Nested Enums


– Overview
– Using Annotations
(i) Target and Retention Policy
(ii) Annotation Parameters, Parameter Shortcuts
– Writing Custom Annotations
(i) Syntax, Using the Meta-Annotations
(ii) Using a Custom Annotation


– Overview and API
(i) The Class Called Class
(ii) Obtaining and Inspecting Class Objects
– Working with Objects Reflectively
(i) Creating Instances, Invoking Methods, Setting Field Values

Lambda Expressions

– Functional Interfaces and Lambdas
– Target Context
– Using Lambda Expressions
(i) Syntax, Lambda Compatibility
(ii) Variable Capture
(iii) Type Inference
– Method References
(i) Three Types of Method References
(ii) Refactoring Lambdas into Method References


– Overview
(i) Streams vs. Collections
(ii) Anatomy of a Stream
– Understanding the Stream API
(i) Intermediate Operations and Stream Pipeline
(ii) Java 8 Functional Interfaces: Predicate, Comparator, Function
– Stream Processing
(i) Filtering, Sorting, Mapping
(ii) Terminal Operations
– Collectors
(i) Concepts
(ii) Partitioning and Grouping

Introduction to Modules

– Motivation and Overview
– Types of Modules
– Modular JDK
– Our Approach


– Techniques for solving complex problems
– Using multiple tables
– Text handling issues
– Case logic
– SQL Summarization
– Stored Procedures