Sumit Mondalsumit007.hashnode.dev·Apr 19, 2024A Beginner's Guide to Implementing Amazon RDS in AWSAre you looking to level up your database management game in the cloud? Amazon RDS (Relational Database Service) in AWS might just be your golden ticket. Whether you're a seasoned developer or a newcomer to the cloud ecosystem, Amazon RDS offers a us...DiscussAWS - HandsOnAWS
Victor Ndutidatacurious.hashnode.dev·Apr 11, 2024Database Creation : Relationship MappingBuilding on our exploration of converting requirements files to ER diagrams, this sequel dives into transforming those diagrams into relational models. We'll explore how to capture the relationships between entities and translate them into a well-str...DiscussRelational schema
Victor Ndutidatacurious.hashnode.dev·Apr 3, 2024Database Creation From ScratchHave you ever been tasked with building a database but felt overwhelmed by the initial requirements file? Translating those requirements into a functional database can seem daunting. But fear not! In this blog series, we'll break down the process int...Discuss·32 readsERDiagrams
Gavin Esplingavinonrails.hashnode.dev·Mar 22, 2024Build a Fullstack Rails App: Part One - Overview & PlanningIntro This series of posts is intended to walk someone new to Rails and web application development through building a somewhat simple app. What this isn't is a full course, explaining in detail each piece of tech we use, but there still we be some b...DiscussRuby
Akhil Kadangodeakhil.se·Mar 6, 2024To JOIN or not to JOIN: Reviewing MySQL JOINsIn database management and manipulation, SQL stands as a cornerstone, empowering developers, data analysts, and database administrators with the ability to seamlessly interact with relational databases. Among the features that SQL offers, joins repre...DiscussMySQL
Victor Ndutidatacurious.hashnode.dev·Mar 5, 2024Setting up MySQL and MySQL Workbench Locally on WindowsAs we venture through the vast landscape of relational databases, two stalwarts emerge to guide us – MySQL and its trusty sidekick, MySQL Workbench. In this walkthrough, we'll navigate the steps to set up this dynamic duo within your Windows playgrou...Discuss·70 readsMySQL
SOURAV BERAsouravtechzone.hashnode.dev·Feb 29, 2024Mastering Database Design: Navigating Anomalies and NormalizationSituation: Imagine you're tasked with developing a database system for a new e-commerce platform. Your goal is to create a robust and organized database structure that can efficiently handle large volumes of transactional data while ensuring data int...Discuss·1 likeAnomalies
Shivanagouda Agasimanishiva02.hashnode.dev·Feb 26, 2024Row vs Column-Oriented (Columnar) DatabasesPrerequisites: Databases, Paging in memory management You'd have come across different types of databases like Relational (MySQL), Document (MongoDB), Graph (Ne04j), Columnar (Cassandra), Key-Value pair (Redis), and some other types. But in this arti...Discusscolumnar dbs
Fawad Hanifblog.fawad.cloud·Feb 23, 2024Mastering SQL: Advanced Tips and Tricks for Data AnalystsIntroduction to SQL for Data Analysts SQL (Structured Query Language) serves as the backbone of data analysis, providing a powerful toolset for retrieving, manipulating, and analyzing data stored in relational databases. For data analysts, mastering ...DiscussSQL
Ijlal Ahmadijlalahmad.hashnode.dev·Feb 21, 2024Deeply Nested Comments ArchitectureOverview Ever wondered how nested comments are implemented? Some sites like YouTube or Instagram limit the level of nested comments to only one level. However, platforms like Reddit or Facebook took nested comments to a whole new level, allowing user...Discuss·2 likes·54 readscomments