SQL Tutorials

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…

SQL UPDATE: A Guide

How to Use the SQL UPDATE Statement One of the core features of databases is that stored values can be updated. You can change the values of any record in a database at any time. Values inside an SQL database…

SQL Comments Using Single- and Multiline Comments

There are two types of comments in SQL statements: single-line and multi-line. We’ll take a look at these in our article with an example of each and discuss why we might use comments When we make comments in our code,…

How Is SQL’s Not Equal Operator Used?

The SQL not equal operator is a comparison operator that is used to find rows in a relational database. In this article, we’ll take a look at how it’s used. The Syntax Let’s take a look at a typical query…

SQL ALTER TABLE: A Guide

Once you have created a table in SQL, you may realize that you have forgotten to add in a column or a constraint. Or maybe you have assigned the wrong name to a column and want to delete it from…

Learn SQL: A Guide to Learning Structured Query Language

How to Learn SQL Whether you’re interested in becoming a database developer, a data analyst, or just want to work with stored data in an application, having knowledge of databases is crucial. Structured Query Language, or SQL, is an in-demand…

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.