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.

The SQL code that supports a sql server integration services package. This sql provides the table, stored procedure, view and query design used in the Extract, Transform and Load process. The focus is on implementing basic to intermediate know ways of extracting data from json files using sql server built in json functionality along with importing

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…

Flight_Booking_Database_MGMT_System

From Tables and SELECT queries to advanced SQL.

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