The ISeries Pocket Query Guide


Book Description

Finally, there is a Pocket Query Guide for training IT and non-IT personnel for Query/400. Yes, it is in big pocket guide form and it is tutorial in nature! You'll be pleased with all the valuable examples, especially result fields, selection and output options. You won't want to put down the first comprehensive guide to Query/400 now that you have your hands on it. This book was overdue 20 years ago, when Query/36 was the offering of the day. As strange as it may seem, there has never been a Query book such as this...ever. Yet, there are tons of expensive Query classes. It is difficult in most companies to get someone to step up to the plate to learn Query. Moreover, OJT is a tough learning experience and an inexact science at best. How do you know if you're ever right? The biggest cost of Query work may be impossible to quantify. The inaccurate answers that are returned from important queries, done by well intentioned, but inexperienced knowledge workers, can be costly. Making important decisions on erroneous information, however, can be even more costly. Then there is the employee turnover issue. Just when they get good at Query, they're gone. There is always another person or a team of people to train. IT is continually training users on the same Query product. Training by any source is expensive. From IBM classes to expensive self-training systems, there is no cheap alternative. It is always expensive, but it doesn't always work. It's difficult to achieve the objectives. Moreover, history suggests that one thing about Query training is always true. In a year or two, you will be doing it again. Not anymore! There is no magic in the Pocket Guide, but everything you need is in there!In addition, it is easy to read. The objective is for the users to train themselves. The iSeries Pocket Query Guide, a little help from co-workers along the way, and a careful evaluation by IT is all you need. The Guide has an example for just about every type of Query you can imagine -- from major result fields to File Joins. You'll see how to do it with examples that you'll use repeatedly. Additionally, for each example, there is a detailed explanation as well as the theory you need to get a head start on becoming a Query/400 guru.




The AS/400 & IBM I Pocket Query Guide


Book Description

Finally, there is a Pocket Query Guide for training IT and non-IT personnel for Query/400. Yes, it is in big pocket guide form and it is tutorial in nature! You'll be pleased with all the valuable examples, especially result fields, selection and output options. You won't want to put down the first comprehensive guide to Query/400 now that you have your hands on it. This book was overdue 20 years ago, when Query/36 was the offering of the day. As strange as it may seem, there has never been a Query book such as this...ever. Yet, there are tons of expensive Query classes. It is difficult in most companies to get someone to step up to the plate to learn Query. Moreover, OJT is a tough learning experience and an inexact science at best. How do you know if you're ever right? The biggest cost of Query work may be impossible to quantify. The inaccurate answers that are returned from important queries, done by well intentioned, but inexperienced knowledge workers, can be costly. Making important decisions on erroneous information, however, can be even more costly. Then there is the employee turnover issue. Just when they get good at Query, they're gone. There is always another person or a team of people to train. IT is continually training users on the same Query product. Training by any source is expensive. From IBM classes to expensive self-training systems, there is no cheap alternative. It is always expensive, but it doesn't always work. It's difficult to achieve the objectives. Moreover, history suggests that one thing about Query training is always true. In a year or two, you will be doing it again. Not anymore! There is no magic in this Query Developers Guide, but everything you need is in there! In addition, it is easy to read. The objective is for the users to train themselves. The AS/400 & IBM I Pocket sized Query Guide, and a little help from co-workers along the way, and a careful evaluation by IT is all you need. The Guide has an example for just about every type of Query you can imagine - from major result fields to File Joins. You'll see how to do it with examples that you'll use repeatedly. Additionally, for each example, there is a detailed explanation as well as the theory you need to get a head start on becoming a Query/400 guru.




The Courage to Lead


Book Description




SQL Pocket Guide


Book Description

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including: Oracle Database 10g, Release 2 (includingthe free Oracle Database 10g Express Edition (XE)) Microsoft SQL Server 2005 MySQL 5 IBM DB2 8.2 PostreSQL 8.1 database




The AS/400 & IBM I Pocket SQL Guide


Book Description

