BiteSizedChunks.comLearn one small thing at a time.

Course contentsShow

Cloud and Infrastructure

396Introduction to Managed Relational Databases
397RDS Architecture and Components
398Supported Database Engines
399Database Instance Classes
400Storage Types for RDS
401Storage Autoscaling
402Creating and Launching RDS Instances
403Database Parameter Groups
404Option Groups for Engine Features
405Subnet Groups and Network Placement
406Security Groups for Database Access
407Database Authentication Methods
408Encryption at Rest
409Encryption in Transit
410Database Monitoring and Metrics
411Enhanced Monitoring
412Performance Insights
413Maintenance Windows and Updates
414RDS High Availability Overview
415Multi-AZ Deployments Fundamentals
416Multi-AZ Failover Process
417Multi-AZ vs Single-AZ Trade-offs
418Read Replicas for Scalability
419Read Replica Lag and Consistency
420Promoting Read Replicas
421Cross-Region Read Replicas
422Automated Backup Configuration
423Point-in-Time Recovery
424Manual Snapshots and Retention
425Snapshot Copying and Sharing
426Backup Storage and Costs
427Restoring from Backups
428Backup and HA Testing
429NoSQL Database Categories and Use Cases
430DynamoDB: Fundamentals and Data Model
431DynamoDB Primary Keys and Partition Keys
432DynamoDB Capacity Modes: Provisioned vs On-Demand
433DynamoDB Secondary Indexes: GSI and LSI
434DynamoDB Streams and Change Data Capture
435DynamoDB Global Tables for Multi-Region
436Azure Cosmos DB: Architecture and APIs
437Cosmos DB Consistency Levels
438Cosmos DB Partitioning and Request Units
439Cosmos DB Change Feed and Global Distribution
440Google Cloud Firestore and Datastore
441Cloud Bigtable for Wide-Column Storage
442DocumentDB and MongoDB-Compatible Services
443Keyspaces and Cassandra-Compatible Services
444NoSQL Backup, Point-in-Time Recovery, and TTL
445NoSQL Performance Optimization and Best Practices
446Database Performance Metrics and Monitoring
447Query Performance Analysis Fundamentals
448Index Design and Strategy
449Query Optimization Techniques
450Connection Pooling and Management
451Database Parameter Tuning
452Read Replicas for Performance Scaling
453Caching Strategies for Databases
454Database Storage Performance
455Partitioning and Sharding Strategies
456Performance Insights and Diagnostics Tools
457Monitoring and Alerting for Performance
458Cost vs Performance Trade-offs
459Performance Testing and Benchmarking

Cloud and Infrastructure

396Introduction to Managed Relational Databases
397RDS Architecture and Components
398Supported Database Engines
399Database Instance Classes
400Storage Types for RDS
401Storage Autoscaling
402Creating and Launching RDS Instances
403Database Parameter Groups
404Option Groups for Engine Features
405Subnet Groups and Network Placement
406Security Groups for Database Access
407Database Authentication Methods
408Encryption at Rest
409Encryption in Transit
410Database Monitoring and Metrics
411Enhanced Monitoring
412Performance Insights
413Maintenance Windows and Updates
414RDS High Availability Overview
415Multi-AZ Deployments Fundamentals
416Multi-AZ Failover Process
417Multi-AZ vs Single-AZ Trade-offs
418Read Replicas for Scalability
419Read Replica Lag and Consistency
420Promoting Read Replicas
421Cross-Region Read Replicas
422Automated Backup Configuration
423Point-in-Time Recovery
424Manual Snapshots and Retention
425Snapshot Copying and Sharing
426Backup Storage and Costs
427Restoring from Backups
428Backup and HA Testing
429NoSQL Database Categories and Use Cases
430DynamoDB: Fundamentals and Data Model
431DynamoDB Primary Keys and Partition Keys
432DynamoDB Capacity Modes: Provisioned vs On-Demand
433DynamoDB Secondary Indexes: GSI and LSI
434DynamoDB Streams and Change Data Capture
435DynamoDB Global Tables for Multi-Region
436Azure Cosmos DB: Architecture and APIs
437Cosmos DB Consistency Levels
438Cosmos DB Partitioning and Request Units
439Cosmos DB Change Feed and Global Distribution
440Google Cloud Firestore and Datastore
441Cloud Bigtable for Wide-Column Storage
442DocumentDB and MongoDB-Compatible Services
443Keyspaces and Cassandra-Compatible Services
444NoSQL Backup, Point-in-Time Recovery, and TTL
445NoSQL Performance Optimization and Best Practices
446Database Performance Metrics and Monitoring
447Query Performance Analysis Fundamentals
448Index Design and Strategy
449Query Optimization Techniques
450Connection Pooling and Management
451Database Parameter Tuning
452Read Replicas for Performance Scaling
453Caching Strategies for Databases
454Database Storage Performance
455Partitioning and Sharding Strategies
456Performance Insights and Diagnostics Tools
457Monitoring and Alerting for Performance
458Cost vs Performance Trade-offs
459Performance Testing and Benchmarking

← Cloud and Infrastructure

Lesson 449 of 2,989·8. Managed DatabasesPro lesson

Query Optimization Techniques

Master techniques like query rewriting, joins optimization, and avoiding full table scans.

This lesson is for subscribers

You've completed the free preview. Subscribe to unlock every lesson in every course.

See pricing Back to course