My summer reading always includes listening to Stephen Jay Gould’s The Mismeasure of Man. I discovered Gould in 1984 and have been a lifelong fan of his essays and books. Especially this year, I have been thinking more and more about intelligence and the really weak definitions of it that characterizes our understanding of it. Read More
a post for students in my database course Ever wondered what keeps all that digital information flowing smoothly, securely, and ethically in the vast world of data? It’s not magic, it’s data governance. Think of data governance as the traffic laws, road signs, and even the emergency services of the data highway. Without them, it Read More
a post for students in my database course Effective communication is paramount in the field of data analytics, and often, the culmination of a data professional’s hard work is presented in a report. These reports are not merely collections of numbers; they are powerful tools designed to translate complex data into actionable insights, enabling informed Read More
a post for students in database course Ever heard the saying, “Garbage in, garbage out”? It’s a fundamental truth in the world of data analytics. Imagine you’re trying to bake a perfect cake, but half your ingredients are spoiled, or you’ve accidentally doubled the sugar in one bowl and forgotten it entirely in another. Your Read More
a post for students in my database course Queries are fundamental to data analytics, enabling the extraction and manipulation of information from databases and other sources. When working with data, particularly in building data pipelines, two primary methodologies for moving and preparing data are Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT). While both Read More
a post for students in my database course In the fast-paced world of data, insights are currency, and queries are the keys to unlocking them. For anyone stepping into database design and management, understanding queries isn’t just a technical skill; it’s a fundamental capability that underpins almost every task, from collecting raw information to generating Read More
a post for students in my database course Have you ever wondered how companies like Netflix recommend your next binge-watch, or how your favorite online store knows exactly what you might want to buy? It all comes down to data! In our increasingly digital world, data is everywhere, and the ability to understand, manage, and Read More
A post for students in my database design and management course In the journey from raw data to actionable insights, a critical, often unseen, foundation is the database schema. Think of it as the architectural blueprint that defines how data is organized, stored, and related within a database. Without a well-designed schema, even the richest Read More
Metadata, often dubbed “data about data,” is a concept frequently encountered but sometimes underappreciated in the world of information management. For those of you delving into introductory database design and management, understanding metadata isn’t just a bonus – it’s fundamental to building robust, usable, and future-proof databases. Let’s unpack why this seemingly abstract concept is Read More
In our increasingly digital world, terms like “data,” “information,” and “database” are thrown around with such frequency that they often become interchangeable. However, for anyone working with or seeking to understand the foundational elements of modern technology, differentiating these concepts is not just an academic exercise – it’s crucial for effective communication, sound decision-making, and Read More