Flat File versus Relational Databases

Flat files are the most basic form of database - all of the information is stored in a single file. A flat file includes a field for every item of information that you need to store. While they are easy to create and can be useful in certain situations, flat files are not very efficient. They can be quite wasteful of storage space, containing a lot of duplicated information, especially in a complex system where multiple files hold connected information. This can make information harder to...

Selecting Data From the Database

You are probably already aware of the most basic type of SQL statement the SELECT statement. Use the SELECT statement to retrieve records from a database. For example, if we want to see all information in the Products table, we would run the following SQL statement The asterisk above designates that we want to see all fields in the Products table. If, instead, we only wanted to find the name of the product, the price, and units that are in stock, the SQL statement below would accomplish this...