bukuro seiyashima

## 20230314_Preparing for the Professional Data Engineer Examination.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                seiyashima
                / 20230314_Preparing for the Professional Data Engineer Examination.md
            
            
              Last active
              September 19, 2023 13:14
                — forked from YukiTominaga/20230314_Preparing for the Professional Data Engineer Examination.md
            
              
                YukiTominagaさんのGist公開資料をベースに Skills Boost で学習した内容を追加した Gist です。
              
          
    Google Cloud Storage

非構造化データの保管に特に優れる。
音声、画像、映像などファイル(｢オブジェクト｣と呼ばれる)を保存するケースで利用する。
Storage Class

アクセス頻度の高い順に、Standard, Nearline(月に1回), Coldline(3ヶ月に1回), Archive(年に1回)の4種類ある。
Standard以外のStorage Classは読み取りに対して料金が発生する。

  
## alias
[toplevel]
# Put this in ~/.aws/cli/alias
# and you'll have an "aws upgrade"
# and an "aws check-upgrade" command.
#
# Only works on macOS and installs using
# the .pkg installer.
#
upgrade = !f() {
    curl -s "https://awscli.amazonaws.com/AWSCLIV2.pkg" -o "/tmp/AWSCLIV2.pkg"

## 社会人の心得
第1条. 酒と女とギャンブルには気をつけろ
第2条. リボ払いは使うな
第3条. 「まだ大丈夫」はもうダメ
第4条. 朝帰りしたらシジミ汁を飲め
第5条. 全てのカバンにビニール袋を入れろ
第6条. 酔っ払ったらSNSをやめろ
第7条. 周りのみんなに日頃から感謝しろ

## AutoMailSender.js
// FormApp.getActiveForm()
function autoMailSender(e){
  Logger.log('autoMailSender execute...');

  const __NAME__ = 0;
  const __MAIL__ = 1;
  var itemResList = e.response.getItemResponses();
  var msg = '';
  var nameAsk = itemResList[__NAME__];
  var nameAns = nameAsk.getResponse();

## CREATE文とINSERT文を生成
'Extract, Transform, Load for TABLE information
Sub etlExecute()
    Dim i As Integer

    ' For appending to array, Re-Extracting from array
    Dim col As Integer
    Dim row As Integer

    ' Ouput position on "Output" Worksheet
    Dim opRowCount As Integer

## URL
https://slack.com/api/users.list?token=<取得したトークン: (例)xoxbXXXXXXXXXXXXXX>

## airconbot.coffee
#
# airconbot can turn on as cooler or heater depends on commands
#           and turn off the room aircon
#

# userID(userlist from Slack)
uid = [ 'UXXXXXXXXX' ] # ユーザーIDを入力

# For executing script from coffeeScripts
cp = require 'child_process'

## shoppingListForAirConDev
RaspberryAirCon
  + 赤外線受信モジュール PL-IRM2121
  + 赤外線LED OSI5FU51111
  + LEDキャップ OS-CAP-5MK-1
  + 抵抗(50Ω)

## MaterialOf8BitTape
8bit mixTape
  + potentiometer(10KΩ: Bカーブ) * 2
  + momentary button * 2
  + ATtiny45 / 85 Microcontroller (85 has been used on reference)
  + Stereo Minijack(Sunny Electonics)
  + CR2032 Battery holder * 2
  + 抵抗(10kΩ) * 2
    (Ref: http://macumbista.net/wp-content/uploads/2016/10/8-bit_Mixtape_Wiring_Diagram.jpg )
	[toplevel]
	# Put this in ~/.aws/cli/alias
	# and you'll have an "aws upgrade"
	# and an "aws check-upgrade" command.
	#
	# Only works on macOS and installs using
	# the .pkg installer.
	#
	upgrade = !f() {
	curl -s "https://awscli.amazonaws.com/AWSCLIV2.pkg" -o "/tmp/AWSCLIV2.pkg"
	第1条. 酒と女とギャンブルには気をつけろ
	第2条. リボ払いは使うな
	第3条. 「まだ大丈夫」はもうダメ
	第4条. 朝帰りしたらシジミ汁を飲め
	第5条. 全てのカバンにビニール袋を入れろ
	第6条. 酔っ払ったらSNSをやめろ
	第7条. 周りのみんなに日頃から感謝しろ
	// FormApp.getActiveForm()
	function autoMailSender(e){
	Logger.log('autoMailSender execute...');

	const __NAME__ = 0;
	const __MAIL__ = 1;
	var itemResList = e.response.getItemResponses();
	var msg = '';
	var nameAsk = itemResList[__NAME__];
	var nameAns = nameAsk.getResponse();
	#
	# airconbot can turn on as cooler or heater depends on commands
	# and turn off the room aircon
	#

	# userID(userlist from Slack)
	uid = [ 'UXXXXXXXXX' ] # ユーザーIDを入力

	# For executing script from coffeeScripts
	cp = require 'child_process'
	RaspberryAirCon
	+ 赤外線受信モジュール PL-IRM2121
	+ 赤外線LED OSI5FU51111
	+ LEDキャップ OS-CAP-5MK-1
	+ 抵抗(50Ω)
	8bit mixTape
	+ potentiometer(10KΩ: Bカーブ) * 2
	+ momentary button * 2
	+ ATtiny45 / 85 Microcontroller (85 has been used on reference)
	+ Stereo Minijack(Sunny Electonics)
	+ CR2032 Battery holder * 2
	+ 抵抗(10kΩ) * 2
	(Ref: http://macumbista.net/wp-content/uploads/2016/10/8-bit_Mixtape_Wiring_Diagram.jpg )