SQLConfiguration SQLConfiguration


Basic Queries  «Prev  Next»
Lesson 8

SQL Capability Conclusion

SQL has significant capability for accessing and manipulating data.
The really good aspect is that most routine database tasks using SQL are easy to perform. Later in this course, you will use the phpmyAdminSQL to build advanced SQL queries.
This module introduced some of the fundamentals of SQL that you will need in order to incorporate basic database functionality into the VirtualBookShelf.com application. Key statements and clauses are listed below:

Key statements

  1. SELECT
  2. DELETE
  3. INSERT

Key clauses

  1. ORDER BY
  2. WHERE
  3. SET

Glossary

This module introduced you to the following terms:
  1. ActiveX Data Objects: A set of Component Object Model (COM) objects that provides an easy-to-use, scriptable interface to data sources
  2. comparison and logical operators: Characters used to form expressions. Comparison operators compare two values or expressions. Logical operators, sometimes called Boolean operators, produce a logical TRUE/FALSE result.
  3. connection object: An Active Data Object that is used to establish and maintain connections to data sources.
  4. swap space or swap file: Disk space used by the operating system to temporarily remove information from main memory.
  5. production database: A database in use in the production environment
  6. recordset object: An Active Data Object that it used to retrieve, modify, display, and navigate recordsets.
  7. SQL clause: Used to provide more specific instructions in a statement.
  8. syntax: The rules used to form a statement.
In the next module, Visual Studio's drag-and-drop features and Design-Time Controls to display data in Web pages will be discussed.

Essential SQL - Quiz

Click on the quiz link below to test your understanding of these concepts. 
Essential SQL - Quiz