Cloud Learning

Cloud technology learning summary

Project info


Data Engineering & Analysis

2025/03

Introduction

A brief project description or quote to summarize its goals.

“GCP Meetup, recent readings, and business needs inspired me to explore cloud technologies. While I primarily focus on GCP, I also provide an overview of data services from other providers. ”
— Arek

Table of Contents


Google Cloud Platform

Task 1 - Digital Leader Path

Preparation for the first step of certification:

  • ✔️ Completed Skill Boost Digital Leader Path
  • ✔️ Google Cloud Digital Leader Certification Guide - Book Summary

Task 2 - Completed Skill Boost Labs

Practical hands-on labs in a real cloud environment:

  • ✔️ Derive Insights from BigQuery Data - Analytical SQL with BQ
  • ✔️ Build a Data Warehouse with BigQuery - BigQuery DWH
  • ✔️ Streaming Analytics into BigQuery - Pub/Sub, Dataflow (Beam), BigQuery

Read more in my Course Brief...


Microsoft Azure

Task 1 - End-to-End Cloud Project

A small project covering the full setup from database configuration to generating a Power BI report:

  • ✔️ Setup Synapse workspace (Synapse Workspace, Data Lake Storage HNS, FileSystem)
  • ✔️ Setup Serverless Database (dedicated DB with 'analytics' schema)
  • ✔️ Load Parquet files into storage
  • ✔️ Create View
  • ✔️ Test Queries
  • ✔️ Connect Power BI Desktop with the remote database as a data source
  • ✔️ Create a base Power BI report (View + DAX)

Oracle Cloud Infrastructure

Task 1 - UI Overview

Familiarization with the Oracle Cloud interface:

  • ✔️ Create Oracle Autonomous Data Warehouse
  • ✔️ Create APEX Instance

Project Overview

In General

Components

Quick Summary

  1. Google Cloud Platform
  2. Azure Cloud
  3. Oracle Cloud Infrastructure

List of All Technologies

Grouped by Category

Category Technologies
ProviderGCP ✦ Azure ✦ OCI
ServiceBigQuery ✦ Dataflow ✦ Pub/Sub ✦ Cloud Storage ✦ Synapse ✦ Power BI ✦ Azure Data Lake ✦ Autonomous Data Warehouse ✦ APEX
Learning PlatformSkill Boost Labs
DataSourceParquet

Components Specification

Detailed Information Grouped by Components

Table of Contents:

  1. Google Cloud Platform
  2. Azure Cloud
  3. Oracle Cloud Infrastructure
Details
  1. Google Cloud Platform

    Tech Stack
    Category Description
    Provider GCP
    Service BigQuery
    Service Dataflow
    Service Pub/Sub
    Service Cloud Storage
    Learning Platform Skill Boost Labs
  2. Azure Cloud

    Tech Stack
    Category Description
    Provider Azure
    Service Synapse
    Service Power BI
    Service Azure Data Lake
    DataSource Parquet
  3. Oracle Cloud Infrastructure

    Tech Stack
    Category Description
    Provider OCI
    Service Autonomous Data Warehouse
    Service APEX

Additional Information

  • Domain: Data Engineering
  • Status: in_progress
  • Keywords: Cloud GCP Azure OCI Parquet Python PowerBi Storage

Thumbnail

Thumbnail