- Basic understanding of Java and Database
- JDK 1.8 and above
- Maven 3+ - Build Tool
- SQLite - SQLite Database
- H2 - H2 Database used for Connection Pool
- Apache DbUtils - Third Party JDBC Wrapper API
- Apache Log4j - Logging Framework
- Lombok - Automate BoilerPlate Code
- Introduction to Database and JDBC
- Usage of SQLite and H2 Databases
- SQL CRUD Process – Create Read Update Delete
- Usage of log4j – Logging Framework
- JDBC Connection Pool using HikariCP
- Concepts to JPA with Spring JPA
- Introduction to Database Trigger
- Usage of Google Guava Cache for Static Data
- CRUD Java Example using Non-Connection Pool using SQLite
- Search Countries using Non-Connection Pool using SQLite
- Search Countries using HikariCP Connection Pool using H2
- Search Countries using Google Guava Cache
- Ability to Persist Photo in bytes and read back.
- Project Source - https://github.com/newfound-systems and Presentation
- Build Tool Maven - https://maven.apache.org/
- Log4J Tutorials - https://mkyong.com/logging/apache-log4j-2-tutorials/
- SQLite - https://sqlite.org/
- SQLite Tutorials - https://www.tutorialspoint.com/sqlite/index.htm
- H2 - http://www.h2database.com/html/tutorial.html#creating_new_databases
- H2 Home - https://www.h2database.com/html/main.html
- JDBC Wiki - https://en.wikipedia.org/wiki/Java_Database_Connectivity
- Markdown - https://guides.github.com/features/mastering-markdown/
- NEWFOUND SYSTEMS http://www.newfound-systems.com
- Any Questions buzz us at info@newfound-systems.com
- Finished changes
- Baseline to GitHub
- Published as Public Repository
- 👍 Thanks for your time and Stay Safe!
