LaunchCode logo GIS DevOps
  • Installations
  • Pages
      1. Week 1 - Day 1: Welcome, Setup
      2. Week 1 - Day 2: Terminal, Shell, Git
      3. Week 1 - Day 3: Shell, Git, SQL
      4. Week 1 - Day 4: SQL, HTTP
      5. Week 1 - Day 5: HTTP, Docker
      1. Week 2 - Day 1: HTML, CSS, Browser DevTools
      2. Week 2 - Day 2: HTML/CSS Template, JavaScript Introduction
      3. Week 2 - Day 3: Programming Fundamentals, JavaScript, DOM
      4. Week 2 - Day 4: JS, DOM, Promises, AJAX
      5. Week 2 - Day 5: Promises, AJAX, HTTP
      1. Week 3 - Day 1: Java, OOP
      2. Week 3 - Day 2: Spring Boot, Controllers, Routes
      3. Week 3 - Day 3: Models, ORM (Hibernate)
      4. Week 3 - Day 4: Persistence, ORM Relationships
      5. Week 3 - Day 5: Review
      1. Week 4 - Day 1: Git, GitLab, IntelliJ, Refactoring, Unit Testing
      2. Week 4 - Day 2: Security, Test-driven development
      3. Week 4 - Day 3: Integration testing, dependency injection
      4. Week 4 - Day 4: Postgres, Spring Data, JPA, Hibernate
      5. Week 4 - Day 5: AJAX, Open Layers
      1. Week 5 - Project Week: Zika Mission Control
      1. Week 6 - Day 1: RESTful web services
      2. Week 6 - Day 2: Swagger REST framework
      3. Week 6 - Day 3: Intro to Elasticsearch
      4. Week 6 - Day 4: More Elasticsearch, Integrating ES with Spring
      5. Week 6 - Day 5: ES2015, ESLint, OpenLayers
      1. Week 7 - Project Week: Zika Mission Control Part 2
      1. Week 8 - Day 1: Intro to DevOps/AWS
      2. Week 8 - Day 2: More with AWS
      3. Week 8 - Day 3: 12 Factor Apps and Auto Scaling
      4. Week 8 - Day 4: Gradle, Continuous Integration
      5. Week 8 - Day 5: Sonarqube
      1. Week 9 - Project Week: Zika Mission Control Part 3
      1. Week 11 - Project Week: Zika Mission Control Part 4
      1. Week 12 - Day 3: Intro to Docker
      2. Week 12 - Day 4: OAuth 2.0
      3. Week 12 - Day 5: Certificates
      1. Walkthrough: Intro to AWS
      2. Walkthrough: RDS
      3. Client Certificates
      4. Deploy Zika Client to S3
      5. Walkthrough: Intro to Curl
      6. Walkthrough: Intro to Docker
      7. Walkthrough: Elasticsearch in Spring
      8. Walkthrough: Elasticsearch
      9. Walkthrough: Elasticsearch Part 2
      10. Walkthrough: ESLint Airwaze
      11. Walkthrough: Git and Gitlab
      12. Walkthrough: Gradle
      13. Walkthrough: Hashing and Salting Passwords
      14. Walkthrough: CI/CD With Jenkins
      15. Walkthrough: LaunchCart REST
      16. NGINX as a Proxy to Spring Apache Tomcat
      17. Visual OAuth
      18. Walkthrough: OpenLayers and jQuery
      19. Walkthrough: PostgreSQL
      20. Walkthrough: Sonarqube
      21. Walkthrough: Cars Demo - Spring Data, JPA, Hibernate
      22. Walkthrough: Spring Integration Tests
      23. Spring Postgres Integration
      24. Walkthrough: SwaggerUI via SpringFox
      25. Walkthrough: SwaggerUI
      26. Walkthrough: TDD
      27. Todo Tasks Deployment Single EC2
      28. Running a Java Application as a Linux Service
      29. Walkthrough: Unit Tests
      30. Walkthrough: Upgrading to Spring Boot 2.x
      31. Watch a Todo Tasks Deployment
      1. Studio: Airwaze
      2. Studio: AWS Devops Basics
      3. Scaling horizontally AutoScaling Group
      4. Studio: AWS RDS VPC
      5. Curl Studio
      6. Elasticsearch Query Studio
      7. Elasticsearch Queries Studio 2
      8. Studio: JUnit
      9. Studio: LaunchCart REST
      10. Studio: LaunchCart Part 1
      11. Studio: LaunchCart Part 2
      12. Studio: OpenLayers ES2015 Workshop
      13. Studio: Springfox and Swagger
      14. Studio: Test-Driven Development
      1. Project: Deploy Map Notes to a Single EC2
      2. Project: Map Notes API
      3. Project: Mapnotes API Jenkins Pipeline
      4. Project: Map Notes Backed by AWS RDS
      5. Project: Zika Client REST
      6. Project: Zika Client
      1. Installation: Essential Tooling & Configuration
      2. Installation: Docker
      3. Installation: Docker PSQL Container
      4. Installation: Docker PostGIS
      5. Installation: Docker Elasticsearch
      6. Installation: Docker Kibana
      7. Installation: Docker Jenkins
      1. Configuration: IntelliJ
      2. Configuration: IntelliJ - Runtime Configuration
      3. Configuration: Environment Variables - IntelliJ
      4. Configuration: Spring & Elasticsearch
      5. Configuration: Spring & Postgres
      6. Configuration: Visual Studio Code - ESLint
      1. Docker
  • Week 4 - Day 4: Postgres, Spring Data, JPA, Hibernate
    • Lesson Content
    • Walkthroughs
    • Studio
      • Additional Resources

Week 4 - Day 4: Postgres, Spring Data, JPA, Hibernate¶

Learning objectives for this module Day 4

Lesson Content¶

  • PostgreSQL Slides
  • Spring Data, JPA, Hibernate
  • Security - Injection Attack

Walkthroughs¶

  • Using PostgreSQL Walkthrough: PostgreSQL
  • Spring Data, JPA, Hibernate Walkthrough: Cars Demo - Spring Data, JPA, Hibernate

Studio¶

Complete the LaunchCart 2 Studio: LaunchCart Part 2.

Additional Resources¶

  • Postgres: Defining Schemas, Tables, Columns, Constraints…
  • Postgres: Writing SELECT Queries
  • Postgres: Inserting Data
  • Postgres: Complete Documentation (contains everything about Postgres, be sure to use search box)
  • Video Tutorial of psql commands
  • JPA Home Page
  • What is JPA and Hibernate
  • Hiberante Home Page
  • Spring Data Home Page
  • Spring Data JPA Home Page

Back to top