Databases

Table of Contents

Exercise

Also there’s an interactive tutorial here at https://sqlbolt.com/ So you can skip the hassle of setting it up yourself and jump to the interesting part :)

Tags

  1. Different ways of loading data into databases at spring application start-up?
  2. Database Optimizations in Java applications
  3. AWS DynamoDB
  4. Dao pattern
  5. Data modeling
  6. Databases - GUI clients
  7. Database Normalization
  8. Evolutionary Database Design and Database automigrations
  9. GoLang - Working with databases
  10. JDBC
  11. JPA - Jakarta Persistence API
  12. MongoDB
  13. Optimistic locking vs pessimistic record locking
  14. ORM
  15. SQL Constraints
  16. SQL Cursors
  17. SQL injection
  18. SQL Nolock
  19. SQL queries
  20. SQL Stored Procedures
  21. SQL Views
  22. SQL vs NoSQL
  23. Spring Data JPA
  24. Spring Data JPA - transactions
  25. How databases store passwords securely
  26. Managing entity associations, relationships and updates in applications
  27. Lost Update in Database Systems
  28. Spring Data

KNOWLEDGE GAP - IMPLEMENT THESE

  1. Do POCs with these databases: CouchDB and Cassandra DB.
  2. https://www.dbvis.com/thetable/database-transactions-101-the-essential-guide/
  3. https://www.geeksforgeeks.org/transaction-isolation-levels-dbms/

Links to this note