Introduction to ANSI SQL

   View / print PDF course outline.

Duration:   2 days

Participants:   IS personnel and end users.

Objectives:   Upon successful completion of this course you will be able to: -  Code ANSI standard SQL (Structured Query Language) select, insert, update, and delete statements to access and update tables. -  Understand the fundamental concepts of a relational database and describe the relational data model. -  Distinguish between ANSI standard and product-specific SQL.

Overview:   -  This is an introductory SQL course, designed for those who need to learn ANSI SQL as a prerequisite for a course in a specific relational database product. -  ANSI SQL is not a prerequisite for our DB2/SQL Application Development nor for our QMF Workshop courses, as these courses already contain the introductory material found in this SQL course.

Prerequisites:   None.

Format:   Lecture and discussion with hands-on exercises.

Topic Outline:   -  Introduction to Relational Databases         Database defined         Concepts of the Relational Data Model         Data structures              Implementing the Relational Data Model              Table, columns and rows              Data types              Example of creating a table              Example of selecting data         Overview of objects         Structural vs value-driven tabular format         ANSI Standard SQL         History of SQL         SQL3 -  Structured Query Language         Basics of SQL         Simple SELECT statement              Definition of terms              Statement syntax              SELECT parameters:  Column list, FROM, WHERE, ORDER BY              Simple predicates         Executing interactive queries         Predicate logic         BETWEEN, IN, LIKE         Compound search conditions:  AND, OR, Parentheses         Column functions         Scalar functions         Eliminating duplicate rows         Effect of NULLS         Date and time considerations -  SQL Data Manipulation         INSERT statement         Multi-row insert processing         UPDATE statement         Restrictions on updating primary key         DELETE statement -  Advanced SQL         Join              Cartesian product              Equijoin              Natural join              Greater than join              Joining rows of the same table              Outer joins         Union              Union of two SELECTs              Union with ORDER BY              Union coding rules         Subqueries         Subqueries vs joins         Correlated subqueries         EXISTS operator

Mainframe List       Database List       Course List       Site Map       Home