This
Section is optional - if you have completed all of the work to date and wish
to begin an exploration of SQL, please work through this section. Not completing
this work will not affect your final mark in any way, however, if you are planning
on studying database design on an undergraduate course, you will probably encounter
SQL. This section does not attempt a comprehensive coverage of the subject,
rather it attempts to use Access to give you a "feel" for the language.
Aims of Session:
You will be able to:
- Describe the origins and purpose
of SQL
- Describe the main DML, DDL and
DQL SQL statements
- Use SQL statements to select subsets
of data
- Use the SELECT statement to filter
columns
- Use the SELECT statement to order
output
- Use the JOIN statement to create
VIEWS
