Database_Systems_Tutor

All Tutor work for database systems will be uploaded here.

Resources

Database normalization: https://database.blog/database-normalization/
Concurrency Problems: http://www.myreadingroom.co.in/notes-and-studymaterial/65-dbms/532-concurrency-problems.html
Concurrent Transactions: https://www.slideshare.net/sajan45/concurrent-transactions
Starvation and Deadlock in OS: https://www.tutorialspoint.com/starvation-and-deadlock
DBMS - Deadlock: https://www.tutorialspoint.com/dbms/dbms_deadlock.htm

Learn SQL with MySQL (Youtube Playlist)

https://www.youtube.com/watch?v=IfZPy5uBgHE&list=PL-KSt1w_h7KnM73k8glIpd0xT6p9JTB_z

Example Project Resources and Overview

Resources: MySQL Installer - Community, MySQL workbench, R
Data: Employees Sample Database-https://dev.mysql.com/doc/employee/en/
Employees DB on GitHub: https://github.com/datacharmer/test_db
Employees Database Structure: https://dev.mysql.com/doc/employee/en/sakila-structure.html

Overview

Created an Employees database on MySQL workbench using the downloaded Employees DB on GitHub
Performed feature engineering on joined tables to obtain Hire Age and Current Age, Monthly and Daily salary, break down dates into Day, Month and Year.
Utilized Data Visualisation to figure hiring patterns, acceptable, satisfying and lasting salaries and average work years.
Built a dashboard to showcase results