К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Java Database Engineering: Spring Boot MVC & SQL Mastery · LearnSpace
Назад в каталог
courseraПрограммирование

Java Database Engineering: Spring Boot MVC & SQL Mastery

Курс от Birla Institute of Technology & Science, Pilani
Средний≈ 54.4 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Master the full stack of database engineering with this comprehensive course that bridges theoretical SQL knowledge with practical Spring Boot MVC application development. Through hands-on projects building a library management system, you'll learn to design normalized databases, implement efficient data access layers, create interactive web interfaces, and deploy robust applications. This course provides a perfect balance of SQL fundamentals, advanced database concepts, and modern Java frameworks, empowering you to develop scalable, maintainable database applications for real-world deployment. This course is designed for software developers looking to enhance their backend development skills, IT professionals transitioning to database engineering roles, computer science students seeking practical database application experience, and web developers wanting to strengthen their full-stack capabilities with robust database integration. Skills Covered - SQL Query Development and Optimization - Database Design and Normalization - Spring Boot Application Development - JPA/Hibernate Entity Mapping - MVC Architecture Implementation - JSP and JavaScript Integration - Database Performance Monitoring Course Value Additions - Hands-On Project: Develop a complete library management system from scratch - Industry-Standard Tools: Experience with MySQL, Spring Boot, Tomcat, and Postman - Real-World Testing: Learn unit and integration testing strategies for database applications - Performance Optimization: Master techniques for database indexing and query optimization

Навыки, которые вы освоите

Hibernate (Java)Object-Relational MappingQuery LanguagesDatabase DevelopmentPerformance TuningDatabase TheoryFrontend IntegrationDevelopment TestingSoftware Testing

Программа курса

10 модулей · 307 учебных материалов

01SQL Primer37 материалов

Course Introduction

Building Database ApplicationsВидеоCourse Overview and InformationЧтениеMeet Your Instructor: C. Rakesh PrasannaВидеоMeet Your Instructor: Dr. Saikishor JangitiВидео

Database and Table Basics

Учитесь у экспертов

BITS Pilani Instructors Group

Преподаватель курса

Java Database Engineering: Spring Boot MVC & SQL Mastery
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 54.4 ч

10 модулей

Язык: Английский

Субтитры: Арабский, Французский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
Introduction to SQL and DatabasesВидео
Introduction to SQL and DatabasesЗадание
Creating and Dropping TablesВидео
Creating and Dropping TablesЗадание
SQL Data TypesВидео
SQL Data TypesЗадание
Inserting Data into TablesВидео
Inserting Data into TablesЗадание
Recommended Reading: Database and Table BasicsЧтение

Table Constraints and Modifications

Table ConstraintsВидеоTable ConstraintsЗаданиеAltering Table StructuresВидеоAltering Table StructuresЗаданиеRecommended Reading: Table Constraints and ModificationsЧтение

SQL Command Categories and Data Retrieval

Data Definition Language (DDL)ВидеоData Definition Language (DDL)ЗаданиеData Manipulation Language (DML)ВидеоData Manipulation Language (DML)ЗаданиеData Query Language (DQL)ВидеоData Query Language (DQL)ЗаданиеData Control Language (DCL)ВидеоData Control Language (DCL)ЗаданиеTransaction Control Language (TCL)ВидеоTransaction Control Language (TCL)ЗаданиеString Functions in SQLВидеоString Functions in SQLЗаданиеRecommended Reading: SQL Command Categories and Data RetrievalЧтение

Practical Exercises and Applications

Real-world SQL ScenariosВидеоReal-world SQL ScenariosЗаданиеRecommended Reading: Practical Exercises and ApplicationsЧтение

Summary and Assessment

Summary and Best PracticesВидеоDatabase Detective: Ensuring Data Integrity in SQLDIALOGUETest Yourself: SQL PrimerЗадание
02 Intermediate SQL and Indexing25 материалов

Functions, Stored Procedures and Triggers

FunctionsВидеоFunctionsЗаданиеStored ProceduresВидеоStored ProceduresЗаданиеTriggersВидеоTriggersЗаданиеRecommended Reading: Functions, Stored Procedures and TriggersЧтение

Indexes

Ordered IndicesВидеоOrdered IndicesЗаданиеB-Tree IndexingВидеоB-Tree IndexingЗаданиеB+ Tree IndexingВидеоB+ Tree IndexingЗаданиеHashingВидео

Filtering Aggregation and Oher features

Filtering FeaturesВидеоFiltering features – DISTINCT, ORDERBY, GROUPBY, LIKE, LIMITЗаданиеAggregation – MIN, MAX with GROUPBY, AVG, SUMВидеоAggregation – MIN, MAX with GROUPBY, AVG, SUMЗаданиеAuto – Increment Columns, ReplaceВидеоAuto – Increment Columns, ReplaceЗадание

