Plus Plus Pty Ltd

This course covers a basic understanding of database design, and how to use SQL to select and update data.

Upon successful completion of this course you will be able to:

• Describe a relational database
• Describe database normalisation
• Describe what SQL is and what it's for
• Use SQL commands to:
• Display data (SELECT)
• Choose particular data to display (field (column) names, WHERE and ORDER BY clauses)
• Create sophisticated queries to join tables (JOIN)
• Create sophisticated queries to group and total data (GROUP BY, HAVING)
• Update data (INSERT, UPDATE and DELETE)

This course is aimed at people who want to learn the basics of database design and SQL. Experience with SQL or programming is not necessary.

Basic computer ability with a keyboard and mouse is needed.

Database design

Selecting data

Updating data

Sophisticated SELECTs

Introduction to Programming (1 day)
Introduction to Perl (2 days)
Introduction to Python (2 days)
PL/SQL (2 days)