PostgreSQL Basic Queries And Integration With Spring Boot

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

3.80 (13 reviews)
Udemy
platform
English
language
Databases
category
instructor
107
students
3 hours
content
Jun 2023
last update
$44.99
regular price

What you will learn

PostgreSQL integration with Spring Boot

PostgreSQL basic differences from other RDBMS

An example Project with Spring Boot And PostgreSQL

Description

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.

Content

Introduction

Introduction - Architecture Of All System

Preparation

Source Code
Install Java 11
Install PostgreSQL
Install Intellij
Install Postman
Install Lombok
Lombok Overview
Spring Boot Overview

Implementation

Overview
Installation
Configuration
Hibernate Overview
User Model Class Implementation
TodoItem Model Class Implementation
Liquibase Overview
Liquibase Implementation For Model Classes Metadata
Java Persistence API (JPA) Repository Overview
Jpa Repository Implementation
User Service Implementation

Spring Security Implementation

Spring Security Overview
User Details Service Implementation
Spring Security Default Configuration Overview
Authentication In Spring Security
Authorization In Spring Security
Web Security Configuration

Rest Controller And Test With Postman

Rest Controller Overview
User Controller Implementation
Test User Endpoints With Postman
Admin Controller Implementation
TodoItem Service Implementation
TodoItem Controller Implementation And Test With Postman

Result

Source Code

Screenshots

PostgreSQL Basic Queries And Integration With Spring Boot - Screenshot_01PostgreSQL Basic Queries And Integration With Spring Boot - Screenshot_02PostgreSQL Basic Queries And Integration With Spring Boot - Screenshot_03PostgreSQL Basic Queries And Integration With Spring Boot - Screenshot_04

Reviews

Robert
July 23, 2023
This is a *** brilliant course *** and the lecturer really knows the subject and can teach extremely well - however it is partially let down by the language delivery / pronounciation of the lecturer - meaning that some words and phrases are delivered with what appears to be a strong spanish accent making it difficult to sometimes understand immediately the full sentence for example 'Spring is prounounced as Sea Pring'. Nevertheless I am giving it 5 stars as the time spent understanding the meaning was well worth it. Given the limited 3 hours constraints (which is good in a way - I personally prefer compact courses) and the scope which is intended to cover 'basics, the tech stack used comprises some of the key components one might expect to find in a real life production environment for Spring boot, including liquibase for data migration. It would be nice to have had an example of say multiple sql files inclusion in the liquibase section via use of e.g <includeAll path="db.changelog/scripts"/> in the changelog-master.xml or of how to do this with YAML. Returning to the main course topics - Springboot REST, JPA, MVC structure, Database Migration control , testing with POSTMAN etc. This is one of the ** best compact courses ** I've come across for the above subjects so I really like it. The lecturer is technically brilliant. As already mentioned I think the course has probably been underrated by the lecturers accent. If the lecturer could remedy this - even via the transcript, then the course would probably appeal to a much wider audience. I am looking forward to completing this course and I am grateful to the lecturer for creating it.

Charts

Price

PostgreSQL Basic Queries And Integration With Spring Boot - Price chart

Rating

PostgreSQL Basic Queries And Integration With Spring Boot - Ratings chart

Enrollment distribution

PostgreSQL Basic Queries And Integration With Spring Boot - Distribution chart
2628528
udemy ID
10/28/2019
course created date
2/25/2020
course indexed date
Bot
course submited by