SQL for IBM i: A Database Modernization Guide Front Cover

SQL for IBM i: A Database Modernization Guide

  • Length: 376 pages
  • Edition: None
  • Publisher:
  • Publication Date: 2018-01-23
  • ISBN-10: 1583474498
  • ISBN-13: 9781583474495
  • Sales Rank: #148241 (See Top 100 Books)
Description
This book aims to give IBM i technical users basic to intermediate SQL knowledge and tools they can use to get more out of the IBM i database. The book can be useful to veteran IBM i programmers, who have RPG and COBOL roots, system administrators looking to get more information out of their IBM i system, or even Java and .NET developers who need to “talk” to IBM i database. The author provides comprehensive examples and exercises to help readers understand and practice what they have learned.

Table of Contents

Chapter 1: Meet The Umadb: Our Example Database
Chapter 2: A Data Manipulation Language Basics Recap
Chapter 3: A Data Definition Language Basics Recap
Chapter 4: Making The Database User-Friendly
Chapter 5: Tidying Up The Database
Chapter 6: Introducing Data-Centric Programming And Sql/Psm
Chapter 7: Creating And Using Stored Procedures
Chapter 8: Exploring User-Defined Functions
Chapter 9: Making A Trigger-Happy Database
Chapter 10: Moving Business Validations To The Database
Chapter 11: Exploring The Database Catalog Information
Chapter 12: Parting Gifts

To access the link, solve the captcha.