Getting down to the use of join, using SQLite.
When learning SQL, aka Structured Query Language, one of the most important concepts to gain an understanding of, is using joins. In this blog, I will break down the different join types, why they are relevant, and how you may implement them yourself.
Just a quick recap, SQL helps us handle data with relational databases. When it comes to having different tables in a database, we need to find a way to connect the tables’ data, and this is where joins come in to save the day!
Among the different tables…
An Introduction to Design Patterns.
In a recent mock technical interview, the interviewer mentioned understanding design patterns is important to have a grasp as a developer in the field. I thought it would be worthwhile to understand design patterns in software engineering a bit more.So, let’s see what they are all about!
Overall, design patterns are actually somewhat straightforward, they are documented solutions to commonly occurring problems in software engineering.They can be extremely useful when used in the right situation. They are usually implemented when people notice a problem with their design, i.e. having an issue with runtime/performance, or when…
Node.js: The Highly Efficient Backend Runtime Environment
I don’t know about you, but as a recent coding boot camp grad, I find myself overwhelmed with the amount of possible new technologies to learn day in and day out. There are so many crayons in the web development tool crayon box I want to pick up and learn to use, and I’m taking it week by week to decipher what to take on learning next!
Based on conversations I’ve had in the tech space, in interviews, and coffee chats, I’ve decided to learn Node.js. …
For anyone out there finding themself wanting to learn SQL and wondering what it is, or how to begin to use it, this is the blog for you! I’m going to dive deeper into the world of SQL with you. Here we go!
SQL stands for Structured Query Language.
It is pronounced “Sequel” or “S-Q-L”. Fun right? We like options. So in particular we find we use SQL to manipulate and access a database, in particular with relational databases. A query language like SQL is a language that’s designed to facilitate us in retrieving specific data from a database. …
Recently in my job search, I had an interview and was asked what I deemed to be an interesting interview question. So, I decided I wanted to open the book wider on the topic!
See in this code example what JSON object looks like:
Part 2: What is Object-Oriented Programming?
Encapsulation: will allow for us to cut down on a function’s number of parameters.
In object-oriented programming, we combine a group of related variables and functions into a unit. AKA an object. Our variables are referred to as properties, and functions are referred to as methods.
A programming paradigm. [ a paradigm is a standard, perspective, or set of ideas, a model. ] It is a style of coding, a specific way to organize your code and approach code. You might say it’s even more of a mindset.
In functional programming, we want to express everything with functions. Not a huge surprise here, but this is the truth of it. Of course, a function is something that takes an…
My developer friends, what I’ve learned along the way this week is that creating a portfolio website can be a lot of fun.
So let’s say you recently graduated from a coding Bootcamp? Or maybe you want to shift the developer roles you’re being considered for. Whatever it is, it may be time for a portfolio website facelift or a complete overhaul.
Up until September my website creator of choice has been Wix. It’s easy, accessible, reliable, and come on it looks super snappy! One downside is well, you have to pay either monthly or yearly for it. Since graduating…
Why be aware of what a closure is?
What is a closure?
A closure is a combination of a function bundled together (enclosed) with references to its surrounding state.