{"id":17,"date":"2025-05-20T11:46:11","date_gmt":"2025-05-20T18:46:11","guid":{"rendered":"https:\/\/community.cob.sjsu.edu\/longhnguyen\/points\/arizona-cardinals-business-intelligence-database-simulated-technical-interview\/"},"modified":"2025-05-20T11:46:11","modified_gmt":"2025-05-20T18:46:11","slug":"arizona-cardinals-business-intelligence-database-simulated-technical-interview","status":"publish","type":"points","link":"https:\/\/community.cob.sjsu.edu\/longhnguyen\/points\/arizona-cardinals-business-intelligence-database-simulated-technical-interview\/","title":{"rendered":"Arizona Cardinals Business Intelligence Database | Simulated Technical Interview"},"content":{"rendered":"

–Designed and implemented a 4-table relational database in Oracle LiveSQL to manage fan, ticket, game, and engagement data, ensuring accuracy through 3NF normalization and foreign key constraints.
\n–Wrote SQL queries to extract business insights such as top-revenue games and platform-based engagement trends to support strategic marketing and ticketing decisions.
\n–Collaborated in a 6-person team to design a fully functional ERD, debug SQL scripts, load sample data, and align schema structure with stakeholder needs.
\n–Presented project findings and query logic during a simulated technical interview, demonstrating communication, teamwork, and real-world business analysis during Q&A.<\/p>\n

Comprehensive Report<\/a><\/p>\n

Simulated Technical Interview: Milestone 4_ Interview (2)<\/a><\/p>\n","protected":false},"author":2211,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-17","points","type-points","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/community.cob.sjsu.edu\/longhnguyen\/wp-json\/wp\/v2\/points\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.cob.sjsu.edu\/longhnguyen\/wp-json\/wp\/v2\/points"}],"about":[{"href":"https:\/\/community.cob.sjsu.edu\/longhnguyen\/wp-json\/wp\/v2\/types\/points"}],"author":[{"embeddable":true,"href":"https:\/\/community.cob.sjsu.edu\/longhnguyen\/wp-json\/wp\/v2\/users\/2211"}],"replies":[{"embeddable":true,"href":"https:\/\/community.cob.sjsu.edu\/longhnguyen\/wp-json\/wp\/v2\/comments?post=17"}],"version-history":[{"count":0,"href":"https:\/\/community.cob.sjsu.edu\/longhnguyen\/wp-json\/wp\/v2\/points\/17\/revisions"}],"wp:attachment":[{"href":"https:\/\/community.cob.sjsu.edu\/longhnguyen\/wp-json\/wp\/v2\/media?parent=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}