Discussion and Assessment

Exploring Filtering and Aggregation Techniques in SQLDIALOGUETest Yourself: Intermediate SQL and IndexingЗадание
03Advanced SQL Relationships and Normalisation25 материалов

Relationships and Normalisation

One-to-Many RelationshipsВидеоOne-to-Many RelationshipsЗаданиеDatabase NormalisationВидеоDatabase NormalisationЗаданиеRecommended Reading: Relationships and NormalisationЧтение

Types of JOINs

Cross JoinВидеоCross JoinЗаданиеInner JoinВидеоInner JoinЗаданиеLeft Join & Right JoinВидеоLeft Join & Right JoinЗаданиеAdvanced Join OperationsВидеоAdvanced Join OperationsЗаданиеRecommended Reading: Types of JOINsЧтение

Window Functions

Introduction to Window FunctionsВидеоIntroduction to Window FunctionsЗаданиеUsing PARTITION BYВидеоUsing PARTITION BYЗаданиеPractical Applications of Window FunctionsВидеоPractical Applications of Window FunctionsЗадание

Lab and Assessment

Ensuring Efficient Data Retrieval and Integrity with SQL Joins and NormalisationОбсуждениеPractice LabЛабораторнаяPractice Lab Solutions ЧтениеTest Yourself: Advanced SQL Relationships and NormalisationЗадание
04Database Design26 материалов

Introduction to Database Design

Why Database Design is ImportantВидеоWhy Database Design is ImportantЗаданиеPrimary Terminologies Used in Database DesignВидеоPrimary Terminologies Used in Database DesignЗаданиеRecommended Reading: Introduction to Database DesignЧтение

Domain Models and Data Models

Introduction to Domain ModelsВидеоIntroduction to Domain ModelsЗаданиеData ModelsВидеоData ModelsЗаданиеRecommended Reading: Domain Models and Data ModelsЧтение

Documenting Database Applications

Entity-Relationship Diagrams (ERDs)ВидеоEntity-Relationship Diagrams (ERDs)ЗаданиеEntity-Relationship Diagrams (ERDs) - AdvancedВидеоEntity-Relationship Diagrams (ERDs) - AdvancedЗаданиеExtended ER ModelsВидеоExtended ER ModelsЗадание

Advanced Database Design Techniques

Normalisation and DenormalisationВидеоNormalisation and DenormalisationЗаданиеDesigning for Scalability and PerformanceВидеоDesigning for Scalability and PerformanceЗаданиеAdvanced Database Design TechniquesЧтение

Lab and Assessment

Designing an Effective Database with Entity-Relationship Diagrams (ERDs)ОбсуждениеPractice Lab: ERD-Based Database Creation and Advanced SQL QueriesЛабораторнаяPractice Lab Solutions: ERD-Based Database Creation and Advanced SQL QueriesЧтениеTest Yourself: Database DesignЗадание
05Monitoring and Maintaining Database Applications29 материалов

Backup and Restore Operations

Importance of BackupsВидеоImportance of BackupsЗаданиеBackup Strategies ВидеоBackup Strategies ЗаданиеPerforming BackupВидеоPerforming BackupЗаданиеRestoring DatabasesВидеоRestoring DatabasesЗаданиеRecommended Reading: Backup and Restore OperationsЧтение

Index Maintenance

Rebuilding IndexesВидеоRebuilding IndexesЗаданиеRecommended Reading: Index MaintenanceЧтение

Data Loading Techniques

Importing and Exporting DataВидеоImporting and Exporting DataЗаданиеBulk UploadsВидеоBulk UploadsЗаданиеRecommended Reading: Data Loading TechniquesЧтение

Performance Monitoring and Optimization

Monitoring Database PerformanceВидеоMonitoring Database PerformanceЗаданиеOptimising Database PerformanceВидеоOptimising Database PerformanceЗаданиеPerformance Monitoring and OptimisationЧтение

Ensuring Data Integrity and Handling Large Data Sets

Ensuring Data IntegrityВидеоEnsuring Data IntegrityЗаданиеHandling Large Data SetsВидеоHandling Large Data SetsЗаданиеEnsuring Data Integrity and Handling Large Data SetsЧтение

Discussion and Assessment

Monitoring and Maintaining Database ApplicationsОбсуждениеTest Yourself: Monitoring and Maintaining Database ApplicationsЗадание
06Introduction and Project Setup34 материалов

Overview of the Project

