October 06, 2021
0 Comments

Types Of Cloud Services

Click on card specific card to know

We mainly have three types of cloud services but I have added one extra in my post, I hope it will be beneficial for you.

SaaS

Software as a Service

Click me

PaaS

Plateform as a Service

click me

IaaS

Infrastracture as a service

click me

FaaS

Function as a Service

click me

Software as a Service [SaaS]

A Prodect that is run and managed by the service provider are comes into this catagory.

SalesForce ,Gmail , Office 365 etc.

SaaS

Software as a Service

Click me

PaaS

Plateform as a Service

click me

IaaS

Infrastracture as a service

click me

FaaS

Function as a Service

click me

Plateform as a Service [PaaS]

In this type of dovlopment we are most of the time expand on the dovelopment and managment of the resourses.

Like Heroku ,alisic-bean, GCP App Engine

SaaS

Software as a Service

Click me

PaaS

Plateform as a Service

click me

IaaS

Infrastracture as a service

click me

FaaS

Function as a Service

click me

Information as a Service

The basic building block for cloud infrastructure, it not only provides computing and data storage but also networking facilities in the form of advanced technology. Azure ,GCP , Oracle cloud ,AWS

SaaS

Software as a Service

Click me

PaaS

Plateform as a Service

click me

IaaS

Infrastracture as a service

click me

FaaS

Function as a Service

click me

Function as a Service

This is most useful it's covers almost everything like deployment ,runtime,storage ,security,networking and yas we can say all basic opration comes under this FaaS.

SaaS

Software as a Service

Click me

PaaS

Plateform as a Service

click me

IaaS

Infrastracture as a service

click me

FaaS

Function as a Service

click me

October 03, 2021
0 Comments

Google Cloud Digital Leader Certification Introduction

Length: 90 minutes

Registration fee: $99

Language: English, Japanese

Exam format: Multiple choice and multiple select

October 03, 2021
0 Comments

Cloud Hosting Evolution (Google Cloud Digital Leader Certification Course)

Hosting Evolution

(Google Cloud Digital Leader Certification Course)

Part 1(a)

Types Of Hosting :

1. Dedicated hosting.

2. Virtual Private Server Hosting .

3. Shared Hosting.

4. Cloud Hosting.

March 06, 2021
1 Comment

Build and Optimize Data Warehouses with BigQuery

Build and Optimize Data Warehouses with BigQuery Challenge Lab, GSP340, Qwiklab

Challenge Lab

Qwiklabs [GSP340]

@prakashfoundation YouTube

click the card to watch the video.

Subscribe Immediately.

@codeGarry Github

Don't forget to follow on GitHub

click me

GSP340

Task 1:

Create a table partitioned by date

code (A):

CREATE OR REPLACE TABLE ecommerce.sample 
PARTITION BY date 
OPTIONS ( partition_expiration_days=90,
description="COVID 19 data"
) AS 
SELECT * 
FROM bigquery-public-data.covid19_govt_response.oxford_policy_tracker 
WHERE alpha_3_code != 'USA' AND alpha_3_code != 'GBR'

Task 2: Add new columns to your table

code (B)


ALTER TABLE ecommerce.sample
ADD COLUMN IF NOT EXISTS population INT64,
ADD COLUMN IF NOT EXISTS country_area FLOAT64,
ADD COLUMN IF NOT EXISTS mobility STRUCT<
avg_retail FLOAT64,
avg_grocery FLOAT64,
avg_parks FLOAT64,
avg_transit FLOAT64,
avg_workplace FLOAT64,
avg_residential FLOAT64
>

Task 3: Add country population data to the population column

code (C):

UPDATE `<PROJECT_ID>.ecommerce.sample` count
SET count.population = count1.pop_data_2019
FROM `bigquery-public-data.covid19_ecdc.covid_19_geographic_distribution_worldwide` count1
WHERE count.date = count1.date AND count.alpha_3_code=count1.country_territory_code

Task 4: Add country area data to the country_area column

code (D):

UPDATE `<PROJECT_ID>.ecommerce.sample` count
SET count.country_area = count1.country_area
FROM `bigquery-public-data.census_bureau_international.country_names_area` count1
WHERE count.country_name = count1.country_name

Task 5: Populate the mobility record data

code (E)

UPDATE `<PROJECT_ID>.ecommerce.sample` count
SET count.mobility = STRUCT<
avg_retail FLOAT64, avg_grocery FLOAT64, avg_parks FLOAT64, avg_transit FLOAT64, avg_workplace FLOAT64, avg_residential FLOAT64
>
(count1.avg_retail, count1.avg_grocery, count1.avg_parks, count1.avg_transit, count1.avg_workplace, count1.avg_residential)
FROM ( SELECT country_region, date, 
      AVG(retail_and_recreation_percent_change_from_baseline) as avg_retail,
      AVG(grocery_and_pharmacy_percent_change_from_baseline)  as avg_grocery,
      AVG(parks_percent_change_from_baseline) as avg_parks,
      AVG(transit_stations_percent_change_from_baseline) as avg_transit,
      AVG( workplaces_percent_change_from_baseline ) as avg_workplace,
      AVG( residential_percent_change_from_baseline)  as avg_residential
      FROM `bigquery-public-data.covid19_google_mobility.mobility_report`
      GROUP BY country_region, date) AS count1
