Track 05
Databases Storage And Caching
Store, retrieve, cache, and test application data with PHP.
Lessons
- SQL Overview
- SQLite For Learning Examples
- PDO
- DSNs And Connections
- Prepared Statements
- Fetch Modes
- Error Handling
- Transactions
- ACID Transactions Overview
- ACID: Atomicity
- ACID: Consistency
- ACID: Isolation
- Transaction Isolation Levels And Concurrency Problems
- ACID: Durability
- Database Normalization
- Denormalization And Practical Tradeoffs
- Schema Design Basics
- Migrations Overview
- MySQL And MariaDB For Application Projects
- PostgreSQL For Application Projects
- Database GUI Tools
- Query Performance
- Database Security
- Database Test Scenarios And Fixtures
- Database Seeding And Factories Orientation
- Doctrine DBAL Orientation
- ORM Orientation: Doctrine ORM And Laravel Eloquent
- MySQLi Overview
- PDO vs MySQLi
- Persistent Connections
- Redis Overview
- Memcached Overview
- APCu Object Caching
- Filesystem Cache
- Object Storage Orientation: S3-Compatible Storage
- Search Orientation
- Elasticsearch And Apache Solr For Application Search
- NoSQL Database Models And Selection Tradeoffs
- MongoDB For PHP Applications
- Session Storage Backends
- HTTP Cache Headers
- Cache Invalidation Basics
- PSR-6 Cache Pools
- PSR-16 Simple Cache