Click Here for the Outline in PDF Version Course Outline: SQL Programming (2 Days) with Hands-On Labs Learning Objectives Learn to utilize SQL language and syntax effectively Learn to Code efficient SQL statements by applying numerous performance considerations Understand how to effectively write SQL statements that comply with recognized coding standards This course description should be used to determine whether the course is appropriate for you based on your current skill and technical training needs. Technical information is provided on the intended audience, course prerequisites, and covered topics. Course content, prices, and availability are subject to change without notice. Course Audience This course is designed for people who will be coding and/or maintaining application programs using SQL, primarily application developers. Course Description This course provides participants with the knowledge and skills needed to code SQL statements. The SQL information can be applied to any relational environment, including DB2, Oracle, SQL/Server, Informix, ect. Workshops are executed using an appropriate interactive tool such as SPUFI. Course Objectives At course completion the student will be able to perform the following tasks: Describe how SQL implements the relational model Explain the subdivisions of SQL Use proper syntax and coding standards when coding SQL statements Code SQL statements to retrieve relational database data Use SQL parameters to qualify data retrieval, such as WHERE, DISTINCT, IN, LIKE, BETWEEN, ORDER BY, UNION, built-in functions, GROUP BY, and HAVING Use SQL parameters to join tables and retrieve data Code SQL statements to change data, including the UPDATE, INSERT and DELETE instructions Code efficient SQL statements by applying numerous performance considerations Prerequisites Knowledge of Information Systems concepts and a general working knowledge of Oracle, SQL, SQL*Plus, and PL/SQL, Access, or SQL Server is highly recommended. TOPICS COVERED IN LECTURE & LAB Introduction The Language The Relational Implementation The Subdivisions of SQL SQL Syntax Coding Standards Retrieving Information The SELECT Statement The WHERE Clause Conditional Operators Compound Conditions Creating New Values Built-In Functions Machine Workshop Ordering Information Orders and Groups ORDERS BY GROUP BY HAVING Creating VIEWS Machine Workshop Advanced Retrievals Joining Tables Field Names Alias Names Joining a Table to itself The Outer Join Subqueries Single-valued subqueries Multi-valued subqueries ALL and ANY parameters Correlated subqueries EXISTS parameter Unions UNION operator UNION ALL Changing Data UPDATE INSERT DELETE COMMITS and ROLLBACKS Machine Workshop SQL Performance Index Structure and Influence Components that affect SQL Performance Indexable vs. Non-Indexable Predicates Stage 1 vs. Stage 2 Predicates 20 Essential Performance Guidelines

Policy