BTEC Nat for IT Practitioners - Unit 13 Database Management Systems
Visited times
Remember the Policy adopted by your tutors is quite simple .... If a document relating to your course of study has been published on THIS WEBSITE, then we ASSUME YOU HAVE READ IT. This means that YOU CANNOT claim to NOT know about any topic that is covered on this website which relates to your course of study.. YOU have already SIGNED an agreement under the college LEARNER CODE OF CONDUCT that clearly states YOU are solely responsible for YOUR OWN LEARNING (with the support of your tutors). So make sure that you download , print and work through ALL the support notes and documents from this website that relate to you and your course. If you do this then your grades will improve dramatically .......kind regards .... Paul Bolger ...... 
Unit13 - Course Notes and Resources
   
Part 2 SQL Scripts
   
Structure of SQL:  
  DML statements in each group
  DDL and DCL statements in each group
  SQL statements in each group
   
Database administrator (DBA): 
  makes use of DDL and DCL
   
DML statements 
  : database users and applications developers
   
Use of DML statements including keywords:  
  select
  from
  where
  group by
  having
  order by
   
Notes  
  01 - sql overview
  02 - dml commands 1
  03 - dml commands 2
  04 - ddl commands
  05 - sql quick reference
   
Worksheets  
  exercises - ddl create command
  exercises - dml select command
 

example - access files needed for create and select tutorials (rename extension to .exe before running )
  sql quiz questions