Cloud Databases and Modern Data Storage Strategies (CLDB)

Databases, Data Analytics

This course explores cloud databases and modern data storage, with emphasis on practical use for analytics, reporting and application development. You will learn cloud storage basics, typical use cases, and how to select suitable database technologies.

The course stresses understanding cloud architecture, correct data design and hands-on work with both relational and NoSQL databases. Labs cover configuration, performance tuning and cost-aware operation; cloud fees for exercises are included.

THIS TRAINING COURSE WILL HELP YOU:

  • Understand on-premise vs cloud storage and design implications
  • Identify cloud database types: relational, NoSQL, analytical, object
  • Select the right database technology for reporting or analytics
  • Understand cloud scaling, availability and performance basics
  • Apply basic cloud data security: access control, encryption, backups

WHO SHOULD ATTEND?

  • Data analysts and reporting specialists
  • Developers and application architects working with databases
  • IT specialists migrating from on-premise to cloud environments
  • Technology managers and IT consultants deciding data architecture

COURSE LOCATION AND AVAILABLE DATES

Contact us

Unlock your employees' potential. We can adapt every course in our portfolio to your objectives and participants.
Need training at your premises or want to tailor the content and duration? We will prepare the right solution, in Czech or English.

Request customised training

Course content:

Hide details
  • Basics of cloud databases and data storage
    1. Basic concepts: cloud computing, IaaS vs. PaaS, database as a service (DBaaS)
    2. Typical cloud architectures and data handling in the cloud
    3. Differences between on-premise and cloud DB environments (operations, responsibilities, costs)
    4. Overview of database approaches: relational, NoSQL, analytical databases
    5. When to use relational vs NoSQL solutions (typical scenarios and examples)
    6. OLTP vs OLAP systems and their role in data architecture
    7. Databases for analytics and reporting (introduction to data warehouses)
    8. Object storage and its role in modern data architecture
    9. Basic principles of scaling databases in the cloud (vertical vs horizontal)
  • Basics of data security in the cloud
    1. Authentication, authorization, encryption
    2. Backup and recovery of data in cloud environments
  • Solution design and hands-on work with a cloud database
    1. Analysis of requirements for a database solution (data volume, performance, availability)
    2. Designing a database solution by application type and workload characteristics
    3. Choosing the right database technology for a specific use case
    4. Integrating cloud databases with applications
    5. Basic data operations in a cloud database
    6. Database performance: query optimization, indexes, handling large datasets
    7. Database monitoring and key operational metrics
    8. Cloud database pricing models and cost management
  • Practical demonstration
    1. Creating and configuring a cloud database
    2. Connecting an application or analytics tool to the database
    3. Working with relational and non-relational databases in a typical scenario
    4. Common design and operational mistakes in cloud databases
    5. Designing and deploying a cloud data architecture in Microsoft Azure
Prerequisites:
Basic familiarity with databases and data; deep knowledge of cloud platforms is not required.
Schedule:
2 days (9:00-17:00)
Price per person:
544.00 € ( 658.24 € incl. 21% VAT)

Training and learning environment