Queries and SQL

Queries and SQL

1. Queries

   • Databases allow us to store and edit data to find specific information.

2. Query Language

   • Its written language only used to write specific queries.
   • SQL is a popular query language used with many databases.

3. Query By Example (QBE)

   • It allows the user to create queries based on a template, usually a set of filters presented in a graphical form.
   • The system presents a blank record and lets you specify the fields and values that define he query.

4. Data with SQL

   • SQL can be used to add and edit any data stored on a SQL server.
   • To add data, you use the function insert function
   • To edit data, you use the function Update