Google Cloud Spanner Training
Introduction to Google Cloud Spanner
Learn about Google Cloud Spanner, a fully managed, scalable, and distributed relational database service. Understand its core features, including global distribution, horizontal scaling, and strong consistency.
Setting Up Google Cloud Spanner
Explore the steps to set up Google Cloud Spanner. Learn how to create and configure Spanner instances, databases, and tables, and understand the basics of Spanner’s data model and schema design.
Schema Design and Data Modeling
Study best practices for designing schemas and modeling data in Google Cloud Spanner. Learn about primary keys, interleaved tables, and optimizing your schema for performance and scalability.
Managing and Querying Data
Discover how to manage and query data in Google Cloud Spanner. Learn about SQL support, executing queries, and using transaction management features to ensure data consistency and integrity.
Scaling and Performance Optimization
Understand how to scale your Spanner database and optimize performance. Learn about partitioning, indexing, and query optimization techniques to handle large datasets and high-throughput workloads.
Backup and Recovery
Learn about backup and recovery options in Google Cloud Spanner. Explore strategies for backing up your data, restoring from backups, and ensuring data durability and availability.
Integration with Google Cloud Services
Explore how to integrate Google Cloud Spanner with other Google Cloud services. Learn about using Spanner with Google Cloud Dataflow, BigQuery, and other tools to enhance data processing and analytics.
Security and Access Control
Understand the security features and access control mechanisms in Google Cloud Spanner. Learn about managing user permissions, data encryption, and securing your database environment.
Monitoring and Troubleshooting
Learn techniques for monitoring and troubleshooting your Spanner instances. Explore tools and best practices for tracking performance metrics, diagnosing issues, and maintaining database health.
Hands-On Labs and Projects
Engage in hands-on labs and projects to apply your Google Cloud Spanner skills. Work on real-world scenarios to gain practical experience in managing, querying, and optimizing Spanner databases.
Google Cloud Spanner syllabus
1. Introduction to Cloud Spanner
- Overview of Cloud Spanner and Its Use Cases
- Financial Services
- Gaming Industry
- Retail and E-Commerce
- Global Applications
- Comparison with Other Database Products
- Planning and Setting Up Spanner Instances
- Instance Configuration
- Budget and Cost Management
2. Creating and Managing Databases
- Creating Spanner Databases Using the Google Cloud Console, CLI, and Terraform
- Database Schema Design and Optimization
- Understand Your Data Model
- Normalized vs. Denormalized Schema
- Foreign Keys and Indexes
- Managing Relationships with Primary Keys, Foreign Keys, and Interleaved Tables
3. Querying and Programming
- Using the Cloud Spanner API
- Database Management
- Data Manipulation
- Transactions
- Monitoring and Logging
- Authenticating and Authorizing Users and Applications
- Identity and Access Management (IAM)
- OAuth 2.0 and API Keys
- Access Control Lists (ACLs)
- Running Queries and Managing Transactions
- Executing SQL Queries
- Query Optimization
- Parameterized Queries
- Optimizing Queries with Indexes and Understanding Read Consistency Models
4. Application Integration
- Integrating Cloud Spanner with Applications Using Client Libraries (e.g., Python)
- Deploying Applications with Cloud Functions and Cloud Run
- Data Migration Using Dataflow and Apache Beam
- Dataflow and Apache Beam
- Source and Destination Connectors
- Batch and Streaming Migration
- Schema Transformation and Validation
5. Administration and Monitoring
- Administering Spanner Instances (Backup, Restore, Import, Export)
- Monitoring Databases and Applications
- Database Monitoring
- Application Monitoring
- Capacity Planning and Scalability
- Managing Changes to Database Schemas Without Downtime
6. Advanced Schema Design
- Best Practices for Schema Design
- Optimizing Schemas for Performance and Scalability
- Using Interleaved Tables and Secondary Indexes Effectively
7. Query Optimization
- Advanced Query Execution Plans
- Index Usage and Maintenance
- Techniques for Optimizing Complex Queries
8. Data Modeling
- Modeling Hierarchical Data
- Managing Large Datasets
- Best Practices for Data Partitioning and Sharding
9. Transaction Management
- Deep Dive into Spanner's Consistency Models
- Advanced Transaction Isolation Levels
- Managing Multi-Region Transactions
10. Performance Tuning
- Monitoring and Diagnosing Performance Issues
- Tuning Spanner Instances and Configurations
- Utilizing Query Execution Statistics
11. Security and Compliance
- Implementing Advanced Security Features
- Managing Roles and Permissions
- Ensuring Compliance with Data Protection Regulations
12. Backup and Recovery
- Strategies for Effective Backup and Restore
- Implementing Disaster Recovery Plans
- Using Spanner's Native Backup Capabilities
13. Integration and Migration
- Integrating Spanner with Other Google Cloud Services
- Migrating from Other Databases to Spanner
- Using Dataflow and Other Tools for Data Movement
14. Use Cases and Patterns
- Real-World Use Cases of Spanner
- Design Patterns for Common Applications
- Case Studies and Success Stories
Training
Basic Level Training
Duration : 1 Month
Advanced Level Training
Duration : 1 Month
Project Level Training
Duration : 1 Month
Total Training Period
Duration : 3 Months
Course Mode :
Available Online / Offline
Course Fees :
Please contact the office for details