کتاب صوتی Google Cloud Platform: Cloud Spanner Database Setup and Management (for Global Financial Services)

🎓 دوره آموزشی جامع

📚 اطلاعات دوره

عنوان دوره: دوره Google Cloud Platform: Cloud Spanner Database Setup and Management (for Global Financial Services)

موضوع کلی: برنامه نویسی

موضوع میانی: Google Cloud Platform (GCP)

📋 سرفصل‌های دوره

• 1. Introduction to Google Cloud Platform for Enterprises
• 2. Understanding Google Cloud's Global Infrastructure
• 3. The Evolution of Databases: From Relational to Distributed
• 4. Introducing Cloud Spanner: A Globally Distributed Relational Database
• 5. Key Features and Benefits of Cloud Spanner
• 6. Why Cloud Spanner for Global Financial Services?
• 7. Cloud Spanner vs. Traditional RDBMS vs. NoSQL
• 8. GCP Projects, Organizations, and Resources Hierarchy
• 9. Identity and Access Management (IAM) Fundamentals
• 10. Managing IAM Roles and Permissions for Cloud Spanner
• 11. Introduction to Google Cloud Networking (VPC)
• 12. VPC Networks and Subnets for Secure Spanner Access
• 13. Understanding Google Cloud Billing and Cost Management
• 14. Spanner Pricing Model: Nodes, Storage, and Egress
• 15. Setting Up Your GCP Environment for Spanner Development
• 16. Spanner's Architecture: True Resilency and Scalability
• 17. Global Distribution and ACID Transactions
• 18. Synchronous Replication Across Regions
• 19. Strong External Consistency Guarantees
• 20. Sharding and Automatic Data Distribution
• 21. Understanding Spanner Instances, Databases, and Nodes
• 22. Read-Write and Read-Only Regions in Spanner
• 23. Choosing Between Regional and Multi-Regional Instances
• 24. Creating a Cloud Spanner Instance via GCP Console
• 25. Creating a Cloud Spanner Instance Using gcloud CLI
• 26. Creating a Cloud Spanner Instance with Terraform
• 27. Configuring Instance Nodes for Performance and Availability
• 28. Managing Instance Properties and Scaling Nodes
• 29. Connecting to Cloud Spanner: Client Libraries and SDKs
• 30. Using the Cloud Spanner Emulator for Local Development
• 31. Principles of Relational Database Design for Spanner
• 32. Understanding Schema Design Best Practices
• 33. Designing Primary Keys for Optimal Performance
• 34. The Concept of Interleaved Tables
• 35. Implementing Interleaved Tables for Child Records
• 36. Designing Secondary Indexes for Efficient Queries
• 37. Choosing Index Keys: Storing vs. Not Storing Columns
• 38. Preventing Hotspots: Key Sharding and Randomization
• 39. Data Types and Their Implications in Spanner
• 40. Enforcing Data Integrity: Constraints and Validators
• 41. Versioning Schemas and Managing Migrations
• 42. Handling Large Objects (LOBs) in Spanner
• 43. Entity-Relationship Modeling for Financial Systems
• 44. Cloud Spanner's SQL Dialect: Overview
• 45. Data Definition Language (DDL) for Schema Creation
• 46. Data Manipulation Language (DML) for Data Operations
• 47. Querying Data with SELECT Statements
• 48. Advanced Querying: Joins, Aggregations, and Subqueries
• 49. Understanding Query Execution Plans
• 50. Best Practices for Writing Efficient SQL Queries
• 51. Using Parameters in Queries to Prevent SQL Injection
• 52. Transactions in Cloud Spanner: Read-Write and Read-Only
• 53. Using ANALYZE and EXPLAIN for Query Optimization
• 54. Common SQL Anti-Patterns to Avoid
• 55. Strategies for Initial Data Loading into Spanner
• 56. Using Dataflow for Batch Data Ingestion
• 57. Real-time Data Ingestion with Pub/Sub and Dataflow
• 58. Migrating Data from Traditional Relational Databases
• 59. Migrating Data from Other Distributed Databases
• 60. Leveraging Cloud Spanner Change Streams (CDC)
• 61. Implementing CDC for Real-time Analytics and Replication
• 62. Handling Large-Scale Data Migrations with Minimal Downtime
• 63. Using Spanner Import/Export Service with Cloud Storage
• 64. Introduction to Google Cloud Monitoring
• 65. Monitoring Cloud Spanner Key Metrics (CPU, Latency, Throughput)
• 66. Setting Up Custom Dashboards for Spanner Performance
• 67. Configuring Alerts for Critical Spanner Metrics
• 68. Introduction to Google Cloud Logging
• 69. Analyzing Spanner Logs for Operational Insights
• 70. Exporting Logs to BigQuery for Advanced Analytics
• 71. Data Encryption in Cloud Spanner: At Rest and In Transit
• 72. Key Management with Cloud KMS for Spanner
• 73. Implementing Fine-Grained Access Control (FGAC)
• 74. Auditing Access and Changes with Cloud Audit Logs
• 75. Data Residency and Locality Requirements for Finance
• 76. Compliance with Regulatory Frameworks (PCI DSS, GDPR, SOX)
• 77. Secure Networking for Spanner: Private IP and VPC Service Controls
• 78. Data Masking and Tokenization Techniques for Sensitive Data
• 79. Best Practices for Securing Cloud Spanner Instances
• 80. Incident Response Planning for Spanner Databases
• 81. Understanding Cloud Spanner's Built-in High Availability
• 82. Defining RTO and RPO for Financial Applications
• 83. Automated Backups and Point-in-Time Recovery
• 84. Performing On-Demand Backups and Restores
• 85. Cross-Regional Failover Strategies with Multi-Regional Instances
• 86. Implementing a Disaster Recovery Plan for Spanner
• 87. Testing Your Disaster Recovery and Business Continuity Plan
• 88. Data Replication for Read Replicas and Analytics
• 89. Identifying Performance Bottlenecks in Spanner
• 90. Query Optimization Techniques and Best Practices
• 91. Index Tuning for Improved Read Performance
• 92. Understanding Transaction Conflicts and Retries
• 93. Strategies for Scaling Cloud Spanner Nodes
• 94. Connection Pooling and Client-Side Optimization
• 95. Batching Operations for Increased Throughput
• 96. Analyzing Hotspots and Re-sharding Strategies
• 97. Integrating Spanner with Google Cloud Data Studio for Reporting
• 98. Connecting Spanner to BigQuery for Data Warehousing and Analytics
• 99. Leveraging Cloud Functions for Event-Driven Spanner Operations
• 100. Using Pub/Sub for Asynchronous Event Processing with Spanner