Python Web Application with MS SQL Server Integration

Professional Project Overview

This repository showcases a professional Python web application integrated with Microsoft SQL Server, developed to demonstrate solid skills in backend integration, database operations, and web-based user interfaces.

The project focuses on implementing reliable database connectivity and essential data operations through a clean and functional web interface, following good development practices suitable for real-world applications and technical portfolios.

---

Key Features

• 🔗 Robust Database Connectivity Secure and configurable connection to Microsoft SQL Server using ODBC drivers.

• 🗄️ Database Schema Management Ability to create database tables programmatically through the application.

• ➕ Data Insertion Workflow User-friendly forms for inserting structured data into the database.

• 📊 Data Visualization Retrieval and display of stored records in organized tabular views.

---

Technologies & Libraries

Core Technologies

• Python (3.13.5) – Main programming language
• Microsoft SQL Server – Relational database management system
• Streamlit – Web application framework for rapid UI development
• ODBC Driver for SQL Server – Database connectivity layer

Python Libraries

• pyodbc Enables communication between Python and Microsoft SQL Server, supporting SQL execution and transaction handling.

• streamlit Provides an interactive and responsive web interface, allowing users to interact with database operations seamlessly.

• pandas Used for data manipulation and presentation of query results.

• numpy Supports numerical operations and data processing tasks.

• datetime Handles date and time management for database records and logging.

---

Setup & Execution

Prerequisites

• Python 3.x
• Microsoft SQL Server (local or remote instance)
• ODBC Driver for SQL Server

Installation

Install the project dependencies:

pip install -r requirements.txt

Configuration

Configure the database connection by updating the connection string with:

• Server address
• Database name
• Authentication credentials

Running the Application

streamlit run app.py

Access the web application using the local URL provided in the terminal.

---

Professional Objectives

This project was developed as part of a professional portfolio to demonstrate:

• Practical experience with Python and relational databases
• Ability to integrate backend services with a web interface
• Understanding of fundamental database operations
• Clean code organization and documentation practices

---

License

This project is available for demonstration, learning, and portfolio purposes.