Skip to content

Coursework for university - I implemented a database similar to YouTube.

License

Notifications You must be signed in to change notification settings

BaggerFast/VideoHostingDatabase

Repository files navigation

VideoHosting database

MicrosoftSQLServer
Coursework for university - I implemented a database similar to YouTube.

Tables scheme

Tables scheme

QUICK START

  1. If you use windows
git config --global core.autocrlf false
  1. Git clone this project
git clone https://github.com/BaggerFast/VideoHostingDatabase.git
  1. Set hard password to user SA into docker-compose.yml
MSSQL_SA_PASSWORD=""
  1. Connect to database via docker-compose
docker compose up
  1. Scripts structure
    • STRUCTURE.sql - Create table
    • TRIGGERS.sql - Create triggers for table
    • INSERT.sql - Insert data into table
    • SELECT.sql - Select table
    • TRUNCATE.sql - Clear table
    • DROP.sql - Delete table
  2. Use scripts in this order

About

Coursework for university - I implemented a database similar to YouTube.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Languages