Database Schema Samples

Barry Williams' library of 'Kick-Start' Data Models is a great resource to check when starting work on designing a database schema (Thanks ScottGu)


Comments

Post a Comment

Popular posts from this blog

Oracle University Free Courses & Certification Exam Prep Material (2026)

Image
A few decades ago, quality training was scarce and costly. Thanks to the convergence of several new advancements, software vendors now provide online training to a worldwide audience, making skill acquisition more accessible than ever. Microsoft offers its Microsoft Learn platform, Google provides Google Skills , and Oracle University is doing a great job of delivering training for their products while also covering higher-level concepts relevant to the database, cloud, and AI domains. The following Oracle certification exams are free to take and come with learning resources: Oracle Cloud Infrastructure Foundations Associate (1Z0-1085-26) Oracle Cloud Infrastructure Architect Associate (1Z0-1072-26)   Oracle Data Center Operations Foundations Associate (1Z0-3000) Oracle Multicloud Foundations Associate (1Z0-1144-26) Oracle Cloud Infrastructure AI Foundations Associate (1Z0-1122-26) Oracle AI Database Foundations Associate (1Z0-1195-26) Additionally, Oracle University offers many ...
Read more

HOW TO Filter Products on Open Food Facts by Country (India) Using DuckDB & Superset

Image
Open Food Facts (OFF) is a crowd-sourced database of food products from around the world.  Somewhere in the world, a shopper scans the barcode on a packet of biscuits and adds basic product details. Another person photographs a package label for the same product in Hyderabad. A volunteer in France fixes a typo.  That's Open Food Facts, a volunteer-built, openly licensed database of food products that's continually changing and growing. Each product is identified by a barcode and carries ingredients, nutrition facts, brands, labels and more. The whole database has millions of products, and let's say you only want the products recorded as being sold or available in one country like India. There are multiple ways to extract a subset of the OFF database. I have already tried using the daily dump available on Hugging Face through Google Colab and GitHub Actions in the past but it blew my mind that using the OFF deployed Apache Superset , you can execute a SQL query in a brows...
Read more

Renewed my Associate Cloud Engineer Certification through Google Skills

Image
Google now allows eligible certification holders to extend their credentials for 12 months by earning specific skill badges and completing courses through Google Skills instead of taking the proctored exam. I availed this opportunity to renew my Associate Cloud Engineer Certification till next year by completing courses and acquiring skill badges through Google Skills . You can choose any of the following options to count toward renewal of eligible Google Certifications: 2 skill badges 1 skill badge & 2 courses 4 courses These activities must be completed within the 12 months prior to certification expiration The Courses and Labs are thoughtfully designed and regularly updated to stay relevant to the workplace. The AI related modules were particularly useful to me. I compiled a glossary of Google Cloud & AI terms from the material - Agent Platform is a comprehensive machine learning development platform that provides both predictive and generative AI capabilities. It allow...
Read more