Microsoft's SQL Server has a handy command that rebuilds all indexes in a table. Oracle users typically rebuild each index in a table individually.

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

Variations on SQL are used by some of the most popular database tools in the world, including some of Oracle's database systems, MySQL, PostgreSQL and Microsoft's SQL Server.