Wednesday, 17 September 2014

DDL, DML and Basic SQL

We will look at the SQL language and the fact that we have the two parts in the DDL and DML.

This lesson will focus on DDL and how we can create the structure of our database.

Todays Task

I would like this following questions answered on a Powerpoint please and emailed to me.  You then need to upload ontop your G Drive and link to and label on your blog.

What does DML stand for and what does it do?

What does DDL stand for and what does it do?

Be able to explain the terms record, field, table, query, primary key, relationship, index and search criteria. (Text and Picture on each slide)

Be able to create simple SQL statements to extract, add and edit data stored in databases

Notes from todays lesson

also use the BCS Glossary in your classroom

No comments:

Post a Comment

Wildern Pupils if you log onto your school email account you can leave a comment via that ID.