June 19th

STARTER

In your exercise books complete the following:

1. Express 23 as a Hex?
2. Express 23 as an 8 bit binary?
3. Express 123 as a Hex?
4. Express 123 as an 8 bit binary?
5. Express 10100011 as a Hex?
6. Express 11101011 as a Hex?
7. Express 10101011 as a Hex?
8. Express 11101011 as a Hex?
9. Express 11100111 as a Hex?
10. Express 11111011 as a denary?

Tip: for questions 5-9 split into two nibbles and show working.

Work through the SQL TUTORIAL –

1.       Practise each example in the simulator

2.       In your exercise books make a note of the key word syntax.

YOU SHOULD AIM TO FINISH THE WHOLE COURSE – HOWEVER IN TODAY'S 

LESSON MAKE SURE THAT YOU GET AS FAR AS CHAPTER ABOUT 'DELETE'.

Home

http://www.w3schools.com/sql/default.asp

Intro

http://www.w3schools.com/sql/sql_intro.asp

Syntax

http://www.w3schools.com/sql/sql_syntax.asp

Select

http://www.w3schools.com/sql/sql_select.asp

Distinct

http://www.w3schools.com/sql/sql_distinct.asp

Where

http://www.w3schools.com/sql/sql_where.asp

AND & OR

http://www.w3schools.com/sql/sql_and_or.asp

ORDER BY

http://www.w3schools.com/sql/sql_orderby.asp

INSERT

http://www.w3schools.com/sql/sql_insert.asp

Update

http://www.w3schools.com/sql/sql_update.asp

Delete

http://www.w3schools.com/sql/sql_delete.asp