I chose 'AdventureWorksLT2019.bak' and 'AdventureWorksLT2017.bak' data for analysis & visualization. The query editing was done in 'Microsoft SQL Server Management Studio' and the visualization part was using 'Microsoft Power BI'. Also for analysis, I used MS Excel and PowerBI's query tool.

The CEDS Integrated Data Store factors the entities and attributes of the CEDS Domain Entity Schema (DES) with standard technical syntax and 3rd normal form database normalization. The IDS Logical Model provides a standard framework for integration of P-20 data systems through a well-normalized “operational data store”. In a P-20 data system, th…

Taking IMDBs database dumps and turning them into a multiple projects

Implementation of Relational Matrix Algebra in MonetDB

This repository contains resources helping grasps the basics of Microsoft SQL Server

School Database using Java and SQL with fictitious student/teacher information

FEUP BDAD | Databases | 2018/19

Taller de Gestión de Datos e Información I con Gustavo Coronel.

🚗 Data engineering scenario for a Car Sales company Achieved Distinction for this module with SQL proficiency

Completed-Homework and Exercises-SoftUni

Repository of my course work "Relational Database of AD Agency"

Querying data from SQL server for data analysis

Taller de Modelamiento de de Base de Datos con Gustavo Coronel

Simulating the relational tables that would be required for a multi-player online battle arena game using SQL Server Management Studio to improve understanding of SQL commands and database queries.

In this folder I have added exercises solved by me with queries to check my knowledge regarding relational databases.

Database Management project using tSQL

MS SQL database for a restaurant management system. Project from Fundamentals of Databases course (Podstawy Baz Danych) at AGH UST - fall 2021

This repo is created in order to keep track of the exercises and projects that my teammates and I do for the Data Engineering course at the university during our second year of Software Engineering.

In this project, we designed a detailed database of a system where online voting will be done and integrated the necessary procedures, views, functions, and triggers to ensure system functionality. Assets and units are needed in the system; It is associated with tables and keys and works in conjunction with other functional parts. The project wa…

This is a collection of the SQL projects that I have as part of my portfolio thus far, these vary from smaller code snippets to larger programs.