SQL COUNT Function Explained with Examples
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.
read more…
SQL INSERT: The Complete Guide
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.
SQL CASE Statement Explained with Examples
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.
SQL DELETE Statement – The Complete Guide
The SQL DELETE statement allows you to delete records from a table. I’ll explain more about the SQL DELETE statement in this article.
SQL TRUNCATE TABLE Statement: The Complete Guide
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.
read more…
SQL UPDATE Statement: A Complete Guide
Have you ever needed to update data that was already in a table? Learn how to do this with the SQL UPDATE Statement.
SQL GROUP BY and HAVING: The Complete Guide
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.
SQL CREATE TABLE Syntax and Examples – The Complete Guide
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.
read more…
Why Use PostgreSQL?
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.
A Guide to SQL NULL (and SQL NOT NULL)
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.
