π§ Welcome to the Prerequisite Course
π Estimated Completion Time: 1β2 Weeks (Self-Paced)
Before diving into HL7 messaging and integration projects, this prep course will help you learn foundational tools and complete 3 mini-projects.
π― Goal: Set up your software, build confidence with core tools, and prepare for the bootcamp.
π οΈ Install Required Tools
β Notepad++
β Greenshot
β Microsoft Teams
β Mirth Connect
β HL7 Soup (Free Edition)
β SQL Server Express
β FileZilla Client
β Gpg4win (PGP Encryption Tool)
β Postman (for API testing)
Recommended Free Resources:
Codecademy: Learn the Command Line (4 hrs)
Codecademy: Learn SQL (5 hrs)
Codecademy: Intro to JavaScript (15 hrs)
Embed YouTube or Drive-hosted videos here:
Installing Mirth Connect
Setting up SQL Server Express
Using FileZilla
Making API requests with Postman
π Scenario: Automate file exchange with a lab system using FileZilla.
π οΈ Tasks:
- Write a `.bat` script that downloads a file from the HL7 home lab
- Upload a file to the server
π€ Submit:
- Your batch script file (.bat)
- Screenshot of upload/download log
π Scenario: Pull data from a public API to simulate external system integration.
π οΈ Tasks:
- Use curl or Postman to send a GET request
- Save the JSON response to your local folder
π€ Submit:
- Screenshot of your API request and JSON output
π Scenario: Query a basic SQL table to retrieve patient appointment data.
π οΈ Tasks:
- Install SQL Server Express
- Load sample table from provided SQL script
- Write a SELECT query to show all appointments scheduled for tomorrow
π€ Submit:
- Your SQL query
- Screenshot of the query result