WHERE count.country_name = count1.country_region
AND count.date = count1.date

Task 6: Query missing data in population & country_area columns

code (F):

SELECT DISTINCT country_name
FROM `<			>.ecommerce.sample`
WHERE population is NULL 
UNION ALL
SELECT DISTINCT country_name
FROM `<			>.ecommerce.sample`
WHERE country_area IS NULL 
ORDER BY country_name ASC

March 06, 2021
1 Comment

Ensure-Access-Identity-in-Google-Cloud-Challenge-Lab

Challenge Lab

Qwiklabs [GSP342]

@prakashfoundation YouTube

click the card to watch the video.

Subscribe Immediately.

@codeGarry Github

Don't forget to follow on GitHub

click me

GSP342

Task 1:

Create a custom security role.

Execute this command on cloud shell to create yaml file for custom role:

code (A):

nano role-definition.yaml

Replace the below content in the file:

code (B)

title: "orca_storage_update"
description: "Permissions"
stage: "ALPHA"
includedPermissions:
- storage.buckets.get
- storage.objects.get
- storage.objects.list
- storage.objects.update
- storage.objects.create

Ctrl+x --> Y--> Enter

code (C):

gcloud iam roles create orca_storage_update --project $DEVSHELL_PROJECT_ID \
--file role-definition.yaml

commands for task2 & task3:

Another Method in video if you get error:

code (D):

gcloud iam service-accounts create orca-private-cluster-sa --display-name "my service account"

gcloud alpha projects add-iam-policy-binding $DEVSHELL_PROJECT_ID --member serviceAccount:orca-private-cluster-sa@$DEVSHELL_PROJECT_ID.iam.gserviceaccount.com --role "projects/<projectid>/roles/orca_storage_update"

gcloud projects add-iam-policy-binding $DEVSHELL_PROJECT_ID --member serviceAccount:orca-private-cluster-sa@$DEVSHELL_PROJECT_ID.iam.gserviceaccount.com --role “roles/monitoring.viewer”

gcloud projects add-iam-policy-binding $DEVSHELL_PROJECT_ID --member serviceAccount:orca-private-cluster-sa@$DEVSHELL_PROJECT_ID.iam.gserviceaccount.com --role “roles/logging.logWriter” 

gcloud projects add-iam-policy-binding $DEVSHELL_PROJECT_ID --member serviceAccount:orca-private-cluster-sa@$DEVSHELL_PROJECT_ID.iam.gserviceaccount.com --role “roles/monitoring.metricWriter”

Task 4: Create and configure a new Kubernetes Engine private cluster

code (E)

gcloud container clusters create orca-test-cluster --num-nodes 1 --master-ipv4-cidr=172.16.0.64/28 --network orca-build-vpc --subnetwork orca-build-subnet --enable-master-authorized-networks  --master-authorized-networks 192.168.10.2/32 --enable-ip-alias --enable-private-nodes --enable-private-endpoint --service-account orca-private-cluster-sa@<Project ID>.iam.gserviceaccount.com --zone us-east1-b

Task 5: Deploy an application to a private Kubernetes Engine cluster.

code 5(a):

gcloud container clusters get-credentials orca-test-cluster --internal-ip --zone us-east1-b --project <Project ID>

code 5(b):

kubectl create deployment hello-server --image=gcr.io/google-samples/hello-app:1.0

Types Of Cloud Services

Click on card specific card to know

SaaS

PaaS

IaaS

FaaS

Software as a Service [SaaS]

SaaS

PaaS

IaaS

FaaS

Plateform as a Service [PaaS]

SaaS

PaaS

IaaS

FaaS

Information as a Service

SaaS

PaaS

IaaS

FaaS

Function as a Service

SaaS

PaaS

IaaS

FaaS

Google Cloud Digital Leader Certification Introduction

Cloud Hosting Evolution (Google Cloud Digital Leader Certification Course)

Types Of Hosting :

Build and Optimize Data Warehouses with BigQuery

Challenge Lab

Qwiklabs [GSP340]

@prakashfoundation YouTube

@codeGarry Github

GSP340

Task 1:

Task 2: Add new columns to your table

Task 3: Add country population data to the population column

Task 4: Add country area data to the country_area column

Task 5: Populate the mobility record data

Task 6: Query missing data in population & country_area columns

Ensure-Access-Identity-in-Google-Cloud-Challenge-Lab

Challenge Lab

Qwiklabs [GSP342]

@prakashfoundation YouTube

@codeGarry Github

GSP342

Task 1:

Replace the below content in the file:

Ctrl+x --> Y--> Enter

commands for task2 & task3:

Another Method in video if you get error:

Task 4: Create and configure a new Kubernetes Engine private cluster

Task 5: Deploy an application to a private Kubernetes Engine cluster.

Pages

Courses

Most Famous

Map