|
|
| You now have a grasp of SQL basics and are comfortable doing simple things with SELECT, UPDATE, INSERT, and DELETE. But you still find it a challenge when trying to go beyond the basics and attempt more complex SQL statements. If this is your experience, this four-hour seminar is for you.
After a quick review of some SQL basics, you will learn how to use SQL built-in functions for data manipulation and analysis, to derive and name new columns, reformat data, change data types, summarize data, and more. You will also explore basic subselect, and the more advanced forms of subselect; and see how a single SQL statement with subselect can dramatically simplify the logic in an RPG program, including the reference of two or more tables without doing a Join. You will see how to use SQL to work with edit characters in a text string or a number, identify potential duplicate rows in a name and address table, and query a table based on the sound a search string and instead of its spelling.
Skip uses a unique combination of lecture and live demonstrations using ‘Run SQL Scripts (aka the SQL Script Center) to illustrate the SQL concepts and functions covered in this seminar. At the beginning of the seminar he will show you how to use ‘Run SQL Scripts’ to interactively create, test drive, experiment with, and save SQL statements (optionally intermixed with CL) in a PC or System i source file for future reference and use.
After attending this seminar, you will understand how to use:
- SQL built-in functions to do data manipulation and analysis
- Subselect and scalar subselect to write complex SQL statements that reference multiple tables without requiring a table join
- SQL to work with edit characters
- SQL to identify duplicate rows in a table
- SQL to search based on sound and instead of spelling
- ‘Run SQL Scripts’ to create, test, experiment with, and save SQL statements
|
