|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/intro-db-app-dev-springboot-angular/
课程评论：没有评论
课程名称：使用 Spring Boot、Angular 和 Postgres 的数据库应用开发入门 课程概述： 本课程旨在教授学员如何开发具有关系数据库后端的企业应用程序，使用 Java Spring Boot 作为中间层 web 服务，以及基于 Angular/Typescript 的客户端用户界面应用。课程将展示如何构建一个完整的三层应用程序，操作单个数据库表，并为一个演示的航空调度应用设计和构建日益复杂的表和视图架构。未来的高级课程将在此基础上扩展 web 服务和客户端 UI 应用，使其能够在演示应用架构的所有表上操作，并导航它们之间的关系，包括标识和非标识外键、一对多 (1:M) 和多对多 (M:N) 关系、关联/交叉引用实体及基于集合的业务规则。 课程假设学员具备基本的 Java、HTML 和 SQL 知识，但将从零开始讲解 Spring Boot、Maven、Angular/Typescript、ER/Studio 和 PostgreSQL。本课程源于作者2012年的书籍《Java Web Database Application Development》，并基于近30年的实际职业经验。它是作者希望在学习过程中能接触到的课程内容。 主要内容包括： - 演示应用：“FBOAce” 航空调度系统 - Spring Boot 的基础知识 - Maven 的入门 - H2 内存数据库 - Java 持久性 API (JPA) - Web 服务架构：组件（控制器、服务、仓库） - 依赖注入和自动装配 - JSON、Postman 和异常处理 - 输入验证及独立于技术的客户端 UI - Angular/Typescript 的基础知识 - PostGreSQL 使用及其管理工具 - 关系数据库设计理论与实践 本课程将覆盖各个方面的知识，从基本概念到具体实施，帮助学员建立一个能够实际运用的完整应用程序。
Learn to develop enterprise applications with a relational database back end, a Java Spring Boot webservice middle tier and an Angular/Typescript client user interface app.This introductory course demonstrates building out a complete 3-tier application operating upon one single database table; then designing and building an increasingly sophisticated schema of tables and views for a demo Aviation scheduling app. Future advanced courses based on this one will flesh out the webservice and client UI apps to operate upon all of the tables in the demo app schema and navigate their relationships: Identifying and non-identifying foreign keys; One-to-many (1:M) and Many-to-Many (M:N) relationships; associative/cross-reference entities; set-based business rules.This course assumes some basic knowledge of Java, HTML and SQL but will take you from Zero on Spring Boot, Maven, Angular/Typescript, ER/Studio and PostgreSQL.The course is evolved from my 2012 book "Java Web Database Application Development" and is based on nearly 30 years of real-world, hands-on professional experience. It is the course I WISH I could have taken when I needed to learn this stuff.TOPICS INCLUDE:Demo App: "FBOAce" Aviation Scheduling SystemSpring BootSpring Boot 101 / Hello WorldMaven 101H2 In-memory databaseJava Persistence API (JPA)Data Model Entity Beans, a.k.a. Data Transfer Objects and JPA AnnotationsWebservice architecture: Components (Controllers, Services, Repositories)Inversion of Control, Dependency Injection, AutowiringJSONPostmanException HandlingInput validationClient UI HTML independent of technologyAngular/Typescript:Angular 101 / Hello WorldNode, npm, Angular cling serveModules and componentsEssential Angular directories, files and/or components:src/main.ts, src/index.html, src/app/app-module.ts, src/app/app.component.ts/html/cssTypescript imports, @NgModule, export class, @Component decorator…Calling webservices with HttpClientStrict ModeReading Configuration Parameters (from json file)Data Types, Modifiers and Scopeconstructor() and injectionClass MethodsngOnInit() and other Lifecycle methodsTypescript Data Types (most common): Primitives, Arrays, Objects (instances of Classes or Interfaces), any and unknown, EnumsExplict vs. Implicit Declarationsasync, await() and PromiseData binding: 1-way, 2-wayStructural Directives: *ngIf (boolean), *ngFor (loop)Routing: , ActivatedRoute, the routerLink DirectiveString interpolationProperty BindingEvent BindingThe Home component and application componentsListing instances of business entities / database recordsTemplate-based forms: Editing and submitting instances of business entitiesObservablesAsynchronous programingPromises and Observable.toPromise()Local ReferencesPostGreSQL 101InstallationUsing PgAdmin to navigate databases, schemas, tables, views and moreUsing psql (command-line tool)Application data queries and metadata queriesCasE sEnsiTIVity in PostGreSQLExecuting DDL to create schema objectsPostgreSQL PL/pgSQL Programming: Trigger functions and triggers that call the functions"Instead-of" triggers on API ViewsRelational Database Design, Theory and PracticeSchema Design (for complete/advanced demo app) and SQL DDL (data definition language statements)Logical and Physical Data ModelsER Studio DemoAttributes/ColumnsPrimary keys, alternate unique indexesIdentifying and non-identifying relationships/foreign keysOne-to-many (1:M) and Many-to-Many (M:N) relationships; Associative/cross-reference entitiesMultiple relationships between/among the same entities"Super" unique keysSQL data typesSet-based business rule facilitation and enforcementDatabase (API) views and the "driving" tableAnd more!
