The SQL COUNT function is one of the most common functions used by SQL developers. I use it on a daily basis. Learn more about the COUNT function in this article.
The SQL INSERT INTO statement is one of the most popular commands in SQL, and it’s one of the first commands you learn to use. Read how to insert data and how to use the full functionality of the INSERT statement in this guide.
The SQL CASE statement allows you to perform IF-THEN-ELSE functionality within an SQL statement. Learn more about this powerful statement in this article.
The SQL DELETE statement allows you to delete records from a table. I’ll explain more about the SQL DELETE statement in this article.
The SQL TRUNCATE TABLE statement is a useful statement for removing data in SQL. I’ll explain what the statement does and show you some examples in this article.
Have you ever needed to update data that was already in a table? Learn how to do this with the SQL UPDATE Statement.
The SQL GROUP BY clause and SQL HAVING clause are powerful clauses, especially when analysing large amounts of data. Learn what the GROUP BY and HAVING clause is and everything you can do with it in this article.
Creating database tables in SQL is one of the most common tasks a developer or DBA does in a database. Learn how to create tables, what the syntax is, and see some examples in this article.
PostgreSQL is a free and open-source database management system. It’s commonly referred to as an alternative to MySQL or MariaDB.
Are you thinking about using PostgreSQL for your own project? Or are you researching databases to use for a project at work? Are you trying to convince someone else why PostgreSQL is a good choice?
If so, read on to find out why using PostgreSQL is a good idea.
The concept of NULL is something you should know about when working with databases.
In this article, you’ll learn all about NULL: what it is, why it’s different, how you can check for it in different databases, and many examples.