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 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.




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




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.




Business Process Management Design Guide: Using IBM Business Process Manager


Book Description

IBM® Business Process Manager (IBM BPM) is a comprehensive business process management (BPM) suite that provides visibility and management of your business processes. IBM BPM supports the whole BPM lifecycle approach: Discover and document Plan Implement Deploy Manage Optimize Process owners and business owners can use this solution to engage directly in the improvement of their business processes. IBM BPM excels in integrating role-based process design, and provides a social BPM experience. It enables asset sharing and creating versions through its Process Center. The Process Center acts as a unified repository, making it possible to manage changes to the business processes with confidence. IBM BPM supports a wide range of standards for process modeling and exchange. Built-in analytics and search capabilities help to further improve and optimize the business processes. This IBM Redbooks® publication provides valuable information for project teams and business people that are involved in projects using IBM BPM. It describes the important design decisions that you face as a team. These decisions invariably have an effect on the success of your project. These decisions range from the more business-centric decisions, such as which should be your first process, to the more technical decisions, such as solution analysis and architectural considerations.




MySQL to DB2 Conversion Guide


Book Description

Switching database vendors is often considered an exhausting challenge for database administrators and developers. Complexity, total cost, and the risk of downtime are often the reasons that restrain IT decision makers from starting the migration project. The primary goal of this book is to show that, with the proper planning and guidance, converting from MySQL to IBM® DB2® is not only feasible but straightforward. If you picked up this book, you are most likely considering converting to DB2 and are probably aware of several of the advantages of to converting to DB2 data server. In this IBM Redbooks® publication, we discuss in detail how you can take advantage of this industry leading database server. This book is an informative guide that describes how to convert the database system from MySQLTM 5.1 to DB2® V9.7 on Linux® and the steps that are involved in enabling the applications to use DB2 instead of MySQL. This guide also presents the best practices in conversion strategy and planning, conversion tools, porting steps, and practical conversion examples. It is intended for technical staff that is involved in a MySQL to DB2 conversion project.




Re-Engineering RPG Legacy Applications


Book Description

Re-engineering AS/400 Legacy Applications and companion CD ROM provide a tutorial aimed at showing you how to modernize your applications by taking you step by step through the re-engineering of a sample application. Author Paul Tuohy covers conversion of RPG IV programs, as well as re-engineering them to take full advantage of RPG IV and ILE. He also covers triggers, referential integrity, and APIs so that your applications can take advantage of all the new technology that is available today. This book will be a valuable aid as you evaluate your legacy applications and then move into re- engineering.




General Information Manual


Book Description