Udemy - An Introduction to JDBC, JNDI and Spring JDBC with Tomcat

Spring JDBC Support
What you'll learn
What is JDBC - Java Database Connectivity
What is the difference between regular Java JDBC and Spring JDBC
What is a JDBC Connection and an overview of the different types
How to set up a JDBC Datasource Connection
How to use the Spring JDBC Template to access a relational database
Understand JNDI and defining a DB Connection
Use Spring Boot to put together an Embedded Tomcat JDBC CRUD Application
Requirements
Be familiar with Java Software Development
Be familiar with modern Java IDE's such as IntelliJ
Be familiar with the concept of a Relational Database
A basic understanding of the Maven build tool
A basic understanding of Git source control and how to use Github
Description
Data Access with Spring JDBC Support using JNDI in an embedded Tomcat Server .
Course Modules
Course Introduction - JDBC History & Sample User Story
Our Spring JDBC Development Environment
Connecting to the Database
DAO with Traditional JDBC vs Spring JDBC
Full CRUD with Spring JDBC Template example
Why learn Spring JDBC ?
JDBC use is widespread in large companies worldwide
Actively maintained for 20+ years and counting
Spring JDBC gives you a "quick win" when dealing with legacy JDBC code
Spring JDBC - Sample User Story
As an expatriate living abroad I want access to an online database of all charities (non-profits) that operate in my "home country".
I want to be able to find Charities by their Tax Id
I want to be able to search by Charity Category such as Environment or Education
I want to be able to search by Charity Program Types
Connecting to the MariaDB with JDBC
Establishing a Connection
Using the DriverManager Class
Specify the database Connection URLs
Connecting to the MariaDB with Spring
Define Spring DataSource Bean to get a DB Connection
Specify the database properties in application.xml
Using the MariaDB DataSource Bean Class
Connecting to the MariaDB
Using JNDI DataSource Objects to Get a Connection
Registering DataSource Object with Naming Service That Uses JNDI API
Creating Instance of DataSource Class and Setting its Properties
Using Deployed DataSource Object
Connecting to the MariaDB
Using JNDI to Get a JDBC Connection in Embedded Tomcat
Java Main Method to launch Embedded Tomcat
Registering DataSource Object with JNDI API
Using the registered JNDI DataSource Object
Running the JAR with Maven Plugin
Connecting to the MariaDB
Using Spring App Context to Get a JDBC Connection Tomcat
Java Main Method to launch Embedded Tomcat
Defining the DataSource in Spring application.xml
Adding a context listener to web.xml
Retrieve the Spring Data Source bean in the Servlet
Connecting to the MariaDB
Using Spring Annotation Config in Embedded Tomcat
Java Main Method to launch Embedded Tomcat
Defining the DataSource in Spring Config Class
Retrieve the Spring DataSource bean in the Servlet
Who this course is for
Java Developers who have to write code to access a relational database
Java Developers who want to use Spring JDBC for streamlining database access to a relational database
Homepage
https://www.udemy.com/course/an-introduction-to-jdbc-jndi-and-spring-jdbc-with-tomcat/