Whether the reader is just learning SQL or is an experienced user, iSeries and AS/400 SQL at Work shows how to make SQL work in the business environment. Beginners will benefit from the chapters that teach SQL basics by relating them to the concepts they already know. For those more experienced in SQL, this book offers practical, solid information on performance-tuning of SQL statements, the OS/400 query optimizer, advanced SQL capabilities, and special tips and tricks specific to OS/400.In addition to SQL basics, iSeries ...
Read More
Whether the reader is just learning SQL or is an experienced user, iSeries and AS/400 SQL at Work shows how to make SQL work in the business environment. Beginners will benefit from the chapters that teach SQL basics by relating them to the concepts they already know. For those more experienced in SQL, this book offers practical, solid information on performance-tuning of SQL statements, the OS/400 query optimizer, advanced SQL capabilities, and special tips and tricks specific to OS/400.In addition to SQL basics, iSeries and AS/400 SQL at Work provides extensive information on the Stored Procedure Language and clearly explains encoded vector indexes and when to use them. The book also offers practical examples of embedded SQL and even includes several killer queries that will teach the readers advanced SQL concepts they can apply to their daily work for increased productivity.Programmers in today's ever-changing IT world must continue to raise their marketable skill sets and visibility. Learning SQL, the industry-standard data-access and manipulation language, will help them realize their goals.
Read Less
