mysql-db-course

University DB course (mysql + java)

Lab1

Description:

Creating DB schema

Lab 2

Description:

Writing 10 sql queries

Lab 3

Description:

Creating sql script for schema from Lab1

Lab 4

Description:

CRUD for DB from Lab1,3 (using JDBC)

Lab 5

Description:

CRUD for DB from Lab1,3 (using Hibernate)

Lab 6

Description:

CRUD for DB from Lab1,3 (using Spring Boot)

Running:

UI to use CRUD operations: http://localhost:8080/swagger-ui.html

P.S. Port can be set up in Lab6/src/main/resources/application.yml

Lab 7

Description:

Create triggers, user functions and stored procedures