M

mssql-database

DatabaseManager

Overview The DatabaseManager module is designed to simplify interactions with a MySQL database. It provides functionality for creating tables, inserting data, updating data, and deleting entries with single or multiple conditions. This module is particularly useful for managing machine-related data in industrial or IoT environments. It integrates a custom logging interface to monitor database operations effectively.

Features

Establishes connections to a MySQL database. Supports table creation for machine data storage. Enables insertion of new entries and updating existing ones. Provides options to delete entries with single or multiple conditions. Retrieves column names or entire tables, with optional ordering. Integrated logging for error tracking and debugging.

During my Summer Internship at Celebal Technologies, I worked on SQL projects to improve data management and search processes for a particular client. The main goal of these projects was to optimize database queries and ensure effective information retrieval.

The "KIIT Library Management System" is a comprehensive Full Stack Application developed for KIIT University using .NET Framework, C#.NET, Windows Forms, and MS SQL Server. This application integrates a C# backend with a Windows Forms frontend, executing SQL queries to manage and retrieve data such as book details, student records etc.