![](/accounts/common/images/logo.png)
The Power of SQL on IBM i — Scott Forstie
-
Register
- Member - Free!
Already registered?
Log in now.
- What is SQL
- Why SQL is important
- Integrated in o/s
- SQL services
- What are the parts?
- DDL
- DML
- Programming language
- What you can access with SQL (High level overview)
- JSON/XML
- IFS access
- Accessing web services
- Terminology differences
- File
- Table
- Database objects
- Schema
- Table
- View
- Indexes
- Why they are necessary
- SQL routines
- Schema
- Insert from examples
- Where to go for all documentation (IBM sources and COMMON LMS sources), word of warning of Google searches
![Speaker image](https://70ecbb36cf5afa131dcc-6f15f2badde623b67dc4ad2e21c9f77b.ssl.cf2.rackcdn.com/common_e041c2202a74040971143aee35a0ec9c.jpg)
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
Key:
![](/images/product-status-icons/complete-small.png)
![](/images/product-status-icons/next-small.png)
![](/images/product-status-icons/disabled-small.png)
![](/images/product-status-icons/optional-small.png)
![](/images/product-status-icons/locked-small.png)