SQL Tutorials

SQL EXISTS: How to use this SQL Operator

There are many things you can do to define a query in SQL. One thing you can do to a WHERE clause is check to see if a row exists with the matching parameters in the database. We do this…

Learn SQL: A Guide for Beginners

Having knowledge of databases is crucial if you want to explore a career in data. Whether you want to be a data scientist or an engineer, databases will come up at some point. Structured Query Language, or SQL, gives developers…

SQL Triggers

An SQL Trigger is an event that sets off a number of other events that happens when a user interacts with a particular table. This particular SQL statement helps by validating form data, or enforcing rules. A trigger is executed…

Using MySQL’s IF(), NULLIF(), and IFNULL() Functions

Just like other programming languages, the structured query language has conditional statements that control the flow of data. The IF function returns a statement if condition is met and another type statement (or none at all) if not met. Let’s…

SQL Substr() Function

Sometimes we need just a portion of a string value in our data to display. There is a string function we use called SUBSTR(). There is also an equivalent function called SUBSTRING(). In this article, we cover using this substring…

SQL Having

SQL has different types of operations used to make queries to a database. SQL’s HAVING statement works like a subquery on top of an initial query. It works well when you have an overwhelming amount of entries that have one…

SQL – Contains

There are many SQL statements and functions to query your database and retrieve or figure out useful information. One such function is the CONTAINS() function. This particular statement is not a standard SQL function – depending on which database you…

How to Build a Query Using the SQL Concatenate Function

When working with queries, sometimes we need to take raw data from our database and reformat it in a different way for use elsewhere. In this article, we look at a couple of functions in MySQL to help us work…

SQL Aliases for Beginners

SQL aliases are like human aliases. They assign a temporary name to a table or a column in a table. Aliases are useful because they help make queries and their results more readable and easier to interpret. In this guide,…

How to Use the SQL SELECT Statement

Databases do not just store information, they make data easily accessible. With a little help from the SELECT statement, you can retrieve any set of values from a database that you need. In this guide, we’re going to discuss what…

Get matched modal

Find the best bootcamp for you

Our matching algorithm will connect you to job training programs that match your schedule, finances, and skill level.