What you would learn in Intro to Database App Dev w/Spring Boot, Angular, Postgres course?
Learn to create enterprise-level apps using a relational database backend and a Java Spring Boot middle-tier of web services, and a Typescript/Angular client-user interface application.
This introduction course shows how to build an entire 3-tier app based on a single database table. It also demonstrates developing and building an increasingly complex table and view schema for a live demonstration Aviation scheduling application.
Future advanced courses based on this one will flesh out the web service 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: M) relationships; associative/cross-reference entities; set-based business rules.
This course is based on a basic understanding of Java, HTML, and SQL; however, it will take you to Zero to spring Boot, Maven, Angular/Typescript, ER/Studio, and PostgreSQL.
The course was developed from my guidebook, "Java Web Database Application Development, " based on more than 30 years of real-world personal experience. This is the course that I would have taken when I had to understand this technology.
Demo App: "FBOAce" Aviation Scheduling System
Spring Boot 101 / Hello World
H2 Database in-memory
Java Persistence API (JPA)
Data Model Entity Beans, a.k.a. Data Transfer Objects as well as JPA Annotations
Web service architecture Components (Controllers Services, Controllers, and Repositories)
Inversion of Control Dependency Injection Autowiring
Client UI HTML is independent of the technology
Angular 101 / Hello World
Node, NPM, Angular, the cli
Modules and components
Essential Angular directories, files and/or components:src/main.ts, src/index.html, src/app/app-module.ts, src/app/app.component.ts/html/css
Typescript imports, @NgModule, export class, @Component decorator...
Webservices can be called using HttpClient.
The Reading Configuration Parameters (from JSON file)
Modifiers, Types of Data, and Scope
construction() and inject
The ngOnInit() and the other Lifecycle methods
Typescript Data Types (most frequent) Primitives such as Arrays, Objects (instances of Interfaces or Classes), Unknown, all Enums
Explict vs. Implicit declarations
async, wait() and promise
Data binding: 1-way 2-way
Structural Directives • *ngIf (boolean) *ngFor (loop)
Routing: ActivatedRoute, the router link Directive
The Home component and the application components
Business entities are listed in the form of listing instances and Database records.
Template-based forms: editing and submitting forms for business entities
Promises and Observable.toPromise()
Utilizing PgAdmin to navigate tables, databases, schemas, tables views, and much more
Utilizing the psql (command-line tool)
Application data queries and metadata queries
CasE sEnsiTIVity within PostgreSQL
Running DDL for schema object creation
PostgreSQL Programming with PL/pgSQL Triggers, triggers, and functions that invoke the functions
"Instead-of" triggers on API Views
Design of Relational Databases Practice, Theory, and Theory
Schema Design (for complete/advanced demo application) along with SQL DDL (data definition language statements)
Physical and Logical Data Models
ER Studio Demo
Primary keys, alternate unique indexes
Identifying and non-identifying relationships/foreign keys
One-to-many (1:M) and Many-to-Many (M:M) relationships; Associative/cross-reference entities
Multiple relationships between or among the same entities
"Super" unique keys
SQL data types
Facilitation of business rules based on set-based models and enforcement
Views of Database (API) views as well as"driving" table "driving" table
And much more!
- Create Enterprise applications with Spring Boot REST Webservices, relational database, and Typescript/Angular
- Java Spring Boot
- Design of databases as well SQL DDL, DML
Download Intro to Database App Dev w/Spring Boot, Angular, Postgres from below links NOW!