-
TheCodersCatnip – Intro to Data Analytics Chapter 1 Notes
What is Big Data? Data Analysis vs Data Analytics Four Categories of Analytics Business Intelligence (BI) Key Performance Indicators (KPIs) The 5 V’s of Big Data Data Types Continue reading
-
TheCodersCatnip – SQL Notes Chapter 1
Database: a storage structure that provides mechanisms for recording, manipulating, and retrieving data. A collection of interrelated files—such as those relating to customers, their purchases, and their payments—is stored in a database Database Management System (DBMS): is used to create and maintain the structure of a database, and then to enter, manipulate, and retrieve the… Continue reading
-
The Coder’s Catnip – Ever Since Maple
Who knew MapleStory would start me on the path to a career in data? While my friends focused on leveling up their characters and acquiring rare items, I was fascinated by the databases behind the scenes that made the game work. When my friend Ben demonstrated how editing items and character attributes via SQL allowed… Continue reading
-
The Coder’s Catnip: Referential Integrity and Cascading in Data
Referential integrity is a fundamental rule in maintaining relationships in a relational database; it defines interactions between primary keys and foreign keys. It ensures data accuracy and reduces errors by linking such keys from different tables or within a single table. By enforcing referential integrity, fundamental operations such as insertion, updating, and deleting are appropriately… Continue reading
About Me
![](https://thecoderscatnip.files.wordpress.com/2023/08/wp-1692042431535-edited.jpg)
I’m always on the lookout for fresh learning materials. Whether it’s blogging, data science, productivity, personal growth, AI, or coding. If that piques your interest, sign up for my Newsletter and connect with me on social media to stay updated!
(ノ◕ヮ◕)ノ*:・゚✧