Ronnie Payne

In relational databases, the SQL ORDER BY statement is a powerful tool for sorting data in a table. The statement is used to arrange queried data into rows in a specific order, based upon one or more columns. In this database programming tutorial, we will learn how to use the SQL ORDER BY statement to […]

In SQL and relational databases, NULL values are an important part of managing data and information stored in SQL tables. A NULL value is used as a placeholder for missing values or values that are unknown in a database column or cell. Understanding how to handle NULL values is important for database developers who want […]

In a previous tutorial, we learned how to work with the WHERE clause in SQL, which database developers can use when they wish to retrieve a group of records that meet a certain criteria or condition. For instance, a database administrator may wish to find every instance in a database where a user’s name is […]

In SQL, data types help to define the type of value that can be stored in a database cell, or, more specifically, in a column. There are many kinds of data types in SQL and in this database programming and administration tutorial, we will look at each one and learn their syntax, how to use […]

When querying a relational database, database programmers and administrators will often need to filter the records returned or extract specific records that meet a given criteria. In this database programming tutorial, we will look at the SQL WHERE clause, learn its syntax, and preview several code examples showing its use. Read: How to Use the […]

PostgreSQL is one of the world’s most widely used database systems in the world, offering support for not only structured query language (SQL), but JSON as well, making it a great choice for database-driven enterprise applications. In this database programming and database administration tutorial, we discuss what PostgreSQL is, its relation to SQL, and the […]

If you are new to database administration or database development, you have no doubt heard the phrase “relational database management system” being tossed around. As database programmers or those that work with databases, we tend to think of database systems in terms of languages or platforms, like SQL, MySQL, or T-SQL. In today’s database programming […]

Structured Query Language (SQL) is a simple, yet powerful database programming and administration language used to manipulate data stored in a relational database or relational database management system (RDBMS). It is easy to learn compared to a lot of traditional programming languages. While that is great for both new database developers and veterans alike, it […]

Regardless of the programming language you operate in, code can quickly become cluttered, unreadable, and difficult to understand. This issue is particularly compounded when you consider that every programmer has their own unique coding style and “best practices”, so the logic one developer uses (and thus, how they code things) might be different than your […]

In a previous tutorial, we discussed how to use the SQL SELECT statement to return values from a table. In today’s database programming tutorial, we will learn how to use the SELECT DISTINCT statement to return only distinct – or unique – values from a table. You can read about regular SELECT SQL statements in […]

In this database programming and database administration tutorial, we are going to answer the commonly asked question: What is MySQL? We will discuss its features, pros and cons, benefits, and how it fits into the mold of traditional relational database management systems (RDBMS). Looking to learn MySQL in an online class or online course environment? […]

Database administrators – or those that handle the administrative tasks associated with running a database system, rely on a database programming language to issue queries to retrieve and manipulate data from their respective database. Database programmers, data analysts, data modelers, and anyone who needs to access the information stored in a relational database management system […]