Other slides in this set

Slide 2

Preview of page 2

Here's a taster:

What is SQL?
· this is a query language
· used for accessing and modifying information in a
database
· provides an interface to relational database systems
SQL is made up of three parts which are DDL, DML &
DCL
What is DDL?
· stands for data definition language
· allows users to define the database
· examples are the create table, create index, alter and
drop statements…read more

Slide 3

Preview of page 3

Here's a taster:

What is DML?
· stands for data manipulation language
· these command's manipulate data within existing
databases objects
· examples are the select, update, insert, delete
statements.
What is DCL?
· stands for data control language
· is a computer language for controlling access to data
in a database
· examples of DCL commands are grant and revoke…read more

Slide 4

Preview of page 4

Here's a taster:

In this glossary I will describe the meanings for the
following definitions of DML statements:
· select
· from
· where
· group by
· having
· order by…read more

Slide 5

Preview of page 5

Here's a taster:

is used to retrieve zero or more rows from one or more
tables in a database. In most applications, SELECT is
the most commonly used Data Manipulation Language
command.
Example:
SELECT initial, surname, age, sex FROM client
This is just selecting different fields from the client
table, then putting them into a new table…read more

Slide 6

Preview of page 6

Here's a taster:

is used to indicate from which tables the data
is to be taken, as well as how the tables join
to each other.
Example:
SELECT initial, surname, age, sex FROM
client
This is just selecting different fields from the
client table, then putting them into a new
table…read more

Slide 7

Preview of page 7
Preview of page 7

Slide 8

Preview of page 8
Preview of page 8

Slide 9

Preview of page 9
Preview of page 9

Slide 10

Preview of page 10
Preview of page 10

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all resources »