Griffin Software Home
Training ServicesCoursesFacilitiesConsultancy Services
Course List
Linux & Unix
Solaris TM
Oracle TM
Contact Us


SQL Fundamentals

This 3 day course is an introduction to the SQL database query language. After this course the student will be able to use SQL to define, manipulate and control access to their data. The course thoroughly covers SQL syntax and facilities. The basis of the SQL language can be applied to all modern relational databases and as such, this course is relevent to those wishing to work with SQL Server, Oracle, MySQL, Informix and most other database management systems. The small differences and subtleties of specific environments will be discussed and explored.
The course begins with a general introduction to databases, including the principles of relational databases. Data retrieval is discussed in depth, covering all of the pertinent features of SQL, including joins. Data Manipulation Language is covered, including inserting, updating and deleting data. Transaction control and locking is discussed. Data Definition Language is covered, including creating, altering and dropping tables, and the use of integrity constraints. Those attending this course require general familiarity with computers and data processing.

Course Objectives:
For each delegate to gain an in-depth understanding of SQL - concepts, syntax, uses and to use hands-on SQL to access databases.

click here for course content detailsCourse Summary:
  • Relational Database Basics
  • Simple SELECTs
  • Advanced SELECTs
  • Subqueries, Joins and Unions
  • Conditional Processing with 'CASE'
  • Data types in more depth
  • Creating Databases and Tables
  • Creating Indices
  • Applying constraints

Back to top
© 2018 Griffin Software Ltd - All Trademarks acknowledged (3.16). Griffin Software Ltd, Tel: +353 (1) 4622277