W3 Schools SQL

For this assignment we are to capture the graphic that shows our score and post it to this section along with a brief overview that explains what we learned. Below are the requirements met for this assignment.

Strcutured Query Language (SQL) lets you access and manipulate databases. With SQL you are able to do a number of things pertaining to accessing and manipulating databases. Such things include: executing queries against a database, retrieving data from a database, inserting records in a database, updating records in a database, deleting records from a database, creating new databases/new tables in a database, and setting permissions on tables, procedures and views. Examples are provided below:


Example of SELECT Statement

The SELECT statement is used to select data from a database.

My Pic


Example of ORDER BY Statement

The ORDER BY keyword is used to sort the result-set in ascending or descending order.

My Pic


Example of DELETE Statement

The DELETE statement is used to delete existing records in a table.

My Pic


Example of BETWEEN Operator

The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates.

My Pic


SQL Quiz Score

My Pic
My Pic