This practical guide to SQL focuses on data retrieval and manipulation using the powerful AS/400 dialect. In a tutorial format, the authors cover a wide range of SQL material, including selecting data from a single table, using built-in functions, defining and manipulating data and accessing multiple tables. The book is full of information on SQL/400, including database security and transaction processing, and it explores AS/400 catalogue.
Reihe
Sprache
Verlagsort
Verlagsgruppe
McGraw-Hill Education - Europe
Zielgruppe
Illustrationen
Maße
Höhe: 235 mm
Breite: 188 mm
ISBN-13
978-0-07-040799-2 (9780070407992)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Part 1 Selecting data from a single table: the select statement; sorting the "result" table; Boolean connectors - and-or-not; pattern matching; arithmetic expressions. Part 2 Built-in functions: column functions; scalar functions. Part 3 Data definition and manipulation: data definition; data manipulation; processing null values. Part 4 Accessing multiple tables: the join operation; UNION; subqueries; correlated subqueries. Part 5 More about SQL/400: the view concept; database security; transaction processing; exploring the AS/400 catalogue; appendices.
