PostgreSQL Basic Queries And Integration With Spring Boot

PostgreSQL, Spring Boot, SQL, Hibernate, Liquibase, Partial Indexing, Nulls Last Ordering, Schema, TableSpaces

Hi there,

What you’ll learn

  • PostgreSQL integration with Spring Boot.
  • PostgreSQL basic differences from other RDBMS.
  • An example Project with Spring Boot And PostgreSQL.

Course Content

  • Introduction –> 1 lecture • 4min.
  • Preparation –> 8 lectures • 19min.
  • Implementation –> 11 lectures • 58min.
  • Spring Security Implementation –> 6 lectures • 39min.
  • Rest Controller And Test With Postman –> 6 lectures • 49min.
  • Result –> 1 lecture • 1min.

Auto Draft

Requirements

Hi there,

In this course, we will learn PostgreSQL queries and differences from other RDBMS (like oracle, mysql…). Also, we will learn the example integration with Spring Boot. All project will be implemented step by step so to understand it wont be tough for anybody.

When we learn them, we will also learn lots of technologies…

Liquibase: Database migration tool.

Hibernate: Object Relational Mapping with database.

Rest API: Restful Protocol endpoint API

We will go on with Java 8+

 

———————–

Hi guys,

 

In this lesson, we will talk about how we will go on in this course.

Also we talk about project structure that will be implemented in this course.

 

We will create a new project in this course.

And we will implement this project with using Spring Boot, PostgreSQL and Liquibase.

 

In our project, we will implement CRUD operations. And these CRUD operations will be requested from Postman.

Then This requests will be handled from Spring Boot.

 

Our project will be Todo List Application.

Our main operations will be user login, register and todo list.

Also, we will go on with role based application.

Our roles will be user and admin.

Users can create todo items.

Admins can see the all users.

And this all things will be provided with secure way in Spring Boot.

 

We will have two main components to implement our project.

These are server side and client side.

 

In Server Side:

 

Spring Boot will be main thing.

 

Model View Controller structure will be implemented with using Spring Boot.

 

Our MVC structure will work like that:

 

First of all, the entity classes will be created under model package.

 

Later, if model class is permanent, we will create a repository for it.

 

Then we will call repository from services.

 

Finally, we will call services from from controllers.

 

In Spring Boot, Data will be presented to client as API call so Spring Rest Controller will be used to handle it.

 

We will use PostgreSQL as Database.

 

We will see the basic operations in PostgreSQL. Like Create, update, select operations.

We will talk about database – schema relation.

We will talk about how we can handle auto_increment on PostgreSQL.

We will talk about data types in PostgreSQL.

 

We will also use Object Relational Mapping with Java Persistence API and Hibernate.

 

You know, We can map our database tables to objects with hibernate.

 

We will use JPA Repository and Crud Repository in Spring Boot.

So these repository templates will handle common database operations like save, update, find, delete.

 

With Spring Boot, we will also use Lombok library for clean code.

You know that we don’t want to implement getter, setter, equals and hash code. So we can escape it using Lombok @Data or @Value annotation.

 

We will use Gradle To handle all dependencies on server side.

 

That’s all about Server side.

 

Let’s talk about Client Side.

 

We will create endpoints with Spring boot.

And on Client Side, we will test these endpoints with Postman.

 

With Postman, we will handle Authorization and basic Http methods.

 

Ok. That’s all about our project architecture.

Thank you.

Get Tutorial