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

Explore Spring Boot fundamentals, confirm Java installation, and follow the quickstart with variations, including Spring initialization, while understanding Maven's role in managing, building, and deploying Spring Boot projects.

Spring Boot simplifies bootstrapping applications built on the Spring Framework, reduces boilerplate through dependency injection and inversion of control, and supports swapping JPA or Hibernate derivatives via the same interface.

Learn to start a Spring Boot project with the spring.io quickstart, choose Maven, optionally Gradle, pick a Java version, then generate a hello world app ready to run.

Follow the Spring Boot quickstart to run the app via platform-specific commands, start Tomcat on port 1880, and verify the server is running before endpoints are mapped.

Explore Spring Boot quickstart project structure, including root directory, target with jars, and the Maven pom.xml managing dependencies like Spring Boot Starter Web and Spring Boot Starter Data JPA.

Master spring boot quickstart by configuring the application directory, test and main branches, and properties for port 8082 and mappings; build a hello world rest controller with dispatcher servlet routing.

Explore the Spring Boot quickstart by creating a new project, initializing it, and running it from the command line while separating the app from its controllers for clarity.

Learn how maven integrates with your IDE and how re-importing maven projects in IntelliJ or updating the project in Eclipse fixes missing dependencies and red errors.

Embrace Maven's convention over configuration by learning the default directory structure: src/main/java, src/main/resources (static, templates, html files, application properties), and src/test/java.

Learn how Maven coordinates—groupId, artifactId, version, and packaging—along with dependency scopes, manage your project and its libraries, using the pom.xml and the effective pom in Spring Boot projects.

Discover how Maven plugins drive the build lifecycle, from the compiler and clean plugins to release and deploy, and learn to view the effective palm to see all plugin executions.

Explore Maven archetypes to scaffold new apps quickly, using mvn archetype:generate or your IDE's new project wizard in IntelliJ or Eclipse, with filtering options like web or Spring.

Explore Maven basics, including the project object model, dependency management, life cycles, and multi module projects, with recommended resources for deeper study.

Get a quick peek at JPA integration by extending a DTO with JPA annotations, creating an entity and repository, and using CRUD repository methods for create, read, update, and delete.

Create a JPA entity from the DTO aircraft type by annotating it with @Entity, @Table, @Id, @GeneratedValue, and @SequenceGenerator to map fields to database columns.

GP repositories map GP entities to CRUD statements against tables. Extend a JPA aircraft type repository from the Spring Framework Library; auto wired and use save and find by ID.

Examine the service layer by defining an aircraft type service interface and a JPA implementation that uses a repository to find all, find by id, save, and delete, using DTOs.

Explains how the aircraft type rest controller uses class-level and method-level mappings for get, post, put, and delete. Shows using a service, response entities, and optional ID handling.

Learn to call a database service with postman and a browser, using get, put, post, and delete endpoints to manage aircraft type data in a Spring Boot H2 setup.

Implement global Spring Boot exception handling to translate SQL exceptions into user-friendly messages for browser-based clients, guiding users with clear feedback.

Build a client user interface against the FBOs database and web service with Angular, a JavaScript framework for reactive single-page apps that dynamically load only changing data.

Install Node JS and NPM to use the angular cli. The lecture demonstrates Windows GUI and Linux command line installation options for setting up the angular command line interface.

Install Node.js on Windows with a GUI installer, or use a command line package manager as on Linux, then verify installation with node --version and npm --version.

Install node.js on Linux using a package manager across Linux flavors, with the Red Hat example sudo dnf module install node.js 14, and verify using node -v and npm -v.

Develop an Angular app that fetches aircraft type data from a Spring Boot REST service, supports create, edit, delete, and routing between home, list, and edit views.

Complete the read-only Angular database app by finalizing the home component, which shows a button linking to the aircraft type records list via the router link.

Explore asynchronous programming with observables and promises, how the http client returns observables, and how subscribe, unsubscribe, and toPromise prevent memory leaks.

Explore Angular template-based forms to implement a data maintenance edit screen that inserts and updates business entity data via a web service, emphasizing the forms module import.

Examine the aircraft type edit component in an Angular app, detailing its TypeScript class, create versus update via HTTP post and put, and two-way data binding with ngModel.

Install PostgreSQL and explore pgAdmin and the SQL command line interface. Prepare for schema design with DDL, creating tables, indexes, primary keys, and foreign keys across Windows, Mac, and Linux.

Install PostgreSQL on Windows by downloading the Windows x86_64 installer from postgresql.org, set a data directory, create a password, select English United States locale, and finish after skipping Stack Builder.

Design the database schema and ddl to create all objects for the aviation scheduling demo app, laying the foundation for later web service and ui development.

Explore schema design with a logical data model for aircraft type and aircraft, detailing identifying relationships, inherited keys, and unique constraints to support a Spring Boot and Angular database app.

Transform the logical data model into a physical model tailored for postgres by generating a physical schema, validating, and inspecting tables, keys, and data types.

Generate PostgreSQL DDL from a complete physical data model, producing create table statements, primary and foreign keys, constraints, and indexes, with an interactive wizard and SQL preview.

Execute PostgreSQL DDL in pgAdmin to clean the schema, set the search_path, run a SQL script, manage dependencies and foreign keys, and verify tables before continuing app development.

Discover why PostgreSQL triggers matter for data integrity and derived values, including before insert and instead of triggers on views, with PL/pgSQL examples generating aircraft IDs and flight identifiers.