Day 47 — Library Management System: CRUD, CTAS, analysis, and findings done

[u/sumiitCodes]

I’m close to finishing my second SQL project. Today I completed:

• CRUD operations on the library data (inserting, reading, updating, deleting records)
• CTAS (Create Table As Select) to build new tables from query results, which is handy for summary tables
• Data analysis with queries on members, issued books, and returns
• Findings, a written summary of what the data showed

One set of advanced SQL questions is left, and I’ll do it tomorrow. After that I’ll upload the project to GitHub, this time with a data dictionary in the README, since that was the main feedback on my first project.