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

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