Introduction to SQL with KB_SQL

Course Length: Approximately 40 hours
Prerequisites: The student should have a good understanding of computers and programming techniques

The SQL course is intended as a guide to ANSI SQL (Structured Query Language) and to serve as an introduction to the KB_SQL implementation. The basic uses of SQL are discussed through a series of example database definitions, queries and updates.

The fundamentals of relational databases are shown, including base tables, virtual tables and views. The user is taken through the operation of Cartesian products, restrictions, projections and joins. The understanding of these operations is then used to further understand the relationships between tables. Once the theory is mastered, the syntax is explored. Each of the three categories of SQL commands is covered separately: Data Definition Language, Data Manipulation Language and Data Control Language.

In the DDL section, data definition is explained through creating, altering and deleting base tables. The physical nature of base tables is discussed. The DML section is organized around the selection and manipulation of data. The process of changing and selecting data in base tables and the resulting virtual tables is shown. Cursor and non-cursor operations are discussed, showing how they are used. Data control is an important component of SQL. The granting of privileges both in base and virtual tables is discussed, along with its implications. The unit on queries and views is built based upon previously learned concepts. The effect of data manipulation and selection of views is discussed. Changing data according to views and its effect on other views and the base tables is shown. The KB_SQL language and its extensions are covered. The EZQ query processor is discussed and the reporting capability of KB_SQL is explored. The relationship between SQL, KB_SQL and the M database is shown.

Upon the completion of this course, the student should be able to:

• Understand fundamental relational database concepts
• Explain the overall usage of the SQL language
• Describe and use the Data Definition Language to create, delete and alter base tables
• Describe and use the Data Manipulation Language to select data from base tables, form virtual tables, and manipulate the data
• Describe and use the Data Control Language to control access to that data
• Understand the KB_SQL implementation relative to the standard language as well as list the differences.

KB_SQL is a registered trademark of KB Systems, Inc.

Note: All computer based training courses are Y2K (Year 2000) compliant.