Udemy - 100 Days of Code - The Complete Python Pro Bootcamp for 2021 - Intermediate

Day 15 ~ Day 31

Introduction

阿彌陀佛，計畫總是趕不上變化

網址　：https://www.udemy.com/course/100-days-of-code/

程式碼：https://github.com/deathpc/python_100day/

Udemy - 100 Days of Code - The Complete Python Pro Bootcamp for 2021 - Beginner

Day 1 ~ Day 14

Introduction

2020年底買的 Python 百日課程，結果因為疫情耍廢了快半年 =V=''

由於一開始都是基礎，以下只記錄久沒用會忘記或沒那麼熟悉的部份

網址　：https://www.udemy.com/course/100-days-of-code/

程式碼：https://github.com/deathpc/python_100day/

FreeCodeCamp - Learn to Use the MySQL Database

Introduction

一堂介紹SQL基礎的課程，因為平常只要SQL能撈到資料就好，回過頭來看一下除了指令之外的內容…
網址：https://www.youtube.com/watch?v=ER8oKX5myE0

Android Basics in Kotlin - Unit 2: Layouts

Kotlin 簡介

Android Basics in Kotlin - Unit 1: Kotlin basics for Android

Kotlin 簡介

Coursera - IBM - Network Security & Database Vulnerabilities 觀後摘要(三)

 Week 3  - Intr oduction to Databases

這一週講者的口條摧殘心力...

Types of Data

Coursera - IBM - Network Security & Database Vulnerabilities 觀後摘要(二)

 Week 2  - Basics of IP Addressing and the OSI Model

Basics of IP Addressing

Coursera - IBM - Network Security & Database Vulnerabilities 觀後摘要(一)

Week 1  - TCP/IP Framework

Introduction to the TCP/IP Protocol Framework

Coursera - IBM - Cybersecurity Compliance Framework & System Administration 觀後摘要(四)

Week 4  - Cryptography and Compliance Pitfalls

Cryptography Vulnerabilities in the News

Cmd/Powershell 好用指令

• 批次更改目錄中檔案名稱
  Get-ChildItem -Filter Pattern | Rename-Item -NewName {$_.Name -replace 'keyword1','keyword2'}
  
  
• 取得目錄下符合Pattern (如*.txt) 的檔案，將檔名中的關鍵字keyword1替換成keyword2。
  
  
• 指令中的$_代表當前Pipeline的輸入對象，其中需要注意的是keyword1中若有符號需以 \ 跳脫，keyword2不用。
  
  
• 合併目錄中CSV檔案
  for /f %a in ('dir /b *.csv') do for /f "tokens=*" %b in (%a) do echo %b,%a >> output.csv
  
  
1. for /f %a in ('dir /b *.csv') do
   進入迴圈，接收 dir /b *.csv 的每一列輸出結果(檔案名稱)並分配給變數 %a，執行後續指令。
   
   
2. for /f "tokens=*" %b in (%a) do
   進入迴圈，將 %a 檔案裏的每一列內容分配給 %b 變數，執行後續指令。
   
   
3. echo %b,%a >> all.csv
   輸出變數 %b、逗點與變數 %a 至 output.csv 檔案中

 

 

Coursera - IBM - Cybersecurity Compliance Framework & System Administration 觀後摘要(三)

Week 3  - Server and User Administration

Introduction to Windows Administration(內容與Cybersecurity Roles, Processes & Operating System Security的第三週 Windows Operating System Security Basics 幾乎相同)

Coursera - IBM - Cybersecurity Compliance Framework & System Administration 觀後摘要(二)

Week 2  - Client System Administration, Endpoint Protection and Patching

Characteristics of Client System Administration

Coursera - IBM - Cybersecurity Compliance Framework & System Administration 觀後摘要(一)

Week 1  - Compliance Frameworks and Industry Standards

Welcome to Compliance Frameworks and Industry Standards

Coursera - IBM - Cybersecurity Roles, Processes & Operating System Security 觀後摘要(四)

 Week 4  - Virtualization module introduction

Virtualization Basics and Cloud Computing

Coursera - IBM - Cybersecurity Roles, Processes & Operating System Security 觀後摘要(三)

Week 3  - Windows Operating System Security Basics

User and Kernel Modes

Coursera - IBM - Cybersecurity Roles, Processes & Operating System Security 觀後摘要(二)

Week 2  - Examples & Principles of the CIA Triad

Introduction to the CIA Triad

Coursera - IBM - Cybersecurity Roles, Processes & Operating System Security 觀後摘要(一)

Week 1  - People Process & Technology

Welcome