Download Intro to Database App Dev w/Spring Boot, Angular, Postgres

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.

TOPICS Include:

Demo App: "FBOAce" Aviation Scheduling System

Spring Boot

Spring Boot 101 / Hello World

Maven 101

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

JSON

Postman

Exception Handling

Input validation

Client UI HTML is independent of the technology

Angular/Typescript:

Angular 101 / Hello World

Node, NPM, Angular, the cli

Ng serves

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.

Strict Mode

The Reading Configuration Parameters (from JSON file)

Modifiers, Types of Data, and Scope

construction() and inject

Class Methods

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

String interpolation

Property Binding

Event Binding

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

Observables

Asynchronous programming

Promises and Observable.toPromise()

Local References

PostGreSQL 101

Installation

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

Attributes/Columns

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!

Course Content:

• Create Enterprise applications with Spring Boot REST Webservices, relational database, and Typescript/Angular
• Java Spring Boot
• Angular/Typescript
• Design of databases as well SQL DDL, DML

Download Intro to Database App Dev w/Spring Boot, Angular, Postgres from below links NOW!