A Learn By Example Guide for IBM i-based Application Development Finally, there is a Pocket Developer's Guide for IBM i SQL data- base development. Yes, it is in big pocket guide form and it is tutorial in nature. You'll be pleased with all the valuable explanations and examples. You won't want to put down this comprehensive guide to learning IBM i SQL now that you've got your hands on it. This book is over 20 years overdue. In today's IT landscape, most shops support heterogeneous systems with numerous client and server PCs, and even Unix boxes. Ironically, all of these non-IBM i platforms, from the smallest to the largest have one thing in com- mon in the relational database area. They all use SQL as their data language. That's a big change in the database landscape. SQL is now the industry data / query language standard. IBM backs SQL 100%. A quick look at the SQL function list for the latest release gives a good indication that SQL will have an even more important role in the IBM i future. So, today, it makes little sense for an AS/400 and IBM i professional to not be on board by warming up to SQL - at least for functions that return sets of data. This Guide has an example for just about every type of common SQL function you can imag- ine - from creating tables & views to performing simple and complex selections, column and scalar functions, sub-queries, all the way to unions and joins. Author Brian Kelly designed this book to show you how to use SQL by working with rich examples that you'll use over and over again. Additionally, for each example, there is the explanation you need to get a head start on being an SQL guru. This is the first book to hand to your new developers and veterans alike. More importantly, rather than Oracle being the only database taught at your local Community Colleges and Universities, this new up-to-date IBM i SQL Guide is the right size text for a modern database course. Contains end of chapter extras for teaching / learning.




SQL Pocket Guide


Book Description

If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite. In this updated edition, author Alice Zhao describes how these database management systems implement SQL syntax for both querying and making changes to a database. You'll find details on data types and conversions, regular expression syntax, window functions, pivoting and unpivoting, and more. Quickly look up how to perform specific tasks using SQL Apply the book's syntax examples to your own queries Update SQL queries to work in five different database management systems NEW: Connect Python and R to a relational database NEW: Look up frequently asked SQL questions in the "How Do I?" chapter




SQL Pocket Guide


Book Description

This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants--Oracle, IBM DB2, Microsoft SQL Server, and MySQL. Topics include: Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK). Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate) Such topics as literals, NULLs, CASE expressions, datatype conversion, regular expressions, grouping and summarizing data, joining tables, and writing queries (hierarchical, recursive, union, flashback) and subqueries. Instead of presenting complex and confusing syntax diagrams, the book teaches by example, showing the SQL statements and options that readers are most like to use. All example data is available on the O'Reilly web site. "If you need fast, accurate SQL information, with examples for multiple database engines, be sure to check out this book."--Chris Kempster, Senior DBA and author of SQL Server 2000 for the Oracle DBA, www.chriskempster.com




IBM Maximo Asset Management. The Consultant's Guide: Second Edition


Book Description

This book was written by a Maximo consultant for Maximo functional consultants to help them lead implementation projects better and faster. This is already the second edition of this book, revised and extended. The book covers the topic of how to implement IBM Maximo Asset Management efficiently and bring value to customers. The book begins by describing how to prepare the project and run the workshops. There is an explanation of how to design the system and what deliverables will be. The following chapters focus on the project organization to make it productive. This part of the book can be helpful also for managers of Maximo implementation teams. The second part of the book describes Maximo applications, their interactions, and processes. You will also find here a lot of configuration examples and sample content of the project deliverables. See what my readers have to say… “…I must thank you for your contribution towards the industry and how much it can help young and upcoming business consultants like me in getting things right. Knowledge is invaluable. Thanks for your time in creating a medium to share it globally…” —Hashmeet “…The book has immensely helped me in planning the activities and deploying the project….” —Kushal “…Very well written for a consultant to understand how to approach projects. Utilize many of your talking points with my clients. Great work!...” —John




Elasticsearch: The Definitive Guide


Book Description

Whether you need full-text search or real-time analytics of structured data—or both—the Elasticsearch distributed search engine is an ideal way to put your data to work. This practical guide not only shows you how to search, analyze, and explore data with Elasticsearch, but also helps you deal with the complexities of human language, geolocation, and relationships. If you’re a newcomer to both search and distributed systems, you’ll quickly learn how to integrate Elasticsearch into your application. More experienced users will pick up lots of advanced techniques. Throughout the book, you’ll follow a problem-based approach to learn why, when, and how to use Elasticsearch features. Understand how Elasticsearch interprets data in your documents Index and query your data to take advantage of search concepts such as relevance and word proximity Handle human language through the effective use of analyzers and queries Summarize and group data to show overall trends, with aggregations and analytics Use geo-points and geo-shapes—Elasticsearch’s approaches to geolocation Model your data to take advantage of Elasticsearch’s horizontal scalability Learn how to configure and monitor your cluster in production




Implementing Practical DB2 Applications


Book Description

Implementing Practical DB2 Applications provides a concise source of information for the development and implication of applications using IBM's DB2 relational database package in the MVS environment. The book describes the flagship DB2 version, namely that implemented for the MVS operating system environment where DB2 operates with the MVS transaction processing subsystems: CICS, IMS and TSO. The book is intended for both beginners and experts. It describes how the various components of SQL are used to provide practical applications. Containing tips and notes that were discovered the hard way - through hands on experience - this book will be welcomed by all those looking to implement applications in DB2.