PowerShell Database Loader with SQLite

Technologies Used: PowerShell, SQLite3, CSV, GitHub
GitHub Repository: https://github.com/cowancs3030spring25/lab8-JeanCh04
● Translated a Python-based database ingestion tool into PowerShell to process CSV registration data into structured SQLite3 tables.
● Parsed a CSV input containing course registration records and populated normalized people and courses tables in a SQLite database.
● Utilized PowerShell's import-csv and SQLite3’s .NET DLL for database operations including table creation, insertion, and duplicate handling.
● Implemented robust error handling for file I/O and database connection using try/catch blocks.
● Extracted and split composite course information using PowerShell string functions to normalize the data into subject code and course number.
● Committed all data changes within database transactions to ensure atomicity and improve performance.
● Managed version control and deployment using Git and GitHub in a Linux-based development environment.