PostgreSQL Basic Queries And Integration With Spring Boot

PostgreSQL Basic Queries And Integration With Spring Boot, available at $44.99, has an average rating of 3.8, with 33 lectures, based on 13 reviews, and has 113 subscribers.

You will learn about PostgreSQL integration with Spring Boot PostgreSQL basic differences from other RDBMS An example Project with Spring Boot And PostgreSQL This course is ideal for individuals who are All developers curious about PostgreSQL It is particularly useful for All developers curious about PostgreSQL.

Enroll now: PostgreSQL Basic Queries And Integration With Spring Boot

Summary

Title: PostgreSQL Basic Queries And Integration With Spring Boot

Price: $44.99

Average Rating: 3.8

Number of Lectures: 33

Number of Published Lectures: 33

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 33

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

PostgreSQL integration with Spring Boot

PostgreSQL basic differences from other RDBMS

An example Project with Spring Boot And PostgreSQL

Who Should Attend

All developers curious about PostgreSQL

Target Audiences

All developers curious about PostgreSQL

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction – Architecture Of All System

Chapter 2: Preparation

Lecture 1: Source Code

Lecture 2: Install Java 11

Lecture 3: Install PostgreSQL

Lecture 4: Install Intellij

Lecture 5: Install Postman

Lecture 6: Install Lombok

Lecture 7: Lombok Overview

Lecture 8: Spring Boot Overview

Chapter 3: Implementation

Lecture 1: Overview

Lecture 2: Installation

Lecture 3: Configuration

Lecture 4: Hibernate Overview

Lecture 5: User Model Class Implementation

Lecture 6: TodoItem Model Class Implementation

Lecture 7: Liquibase Overview

Lecture 8: Liquibase Implementation For Model Classes Metadata

Lecture 9: Java Persistence API (JPA) Repository Overview

Lecture 10: Jpa Repository Implementation

Lecture 11: User Service Implementation

Chapter 4: Spring Security Implementation

Lecture 1: Spring Security Overview

Lecture 2: User Details Service Implementation

Lecture 3: Spring Security Default Configuration Overview

Lecture 4: Authentication In Spring Security

Lecture 5: Authorization In Spring Security

Lecture 6: Web Security Configuration

Chapter 5: Rest Controller And Test With Postman

Lecture 1: Rest Controller Overview

Lecture 2: User Controller Implementation

Lecture 3: Test User Endpoints With Postman

Lecture 4: Admin Controller Implementation

Lecture 5: TodoItem Service Implementation

Lecture 6: TodoItem Controller Implementation And Test With Postman

Chapter 6: Result

Lecture 1: Source Code

Instructors

Senol Atac
Software Architect

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 3 votes

4 stars: 7 votes

5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!