SQL

Following along with freeCodeCamp's "Learn SQL by Building a Student Database: Part 1" lesson -- part of the Relational Database certification.

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.

Collection of Clarity Customer SQL Model queries meant to aid in the speed of development.

[Beta] postgres-checkup: PostgreSQL Health Check and SQL Performance Analysis

postgresql_faker is a PostgreSQL extension based on the awesome Python Faker Library

This project is a loyalty card website that allows users to purchase products using points. The system also includes client management features for the store manager. Built with JavaScript and PostgreSQL, the application provides a user-friendly interface for tracking points, managing customer accounts, and facilitating product purchases.

Key Features:

Users can earn and redeem points for product purchases Customer management system for the store manager Database integration using PostgreSQL for data storage and retrieval User-friendly interface for managing loyalty accounts

Technologies:

JavaScript (for frontend and backend development) PostgreSQL (for database management) HTML/CSS (for layout and styling)

A code generation platform for java

This project repository contains a curated collection of SQL solutions to various challenges found on LeetCode. These solutions demonstrate effective problem-solving techniques using SQL queries and provide valuable insights for those looking to enhance their SQL skills. The repository is organized to facilitate easy reference and learning from the provided examples.

This repository contains my solutions to SQL and Database problems from HackerRank. Each problem is solved based on my understanding of SQL queries and database concepts. The solutions demonstrate various techniques such as filtering, joining tables, grouping data, and using subqueries to handle different data-related challenges.

This is the project based on Java Spring Boot. It includes the base code for all the CRUD operations needed to be done for a Spring Boot Application. It also has the JWT authentication for secure login process.

A collection of SQL problems from LeetCode organized by difficulty (Easy, Medium, Hard) with solutions and explanations. Ideal for interview preparation.

SQL injections & race condition

Simple TODO-list app made in Java.

The Sales Web Application repository houses a comprehensive PHP-based system designed for managing orders within a small business framework. Featuring distinct user roles (Admin, Supervisor, Customer), the application ensures secure authentication and meticulous backend architecture, leveraging MySQL for data management. It facilitates seamless creation and management of supervisors, customers, products, and orders, complemented by integration with a mobile app for convenient accessibility and real-time updates. The project prioritizes intuitive UI/UX design and adheres to best practices in coding and documentation, aimed at enhancing operational efficiency and user experience across web and mobile platforms.

В данном репозитории находятся два проекта, демонстрирующие работу c данными в Python и на SQL, а также использование специализированных библиотек для статистических расчетов и визуализации данных, в Jupiter Notebook.

Les développeurs du projet : Mouaz MOHAMED (mr.mouazmohamed@gmail.com), Sofiane BOUHOURIA (sofianebouhouria@gmail.com) et Naïm AISSIOUI (aissiouinaim.95@gmail.com) ~ Site Web dynamique développé en HTML, CSS, PHP et JavaScript durant notre stage chez TiqTec, donné par le directeur de stage Mujeebur RAHAMAN. Ce site permet de se connecter au site à l'aide d'une base de données développée en SQL qui est relié au site Web grâce au PHP et avec le pilote MySQLi, puis par la suite d'avoir accès à trois applications Web : MyTodo™ pour gérer les tâches, MyNotes™ pour prendre des notes et MyPomodoro™ pour gérer son temps via la méthode Pomodoro (25 minutes de travail et 5 minutes de repos)

Les développeurs du projet : Mouaz MOHAMED (mr.mouazmohamed@gmail.com) et Sofiane BOUHOURIA (sofianebouhouria@gmail.com) ~ MyColoc est une application de bureau Windows développée en C# par Mouaz et Sofiane via le framework Microsoft .NET et l'interface graphique Windows Forms. C'est une application permettant de gérer les colocataires et les dépenses faisant parti de la colocation du Crous.