MySQL With Spring Boot

Curriculum

The Course Curriculam

Week 1: Introduction to MySQL

Basics of relational databases and MySQL architecture.
Installing MySQL and MySQL Workbench.
Understanding database design: tables, relationships, and normalization.
CRUD operations in MySQL.
Hands-on Practice: Create and manage a sample database with tables and relationships.

Week 2: Introduction to Spring Boot

Week 3: Connecting Spring Boot with MySQL

Week 4: RESTful API Development

Week 5: Advanced MySQL Features

Week 6: Advanced Spring Boot Features

Week 7: Integration with Front-End or Microservices

Week 8: Deployment and Final Project

₹1000

Course Information

Instructor: vedupskilling@gmail.com
Lesson: 33
Duration: 40h
Quizze: 0

Share This Course

MySQL With Spring Boot

The Course Curriculam

Week 1: Introduction to MySQL

Basics of relational databases and MySQL architecture.

Installing MySQL and MySQL Workbench.

Understanding database design: tables, relationships, and normalization.

CRUD operations in MySQL.

Hands-on Practice: Create and manage a sample database with tables and relationships.

Week 2: Introduction to Spring Boot

Overview of Spring Framework and Spring Boot.

Setting up the Spring Boot environment with Maven/Gradle.

Creating a simple Spring Boot application.

Understanding application properties and configuration.

Hands-on Practice: Build a “Hello World” Spring Boot application.

Week 3: Connecting Spring Boot with MySQL

JDBC basics and Spring Data JPA introduction.

Configuring MySQL database with Spring Boot.

Creating repositories and performing basic CRUD operations.

Hands-on Practice: Build a Spring Boot app connected to a MySQL database.

Week 4: RESTful API Development

Introduction to REST principles and Spring Boot’s REST controllers.

Creating APIs for CRUD operations.

Exception handling in Spring Boot APIs.

Hands-on Practice: Develop a CRUD-based RESTful API connected to MySQL.

Week 5: Advanced MySQL Features

Stored procedures, triggers, and indexing in MySQL.

Understanding joins, subqueries, and views.

Database performance optimization techniques.

Hands-on Practice: Create stored procedures and optimize queries in MySQL.

Week 6: Advanced Spring Boot Features

Introduction to Spring Boot security for API protection.

Implementing authentication and authorization (JWT or OAuth).

Configuring and handling transactional operations.

Hands-on Practice: Add authentication to your Spring Boot app.

Week 7: Integration with Front-End or Microservices

Integrating the backend with front-end frameworks like Angular or React.

Introduction to microservices architecture with Spring Boot.

Using Spring Cloud to manage microservices.

Hands-on Practice: Build a microservice that connects to a MySQL database.

Week 8: Deployment and Final Project

Preparing the Spring Boot application for production.

Deploying a Spring Boot app with MySQL using Docker or cloud platforms (e.g., AWS, Heroku).

Final Project: Develop an end-to-end web application (e.g., inventory management, employee management system, or e-commerce platform)