Introductory SQL

Overview
This course presents the SQL language, its basis and current versions. It is designed to take users at all levels of experience to a competent level of SQL knowledge.

Course objectives
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. Attendees will also see how to use MS Access to front-end to MS SQL Server database. Extensive exercises and reference materials are provided.

Who should attend
Management wanting to familiarise themselves with database technology; users needing an introduction to modern relational databases and staff who are cross training into an IT career.

Pre-requisites
The need to access data from a relational database; experience with accurate entry of information into PCs.

Course synopsis

• Overview of relational databases
• 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.
• Be familiar with the various forms of the SQL Query
• Use SQL to protect the database from incorrect updates