Introduction to Python Programming

Welcome! This repository contains projects and code snippets from an "Introduction to Python Programming" course. The goal is to provide a practical, hands-on portfolio of work demonstrating core Python programming skills.

📖 Description

This repository covers a range of fundamental topics essential for any aspiring Python developer. The projects focus on data manipulation, analysis, and database interaction.

Key Libraries & Concepts

• Data Ingestion: Reading and parsing data from various formats like JSON.
• Database Interaction: Using sqlite3 to create, populate, and query relational databases from Python.
• Data Manipulation: Using standard Python data structures to process information.
• File I/O: Reading from and writing to files.
• SQL: Basic SQL commands for table creation and data insertion.

🚀 Projects Included

JSON to SQLite Roster Database

• Description: A Python script that reads student roster data from a JSON file, creates a normalized database schema (User, Course, Member), and populates the tables. This demonstrates a complete data ingestion and storage pipeline.
• Concepts: sqlite3 for database management, json for data parsing, relational database design (many-to-many relationships).

⚙️ Getting Started

Prerequisites

Make sure you have Python 3 installed on your system.

python --version