Ejercicios de SQL de BD. Tablas, vistas, consultas, funciones, stored-procedures, triggers, roles, backups, restores, etc. TP de BD: https://github.com/FabianNorbertoEscobar/BD-TP

Examples of Scripts: (DDL,DML,Views, Procedures, Functions)

A System provides question pool, so instructor can pick an exam from it,Instructor can select students that can do specific exam, and define Exam date, start time and end time. Students can see the exam and do it only on the specified time, System stores students answer for the exam and calculate the correct answers, and calculate the final resu…

Wise Owl SQL Server Exercises Solutions

Formative Assessment: Created a database called ‘FA2’ with three database tables: A student, Campus and Teacher’s table. Each table has 14 different schemas’, because there are 14 CTU campuses nationally and the teachers only have access to their own campus’ details

Creation of a relational database alongside with the ER diagram, the Relational Model and the Database Diagram. Insertion of data and creation of multiple SQL queries for data retrieval

ms-sql database design (with triggers, stored procedures,functions and views)

Database of a telecom company - ORT

A comprehensive analysis of housing data in the Syracuse area using T-SQL and Azure Data Studio. This project includes SQL scripts for database creation, data insertion, and clean-up, along with detailed views and user-defined functions for data retrieval and analysis. Licensed under the BSD 2-Clause License.

Proyecto SQL de gestión de equipamiento y enlaces a Internet para la empresa de logística "Mundo Trade". Implementa técnicas avanzadas de SQL para garantizar la integridad y eficiencia del sistema y la correcta administración de datos.

Analysis of Covid-19 related deaths and vaccinations using SQL

There are examples of Join, SubQuery, DML, DDL, Views, Stored Procedures, User Defined Functions in this repository.

Hospital Management System Database implementation in SQL

This repository contains my implementation of a SQL Server Database which contains data (such as episode list, doctors list, enemies list, companions list, authors list, and much more) about the Doctor Who series. This database was created in accordance with the rules, requirements, and constraints set forth by this project and which can be foun…

From Tables and SELECT queries to advanced SQL.

A database called Library is used to work with views in MSSQL Server