This course presents the SQL language, its basis and current versions. Delegates will learn how to declare tables and how to write effective SQL statements to query, update, delete and insert records into a relational database. Efficiency issues and tuning aspects of Query writing are covered. The course also shows how Microsoft Access can be linked (via Pass through Query) to RDBMS. Transact SQL (T-SQL) is included so that delegates will understand when this powerful language should be used in Stored procedures or Triggers and sensible applications.
Basic administration operations are covered, for those organization operating with minimal DBA support. Topics including user-management, backup and recovery are covered.

The host database for this course can be selected from MySQL 5.0 and later, Oracle9i or 10g, or MS SQL Server 2000/2005 and there are extensive exercises provided for each.

• Explain the reasons for SQL
• Understand relational databases, in theory and practice
• Write SQL statements to query relational databases
• Write SQL statements to insert, modify or delete records
• Understand how to join multiple tables and why this is necessary.
• Use SQL to protect the database from incorrect updates
• Be able to define Views
• Understand the use of Data Control Language
• basic database administration, such as user-management, table design, performance monitoring
• Link MS Access as an efficient front-end to MS SQL Server
• Understand T-SQL and its use in Stored Procedures and Triggers

• Management wanting to familiarize themselves with database technology
• Users needing to extend their knowledge of modern relational databases
• SQL Users who need to understand design and performance issues
• Staff needing to address SQL2 and SQL3 standards.
• Staff who are cross training into an IT career.

• The need to access data from a relational database
• Experience with accurate entry of information into PCs.
• The course is designed to take users at all levels of experience to a competent level of SQL knowledge.