The Oracle ALTER TABLE statement allows you to make changes to an existing table. Learn how to use it and see some examples in this guide.
Data warehouses are an important part of a business.
As a developer, you’ll be involved in the data warehouse in one way or another: creating it, designing it, accessing it, or working on software that provides data to it.
Learn all about data warehouses in this guide.
How can you delete a table in SQL? Learn how to do this by using the SQL DROP TABLE statement in this article.
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.