Explore advanced SQL features including stored procedures, triggers, and indexing strategies.

Delve into advanced SQL relationships, normalization, and various types of JOIN operations, and explore techniques for establishing relationships between tables, normalizing data, and using different types of JOINs to retrieve related data. The module also covers window functions for advanced data analysis.

Learn database design principles, including domain models, data models, and documenting database applications and evaluate techniques for creating entity-relationship diagrams and extended ER models, which are essential for designing robust and scalable databases. Additionally, you will be introduced to industry-standard tools and methods for documenting database applications.

Implement backup strategies, performance monitoring, and database maintenance techniques, including backup and restore operations, rebuilding indexes, and data loading. Analyse practical methods for ensuring data integrity, optimizing performance, and handling large data sets. The module includes hands-on exercises to reinforce learning.

Configure your development environment and establish project structure for the library application. Gain insight into project objectives, learn to establish a suitable development environment and acquire proficiency in designing a database schema integrated with MySQL using Spring Boot. These skills are essential for effectively implementing backend functionalities and preparing for subsequent modules focused on application development.

Create entity classes and data access objects using JPA/Hibernate.

Develop dynamic web pages using JSP, and enhance user interaction with JavaScript and jQuery functionalities.

Build Spring MVC controllers to handle user requests and implement CRUD operations, integrate with service and repository layers, and manage exception handling and validation errors within the controller layer.

Master testing strategies and deploy applications to production environments. Write tests for Spring Boot applications, deploy to Tomcat with environment-specific configurations, and monitor/debug applications to ensure reliability and performance.