Introduction to the Library Management ApplicationВидеоIntroduction to the Library Management ApplicationЧтениеIntroduction to the Library Management ApplicationЗаданиеUnderstanding the MVC ArchitectureВидеоUnderstanding the MVC ArchitectureЧтениеUnderstanding the MVC ArchitectureЗаданиеTools and Technologies NeededВидеоTools and Technologies NeededЧтениеTools and Technologies NeededЗаданиеSetting Up the Development EnvironmentВидеоSetting Up the Development EnvironmentЧтениеSetting Up the Development EnvironmentЗаданиеInitialising a Spring Boot ProjectВидеоInitialising a Spring Boot ProjectЧтениеInitialising a Spring Boot ProjectЗадание

Database Design and Configuration

Designing the Database Schema for the Library ApplicationВидеоDesigning the Database Schema for the Library ApplicationЧтениеDesigning the Database Schema for the Library ApplicationЗаданиеSetting Up MySQL DatabaseВидеоSetting Up MySQL DatabaseЧтениеSetting Up MySQL DatabaseЗадание

Lab and Assessment

Basics of Database Schema Design for a Library Management SystemОбсуждениеPractice Lab: Hand-on PostgreSQL Database Creation and Table ManagementЛабораторнаяAdditional MySQL Database Creation and Table Management PracticeЧтениеTest Yourself: Introduction and Project SetupЗадание
07 Implementing the Model Layer33 материалов

Creating Entity Classes

Introduction to JPA and HibernateВидеоIntroduction to JPA and HibernateЧтениеIntroduction to JPA and HibernateЗаданиеCreating the Book Entity ClassВидеоCreating the Book Entity ClassЧтениеCreating the Book Entity ClassЗаданиеDefining Relationships Between EntitiesВидеоDefining Relationships Between EntitiesЧтениеDefining Relationships Between EntitiesЗаданиеUsing Annotations for Entity ConfigurationВидеоUsing Annotations for Entity ConfigurationЧтениеUsing Annotations for Entity ConfigurationЗаданиеTesting Entity Classes with a Simple Main MethodВидеоTesting Entity Classes with a Simple Main MethodЧтениеTesting Entity Classes with a Simple Main MethodЗадание

Implementing Data Access Objects (DAO)

Introduction to DAOs and RepositoriesВидеоIntroduction to DAOs and RepositoriesЧтение Introduction to DAOs and RepositoriesЗаданиеCreating a Repository Interface for BookВидеоCreating a Repository Interface for BookЧтениеCreating a Repository Interface for BookЗадание

Lab and Assessment

JPA Repositories and Custom Query MethodsОбсуждениеPractice Lab: Spring Boot Application to Manage BooksЛабораторнаяTest Yourself: Implementing the Model LayerЗадание
08Implementing the View Layer33 материалов

Introduction to JSP and HTML Forms

Introduction to JSP (JavaServer Pages)ВидеоIntroduction to JSP (JavaServer Pages)ЧтениеIntroduction to JSP (JavaServer Pages)ЗаданиеCreating Basic HTML TemplatesВидеоCreating Basic HTML TemplatesЧтениеCreating Basic HTML TemplatesЗаданиеCreating and Processing HTML Forms in JSPВидеоCreating and Processing HTML Forms in JSPЧтениеCreating and Processing HTML Forms in JSPЗаданиеBinding Data to JSP PagesВидеоBinding Data to JSP PagesЧтениеBinding Data to JSP PagesЗаданиеIntegrating CSS for StylingВидеоIntegrating CSS for StylingЧтениеIntegrating CSS for StylingЗадание

Enhancing User Interface with JavaScript and JQuery

Introduction to JavaScript and JQueryВидеоIntroduction to JavaScript and JQueryЧтениеIntroduction to JavaScript and JQueryЗаданиеAdding JavaScript to JSP PagesВидеоAdding JavaScript to JSP PagesЧтениеAdding JavaScript to JSP PagesЗадание

Lab and Assessment

The Importance of Views in a Book ProjectОбсуждениеPractice Lab: Updating Books in Spring Boot ApplicationЛабораторнаяTest Yourself: Implementing the View LayerЗадание
09Implementing the Controller Layer33 материалов

Handling User Requests

Introduction to Spring MVC ControllersВидеоIntroduction to Spring MVC ControllersЧтениеIntroduction to Spring MVC ControllersЗаданиеCreating a Controller for the Home PageВидеоCreating a Controller for the Home PageЧтениеCreating a Controller for the Home PageЗаданиеHandling Form Submissions (Add Book)ВидеоHandling Form SubmissionsЧтениеHandling Form SubmissionsЗаданиеRedirecting and Forwarding RequestsВидеоRedirecting and Forwarding RequestsЧтениеRedirecting and Forwarding RequestsЗаданиеDisplaying Validation ErrorsВидеоDisplaying Validation ErrorsЧтениеDisplaying Validation ErrorsЗадание

