Excel possesses formidable database powers. Creating a relational database starts with a Master table that links to subordinates called (awkwardly) Slave, Child, or Detail tables.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

Get up to speed on MySQL basics with this step-by-step tutorial on how to create a database, add a table, and input data into the table.

Creating a new table from query results can help you build a database of your clients, employees, expenses and other business details by allowing you to select certain columns from existing tables.

Use this form when you want to create a new table with columns that are not present in existing tables. It is also useful if you are running SQL statements from an SQL application in another SQL-based ...

Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

The following example shows how to read DBMS data into SAS and create additional variables to perform calculations or subsetting operations on the data. This example creates the SAS data set ...