- Categories
- Acceptance Testing
- Agile Business Analysis
- Best Practices
- Business Analysis and Systems Analysis
- Business Analysis Planning and Monitoring
- Business Process Modeling (BPM)
- Business Rules
- Conducting Meetings
- Data Modeling, Data Analysis, Data Mining
- Enterprise Analysis
- Facilitation
- IIBA, BABOK, and CBAP certification
- JAD
- Making Teams and Virtual Teams Work
- Problem Analysis, Problem Solving
- Process Analysis
- Prototyping
- Request for Proposal (RFP)
- Requirements Analysis
- Requirements Documentation
- Requirements Elicitation
- Requirements Engineering
- Requirements Management
- Requirements Specifications
- Requirements Traceability
- Requirements Validation
- Software Testing and Test Cases
- System Development Life Cycles
- Test Data Engineering
- Test Planning
- Testing Tools
- Testing Web Applications and Web Services
- Unified Modeling Language (UML)
- Usability
- Use Cases and User Stories
- User Interfaces
- Workflow Analysis
Business Analysis for Information Technology
Books and Selected Products
Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts
Addison–Wesley Professional
August 2002
Paperback, 528 pages
ISBN: 0201752948
On-Site and On-Line Training Courses for Business Analysts All About Use Cases
How to Analyze and Improve Business Processes
How to Build Business Process Models
How to Elicit (Gather), Write, and Analyze Business Requirements
How to Model, Analyze, and Improve Business Data
How to Model, Analyze, and Improve Business Processes
Writing Effective Business Requirement Statements
Description
Oracle SQL and PL/SQL Handbook is designed as both a basic reference as
well as a how–to guide. It offers thorough coverage of Oracle‘s SQL query
language and PL/SQL programming language. It focuses on the practical
aspects of using SQL and PL/SQL to most effectively extract usable
information from Oracle systems. Thus it is of use not only to database
administrators, but also to business managers, developers, and power users.The
book‘s initial chapters offer a complete introduction to the relational database
environment, including a discussion of how to use the logical data model to
understand the databse. From there, Oracle database objects are covered, along
with uses of the Data Definition Language (DDL), the Data Control Language
(DCL), and the Data Manipulation Language (DML). Subsequent chapters
offer complete coverage of the Select command used to retrieve information
from the database. Throughout the book frequently used commands and
content are stressed, and numerous examples of SQL techniques are provided.
In addition, most of the book‘s chapters provide practice questions designed to
reinforce concepts covered.
Features
Features
The most comprehensive sourcebook of solutions and techniques for improving your use of Oracle SQL and PL/SQL!
° Authoritative and practical coverage of Oracle, its query language SQL, and its programming language SQL
° Covers SQL performance tuning and troubleshooting, using Java with PL/SQL, and using Oracle‘s new analytic functions to create special business information
° The practice questions at the end of each chapter provide an excellent review for the Oracle Certification exams
From the back cover:
Backcover Copy
Concise and practical, this indispensable volume brings the world‘s most popular Relational Database Management System (RDBMS), its query language SQL, and its programming language PL/SQL into clear focus for today‘s busy database professional or business analyst. Covering the most commonly used Oracle features, Oracle SQL and PL/SQL Handbook is ideal for the developer or business user challenged with implementing, maintaining, and retrieving mission–critical data within the Oracle database environment.
Broadly designed as both a basic reference and how–to, this book offers extensive coverage of Oracle‘s SQL language and database concepts, providing an excellent review for the Oracle certification exams. The initial chapters offer a complete introduction to the relational database environment, including a discussion of how to use the logical data model to understand the database. Oracle database objects are explored, along with uses of the Data Definition Language (DDL), the Data Control Language (DCL), and the Data Manipulation Language (DML). Later chapters offer complete coverage of the Select command used to retrieve information from the database. Also included are coverage of Oracle‘s new analytic functions, a chapter on performance–tuning techniqes needed for complex SQL, and a detailed overview of Oracle‘s PL/SQL language. In addition, many chapters provide practice questions designed to reinforce newly introduced concepts, as well as numerous examples of SQL techniques.
The broad–based and comprehensive coverage also includes:
Authoritative and practical, Oracle SQL and PL/SQL Handbook provides today‘s administrator and business analyst alike with the most comprehensive sourcebook of solutions and techniques for improving their use of Oracle.
0201752948B07152002
About the Author:
Author Bios
John Adolph Palinski is a Supervisor of Computer Applications for the Omaha Public Power District where he has developed and implemented numerous Oracle systems. He is also an instructor at the University of Nebraska at Omaha. A Certified Oracle Professional Developer, he has taught SQL, PL/SQL, and Developer 2000 courses and is the author of Oracle Database Construction Kit (Que, 1997). He is a frequent contributor to Oracle periodicals such as Oracle Internals and Oracle Professional. He also provides on–site training through his consulting company, Realistic Software Training.
0201752948AB07152002
Business Analysis for Information Technology deals
