What is an SQL window function? Why should you know about it? And what can it help you with?
You may have heard of SQL window functions before, or they may be completely new to you.
Learn all about them in this guide.
A common question when using MySQL is how to show all users on the database.
In this guide, you’ll learn how to see a list of users. You’ll also be able to see a list of logged-in users as well as the current user.
Let’s take a look.
Do you need to find the current date using SQL?
There are a few ways to do this in the various database vendors.
Let’s take a look at them. read more…
SQL, or Structured Query Language, contains a range of commands for interacting with the database. This article lists all of those commands, what they do, and what they look like.
All of these basic SQL commands work on Oracle, SQL Server, MySQL, and PostgreSQL, unless otherwise indicated. The reason that all commands don’t work on all databases is because some commands are not part of the SQL standard and the database vendors have chosen not to implement them.
Let’s take a look at the SQL commands and the SQL syntax for them.
Creating a database is one of the first things you do when setting up a new project or installing database software.
Whether you’re using Oracle, SQL Server, MySQL, or PostgreSQL (or any other database), you’ll need to create a database at some point.
A database is a collection of tables and other objects. Many database vendors allow you to have multiple databases as part of the overall database engine.
Let’s take a look at the create database process.
SQL auto increment is a feature that allows you to generate a unique number when inserting rows.
Learn how to set this up in SQL Server, MySQL, PostgreSQL, and Oracle in this article.
Do you need to insert multiple rows into an SQL database?
You could do that separately using INSERT statements, but there are a few problems with this.
Learn what these problems are and how to insert multiple rows in SQL in this article.
Cursors are a feature in many SQL databases that allow you to work with data.
They exist in SQL Server, Oracle, MySQL, PostgreSQL, and likely many other databases.
But what is an SQL cursor and how do you use them?
Let’s learn all about them in this guide.
INT is short for integer, and is a group of data types in many databases that store numbers. There are many INT data types in the major SQL databases.
In this guide, you’ll see all of these INT data types, see their restrictions, and how they compare between databases.
Let’s take a look.