SCStephen Campbellinsdcampbell.hashnode.dev·Jun 13, 2024 · 6 min readBuilding and Managing Your Database with SQLWhen working with SQL, it’s crucial to understand how to both build and manipulate tables. This knowledge allows you to effectively manage your data, ensuring it stays clean, up-to-date and relevant. In this post, we’ll cover the basics of four essen...00
SCStephen Campbellinsdcampbell.hashnode.dev·Jun 11, 2024 · 5 min readSQL JOINS Explained: Inner, Outer, Left & RightWhen working with databases, you often need to retrieve data from multiple tables. This is where SQL JOINS come in handy. JOINS allow you to combine rows from two or more tables based on a related column between them. Here are a few of the basic 'JOI...00
SCStephen Campbellinsdcampbell.hashnode.dev·Jun 3, 2024 · 5 min readUnderstanding Basic Data Types in SQLContinuing on from the previous blog (here), I wanted to discuss some of the basic data types that you're likely to come across when writing queries in SQL. When you’re just starting out with SQL, understanding data types might seem a bit daunting. B...00
SCStephen Campbellinsdcampbell.hashnode.dev·May 31, 2024 · 5 min readGetting Started with SQL QueriesThe Basics We are going to start from the beginning in the world of databases known as Structured Query Language (SQL). SQL is a powerful tool that allows you to interact with databases, retrieve data, and perform various operations to get the result...00
SCStephen Campbellinsdcampbell.hashnode.dev·Sep 18, 2023 · 6 min readLevel up your React componentsWhile I may be a noob in tech, I love that it allows me to write soooo much bad code. Seriously. Sometimes I just avoid my old repos because it's just that bad, even now. But, what I love, is that when I do get brave enough to open those repos, it gi...00
