FB
SQL Window Functions: The Ultimate Guide

SQL Window Functions: The Ultimate Guide

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.

read more…

MySQL Show Users: A How-To Guide with Examples

MySQL Show Users: A How-To Guide with Examples

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.

read more…

SQL Get Current Date

SQL Get Current Date

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 Commands: A List with SQL Syntax

SQL Commands: A List with SQL Syntax

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.

read more…

SQL Create Database: A How-To Guide

SQL Create Database: A How-To Guide

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.

read more…

How to Insert Multiple Rows in SQL

How to Insert Multiple Rows in SQL

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.

read more…

Ben Brumm
Ben Brumm
DatabaseStar

Database Star Academy:
Login

Oracle SQL Expert

Oracle SQL Associate

Popular Posts

Database Normalisation
Introduction to Oracle SQL
SQL Joins
Database Developer