This tailored course presents the the broad scope of SQL and the skills needed to produce efficient SQL. SQL language, as implemented via SQL*PLUS by Oracle in Oracle, together with PL/SQL programming tools and techniques. The course covers ER design, and explains techniques of normalisation and denormalisation. Delegates will learn how to design and declare tables and how to write effective SQL statements to query, update, delete and insert records into a relational database. The creation and test of Stored procedures and Triggers, using PL/SQL is presented and supported by numerous exercises. Techniques for analysing the efficiency of Queries are described and attendees will also see how to use MS Access to front-end to Oracle for user-friendly support. Oracle 9i and 10g architecture and basic DBA functions including user management, backup and recovery and bulk data-load are also addressed.

• Show how to perform ER modelling
• Explain table structures and relationships and how they affect processing
• Show how to use SQL and PL/SQL safely and efficiently
• Explain how Oracle relational database operates and the resources it uses
• Show how to design and build Stored Procedures and Triggers
• Show how Triggers can be used to maintain data integrity
• Show the Oracle Developer toolset
• Show how to use Excel / Access to perform user-friendly Oracle operations
• Show how to manage and Oracle installation, including
  • User management
  • Tablespace management
  • Backup / Recovery
  • Bulk data load
  • TNSListener
  • SQLPlus and SQL Worksheet / SQL Developer
  • Users, roles and Permissions

• Audience familiar with database technology and with a need to understand development and use of SQL and relational databases.

• The need to access data from a relational database
• Some exposure to SQL techniques