timpamungkasudemy

 bq load --source_format=AVRO --use_avro_logical_types --project_id [project_id] course_dataset.sample_employee "gs://biquery_sample_data/load_data_into_bigquery_3/sample_employee_06.avro"

timpamungkasudemy

BigQuery Course : Resource & Reference

This page is Resource & Reference for BigQuery course.

Table of Contents

Contents are grouped based on lecture title.
The order of contents is same as order at course, although not all lectures has resource.

• Technology In This Course
• Start with BigQuery
• Functions

timpamungkasudemy

API Security

SQL Injection

Fix for stored procedure

CREATE OR REPLACE PROCEDURE public.update_jdbc_customer(
  existing_customer_id bigint,
  new_full_name character varying)
LANGUAGE 'plpgsql'

timpamungkasudemy

Spring Kafka Useful Links

Kafka Schema Regsitry & REST Proxy

• Apache Avro Home
• Confluent Schema Registry Home
• Confluent Schema Registry REST API
• Confluent REST Proxy Home
• Confluent REST Proxy REST API
• Conduktor (Kafka UI)
• Avro Gradle Plugin
• Avro Maven Plugin

timpamungkasudemy

• Movie datasets
  • IMDB plots & spoilers

• Create Google Service Account credential (JSON)
• Logstash
  • Logstash download & installation

• Jdbc input plugin

timpamungkasudemy

Download Tools for Running Sample Code

• Java (Amazon Coretto)
• Eclipse IDE
• Postman
• Docker

For Beginner

If you need to be more familiar with Spring REST API and Spring Kafka, go here:

• Spring REST API
• Spring Kafka

timpamungkasudemy

export function calculateMonthlyInstallment(loanAmount, tenureInMonths, annualInterestRate) {
    let monthlyInterestRate = annualInterestRate / 12 / 100;
    let monthlyPayment = loanAmount * monthlyInterestRate / (1 - Math.pow(1 + monthlyInterestRate, -tenureInMonths));

    return Math.round(monthlyPayment * 100) / 100;
}