|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-basic-queries-and-integration-full-stack-with-spring-boot/
课程评论：没有评论
课程名称：PostgreSQL基本查询与Spring Boot集成 课程概述： 该课程旨在教授PostgreSQL查询及其与其他关系型数据库管理系统（如Oracle和MySQL）的差异。学员将逐步实现一个示例项目，以便轻松掌握相关知识。课程内容包括多个技术，如Liquibase（数据库迁移工具）、Hibernate（与数据库的对象关系映射）以及REST API（RESTful协议端点API）。所有的项目将基于Java 8+进行实现。 课程重点： - 学习如何开始课程和项目结构。 - 使用Spring Boot、PostgreSQL 和Liquibase创建一个新项目，实施增删查改（CRUD）操作，项目为待办事项应用。 - 用户登录、注册和待办事项管理功能，包含基于角色的应用（用户和管理员）。 - 服务器端使用Spring Boot实现Model-View-Controller（MVC）结构，包含实体类、仓库、服务和控制器的创建。 - 使用PostgreSQL作为数据库，执行基本的数据库操作，包括创建、更新和选择操作，以及处理数据类型和自增字段。 - 通过Java持久化API和Hibernate进行对象关系映射，使用JPA和Crud Repository处理通用数据库操作。 - 使用Lombok库简化代码编写，避免手动实现getter、setter、equals和hash代码。 - 使用Gradle管理服务器端的依赖。 - 在客户端使用Postman测试Spring Boot创建的端点，并处理授权和基本HTTP方法。 该课程通过系统的步骤指导，确保每位学员都能掌握所需技能，并理解项目架构的全貌。
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 APIWe 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.
