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.

Location, current course term

Contact us

Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • 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
Assumed knowledge:
Basic familiarity with databases and data; deep knowledge of cloud platforms is not required.
Schedule:
2 days (9:00 AM - 5:00 PM )
Course price:
544.00 € ( 658.24 € incl. 21% VAT)
Language: