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