SFTP Client/Server Deep Dive – With OpenSSH Server & WinSCP

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Outline/Structure

Lecture 2: Course Help

Lecture 3: Why I Use Total Commander In All the Course Videos

Chapter 2: SFTP Introduction

Lecture 1: FTP Soup: Distinguishing SFTP from FTP and FTPS

Lecture 2: The SFPT Process (Animation)

Lecture 3: More Details about the SFTP Process

Lecture 4: TOFU – Trust on First Use

Lecture 5: Which party should host the SFTP Server? (Push vs Pull)

Lecture 6: Public/Private Key Pairs (and difference between ppk and pem format)

Lecture 7: SFTP Clients and Servers

Lecture 8: SFTP Alternative Technologies

Lecture 9: SFTP vs Managed File Transfer (MFT)

Lecture 10: SFTP Overarching Security Standards

Lecture 11: SSH as a Remote Terminal

Chapter 3: SFTP Client Demos

Lecture 1: WinSCP – Introduction

Lecture 2: WinSCP – Password Security

Lecture 3: WinSCP – Advanced Topics (Portable Mode, Jump Lists, SSH Command Line)

Lecture 4: WinSCP – FTP/FTPS Capabilities, Renaming Sites, Grouping Sites

Lecture 5: Filezilla

Lecture 6: Total Commander SFTP Plugin

Lecture 7: Altap Salamander – WinSCP Built-In Plugin

Chapter 4: CompleteFTP – Commercial Product Demo – FTP/FTPS/SFTP Server for Windows

Lecture 1: CompleteFTP – Commercial Product Demo (for Windows)

Chapter 5: OpenSSH SFTP Server for Windows

Lecture 1: Install WinSCP and Filezilla (Clients) and OpenSSH (Server)

Lecture 2: Setup First SFTP User using Password Authentication

Lecture 3: "Jailing" a user to one directory using ChrootDirectory (Security)

Lecture 4: Setup Second SFTP User using Public Key Authentication (No Password)

Lecture 5: PowerShell to show all Thumbprints for OpenSSH Server Keys

Chapter 6: OpenSSH SFTP Server for Ubuntu 20.04

Lecture 1: List of all Ubuntu Commands used in this Course

Lecture 2: Install Ubuntu 20.4 on Virtual Box

Lecture 3: Initial Network Verification (Ping/Telnet)

Lecture 4: Set up and Test a User with Password Authentication

Lecture 5: Set up and Test a User with Public Key Authentication

Lecture 6: Verify that SFTP users cannot use Terminal/Remote Command Line

Lecture 7: Host Keys directory (auto created)

Lecture 8: SFTP Logging on Ubuntu

Chapter 7: SFTP Command (Client) and other SSH Commands on Ubuntu

Lecture 1: SFTP Connect with User/Password and do a "GET" command (also FTP)

Lecture 2: SFTP Connect with Private Key "PEM" file, GET, PUT, MGET, MPUT

Lecture 3: The "KnownHosts" file

Lecture 4: Generating Public/Private Key Pairs on Linux (ssh-keygen)

Lecture 5: Installing authorized_keys file (ssh-copy-id) then ssh to other computer

Lecture 6: Copy files security between servers (scp)

Lecture 7: Managing SSH Keys (Security and Management)

Chapter 8: BizTalk SFTP Adapter

Lecture 1: What is BizTalk and Why is it In this Course?

Lecture 2: BizTalk SFTP Send Port (up to the WinSCP install/configuration issue)

Lecture 3: BizTalk WinSCP .Net Library – Issue and Correct Installation

Lecture 4: BizTalk SFTP Send Port (after issue resolved)

Lecture 5: BizTalk SFTP Receive Port

Lecture 6: BizTalk SFTP Receive Port – Service Window

Lecture 7: BizTalk SFTP Send – Retries (when Target Server Down)

Lecture 8: You may not need SFTP adapter, depending on who runs the SFTP Server

Lecture 9: History of SFTP in BizTalk Releases

Lecture 10: Log Management with PowerShell Script

Chapter 9: C# and WinSCP Net Library

Lecture 1: C# Upload

Lecture 2: C# Download

Lecture 3: C# Execute Remote Commands

Chapter 10: Windows – Scripting SFTP (or FTP) and Scheduling Scripts

Lecture 1: Windows PowerShell Calling WinSCP and Task Scheduler

Lecture 2: Bonus concepts for prior assignment

Chapter 11: Ubuntu – SFTP Script and Scheduling with CronJob

Lecture 1: Ubuntu Bash Script

Lecture 2: Introduction to Ubuntu Cron Job, Mail, and Debugging Concepts (Slideshow)

Lecture 3: CronJob – Actual Setup and Testing

Lecture 4: Example forcing an Error in the Script and Viewing the Error by viewing the Mail