CRUD Operations

Creating a Controller Method to View BooksВидеоCreating a Controller Method to View BooksЧтениеCreating a Controller Method to View BooksЗаданиеCreating a Controller Method to Add a BookВидеоCreating a Controller Method to Add a BookЧтениеCreating a Controller Method to Add a BookЗадание

Lab and Assessment

Importance of Exception Handling and Server-Side Validation in Spring Boot ControllersОбсуждениеPractice Lab: Deleting Books in Spring Boot ApplicationЛабораторнаяTest Yourself: Implementing the Controller LayerЗадание
10Testing, Debugging, and Deployment32 материалов

Testing and Debugging Database Applications

Introduction to Testing Spring Boot ApplicationsВидеоIntroduction to Testing Spring Boot ApplicationsЧтениеIntroduction to Testing Spring Boot ApplicationsЗаданиеWriting Unit Tests for ControllersВидеоWriting Unit Tests for ControllersЧтениеWriting Unit Tests for ControllersЗаданиеWriting Integration TestsВидеоWriting Integration TestsЧтениеWriting Integration TestsЗаданиеUsing Postman to Test API EndpointsВидеоUsing Postman to Test API EndpointsЧтениеUsing Postman to Test API EndpointsЗаданиеDebugging Common Issues in Database ApplicationsВидеоDebugging Common Issues in Database ApplicationsЧтениеDebugging Common Issues in Database ApplicationsЗадание

Deployment and Maintenance

Packaging the Application (JAR/WAR)ВидеоPackaging the Application (JAR/WAR)ЧтениеPackaging the Application (JAR/WAR)ЗаданиеDeploying the Application to a Web Server (Tomcat)ВидеоDeploying the Application to a Web Server (Tomcat)ЧтениеDeploying the Application to a Web Server (Tomcat)Задание

Discussion and Assessment

Deployment Procedures of a Spring Boot ApplicationDIALOGUETest Yourself: Testing, Debugging, and DeploymentЗадание
HashingЗадание
Recommended Reading: IndexesЧтение
Recommended Reading: Filtering Aggregation and Oher featuresЧтение
Recommended Reading: Window FunctionsЧтение
Recommended Reading: Documenting Database ApplicationsЧтение
Integrating MySQL with Spring BootВидео
Integrating MySQL with Spring BootЧтение
Integrating MySQL with Spring BootЗадание
Creating Initial Database Tables and Testing ConnectionsВидео
Creating Initial Database Tables and Testing ConnectionsЧтение
Creating Initial Database Tables and Testing ConnectionsЗадание
ORM Setup and ConfigurationВидео
ORM Setup and ConfigurationЧтение
ORM Setup and ConfigurationЗадание
Implementing Custom Query MethodsВидео
Implementing Custom Query MethodsЧтение
Implementing Custom Query MethodsЗадание
Service Layer Introduction and ImplementationВидео
Service Layer Introduction and ImplementationЧтение
Service Layer Introduction and ImplementationЗадание
Writing Unit Tests for DAOs and Service MethodsВидео
Writing Unit Tests for DAOs and Service MethodsЧтение
Writing Unit Tests for DAOs and Service MethodsЗадание
Enhancing Interactivity with JQueryВидео
Enhancing Interactivity with JQueryЧтение
Enhancing Interactivity with JQueryЗадание
Validating Forms with JavaScript and JQueryВидео
Validating Forms with JavaScript and JQueryЧтение
Validating Forms with JavaScript and JQueryЗадание
AJAX Calls with JQueryВидео
AJAX Calls with JQueryЧтение
AJAX Calls with JQueryЗадание
Creating a Controller Method to Delete a BookВидео
Creating a Controller Method to Delete a BookЧтение
Creating a Controller Method to Delete a BookЗадание
Updating Book InformationВидео
Updating Book InformationЧтение
Updating Book InformationЗадание
Handling Exceptions in ControllersВидео
Handling Exceptions in ControllersЧтение
Handling Exceptions in ControllersЗадание
Configuring Application Properties for Different EnvironmentsВидео
Configuring Application Properties for Different EnvironmentsЧтение
Configuring Application Properties for Different EnvironmentsЗадание
Monitoring and Maintaining the ApplicationВидео
Monitoring and Maintaining the ApplicationЧтение
Monitoring and Maintaining the ApplicationЗадание
Final Project Review and Next StepsВидео
Final Project Review and Next StepsЧтение
Final Project Review and Next StepsЗадание