Track 05

Databases Storage And Caching

Store, retrieve, cache, and test application data with PHP.

Lessons

  1. SQL Overview
  2. SQLite For Learning Examples
  3. PDO
  4. DSNs And Connections
  5. Prepared Statements
  6. Fetch Modes
  7. Error Handling
  8. Transactions
  9. ACID Transactions Overview
  10. ACID: Atomicity
  11. ACID: Consistency
  12. ACID: Isolation
  13. Transaction Isolation Levels And Concurrency Problems
  14. ACID: Durability
  15. Database Normalization
  16. Denormalization And Practical Tradeoffs
  17. Schema Design Basics
  18. Migrations Overview
  19. MySQL And MariaDB For Application Projects
  20. PostgreSQL For Application Projects
  21. Database GUI Tools
  22. Query Performance
  23. Database Security
  24. Database Test Scenarios And Fixtures
  25. Database Seeding And Factories Orientation
  26. Doctrine DBAL Orientation
  27. ORM Orientation: Doctrine ORM And Laravel Eloquent
  28. MySQLi Overview
  29. PDO vs MySQLi
  30. Persistent Connections
  31. Redis Overview
  32. Memcached Overview
  33. APCu Object Caching
  34. Filesystem Cache
  35. Object Storage Orientation: S3-Compatible Storage
  36. Search Orientation
  37. Elasticsearch And Apache Solr For Application Search
  38. NoSQL Database Models And Selection Tradeoffs
  39. MongoDB For PHP Applications
  40. Session Storage Backends
  41. HTTP Cache Headers
  42. Cache Invalidation Basics
  43. PSR-6 Cache Pools
  44. PSR-16 Simple Cache