Introduction to SQL for System i Developers
This course covers the essential components of SQL syntax, as well as iSeries/System i support for SQL. SQL skills are critical as new database support is no longer being added to DDS. In addition, SQL is an important tool for integrating iSeries/System i data with newer applications written using languages such as Java.
Schedule:
Section 1418
| Weeks: | 5 |
| Sessions: | 5 |
| Start Date: | March 16, 2010 |
| End Date: | April 13, 2010 |
| Other Important Dates: | Starts Tuesday, March 16 |
| Meets: | This class will be held on Tuesdays at 9:30 am Eastern time for five weeks, on March 16, 23, 30, May 6, and 13. Each class session is about one hour.
|
Pricing:
$315 for System iNetwork Pro VIP Members. All pricing is based on the cost for System iNetwork Pro VIP Members. If you're not a Pro VIP-level member, you may need to renew or upgrade your subscription status to take any e-class at VIP-level rates. Rates for non-VIP members are $399, which includes a FREE automatic upgrade to Pro VIP status for 12 months (which also means that you'll enjoy VIP-level pricing for the next 12 months!). The rate for international registrations is $499.
To Register:
Instructor:
Sharon Hoffman
shoffman@techreflections.com
Sharon Hoffman is a senior technical editor for System iNEWS magazine and has worked with IBM midrange systems since 1981. She focuses on emerging technologies such as Java, XML, and Domino, and she is particularly interested in how these technologies integrate with existing AS/400-iSeries applications. Her background includes extensive application development experience as a programmer, systems analyst, and consultant. She's also been involved with IT education for nearly 20 years as an instructor, writer, and editor. Sharon is a regular speaker at COMMON and other industry events.
Course Agenda:
Overall Course Agenda
- SQL definitions and positioning
- Retrieving and updating data with SQL
- Defining data with SQL
- SQL processing options
- iSeries/System i SQL Tools
- iSeries/System i stored procedures
SQL definitions and positioning
- What is SQL and why is it important for System i?
- SQL Terminology
- SQL statement functions
- SQL structure and syntax
Retrieving and updating data with SQL
- SQL Select statement
- SQL predicates
- Selecting data from multiple tables
- Joins and unions
- SQL Insert, Update, and Delete statements
Defining data with SQL
- SQL table management
- Views and indexes
SQL processing options
- Performance considerations
- Statements versus Prepared Statements
- Interactive SQL versus embedded SQL
- Dynamic SQL versus static SQL
- Processing result sets
- Processing multiple records with a single statement
iSeries/System i SQL Tools
- OS/400 support and licensed program products (LPPs)
- Operations Navigator Tools
- Generate SQL
- Run SQL Scripts
- Visual Explain
iSeries/System i stored procedures
- SQL stored procedure definition
- Requirements for creating stored procedures
- Registering an iSeries/System i program as a stored procedure
- Calling stored procedures using SQL
- Handling program parameters for stored procedures
If you have a specific question regarding course content, contact Sharon Hoffman at shoffman@techreflections.com.
Prerequisites:
Solid programming background, thorough AS/400 knowledge, and basic Windows navigation skills. Students registering for this course should be well-versed in database design and DDS, and have an understanding of RPG or COBOL programming techniques for working with data.
Minimum Technical Requirements:
- Minimum 56KB Internet access (faster access highly recommended)*
- PC hardware: 300 MHz, 128MB memory, 500 MB available disk space
- PC software: Windows 2000 or higher
If you have a specific question regarding course content, contact Sharon Hoffman at shoffman@techreflections.com.
FAQs specific to this course:
No FAQs for this course.
What about the e-learning experience?
Here's a list of frequently asked questions about System iNetwork e-learning classes.
|
|