Author : Paul Conte
Publisher : System iNetwork
Page : 548 pages
File Size : 31,65 MB
Release : 2000
Category : Computers
ISBN : 9781882419708
IBM and the rest of the computer industry are putting most of their DBMS development efforts into SQL. This reference provides the SQL/400 skills that a successful applications developer needs and shows how to create comprehensive, complex, and professional SQL/400 databases.
Author : Mike Cravitz
Publisher :
Page : 400 pages
File Size : 43,39 MB
Release : 2009-01-16
Category : Computers
ISBN : 9781583041239
SQL for DB2 ISBN: 978-1-58304-123-9 This focused, comprehensive textbook provides start-to-finish coverage of SQL for DB2. Whether youre a college student studying SQL for DB2 for the first time or a professional developer who needs to learn SQL for DB2, this book covers all the basics necessary for success. The purpose of any database book is to learn how to develop databases effectively and precisely without the need for a lot of complicated jargon. This book delivers on that promise by focusing on the skill set necessary to develop well-designed DB2 databases. SQL for DB2 covers the core requirements of a traditional database course. Topics are presented in an accessible, easy-to-learn manner with numerous examples and tips. End-of-chapter materials include a chapter summary, list of key terms, and hands-on exercises that put the concepts to work. SQL for DB2 builds on the foundation of its widely acclaimed predecessor, SQL/400 Developers Guide, to provide an up-to-date introduction to SQL for DB2 for todays students and professionals. All chapters have been refreshed, with improved organization throughout. Examples have been updated, and new material has been added. This new edition includes: New chapters introducing DB2 and System i Navigator Expanded coverage of single- and multiple-table queries Expanded coverage of updating databases with SQL An expanded discussion of normalization Table of Contents Chapter 1 Introduction to DB2 Chapter 2 Introduction to SQL Chapter 3 Single-Table Queries Chapter 4 Introduction to Data Modeling and Database Design Chapter 5 Logical Data Modeling Chapter 6 Entity Relationship Diagram Chapter 7 Normalization Chapter 8 Physical Database Design Chapter 9 Database Constraints Chapter 10 Multiple Table Queries Chapter 11 Views and Indexes Chapter 12 Updating Tables Chapter 13 Static and Dynamic Embedded Statements Chapter 14 SQL Cursors and Result Sets Chapter 15 The Create SQL Program Command Chapter 16 Using SQL in RPG Programs Chapter 17 Triggers Chapter 18 Additional SQL Topics Chapter 19 Database Security and Grant and Revoke Statements
Author : Jerry Fottral
Publisher : System iNetwork
Page : 580 pages
File Size : 41,1 MB
Release : 2000
Category : Computers
ISBN : 9781583040706
Annotation A hands-on approach to learning library-object structure, utilities and database management capabilities, application development tools, and OS/400 Control Language (CL), for the AS/400 computer. Twelve lessons, based largely on lab exercises, teach students how to communicate with the system, and use its many features, including CL, Query/400, logical files, DFU, SQL, and SDA. Annotation copyrighted by Book News, Inc., Portland, OR.
Author : Ken Henderson
Publisher : Addison-Wesley Professional
Page : 1076 pages
File Size : 35,93 MB
Release : 2004
Category : Computers
ISBN : 9780201700473
bull; Contains the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning bull; Will be a key reference for anyone working with SQL Server, no matter what their skill level bull; The latest book in the bestselling series of Guru's Guides from Ken Henderson
Author : Paul Conte
Publisher : 29th Street Press
Page : 0 pages
File Size : 10,30 MB
Release : 1997
Category : Database design
ISBN : 9781882419067
Database Design and Programming for DB2/400 is a comprehensive introduction to the design and implementation of application databases on IBM's AS/400. This clear and authoritative text teaches you the following essential skills: Coding Data Description Specifications (DDS) for physical and logical files, entering CL commands to create DB2/400 files from DDS, using field reference files, accessing database files from RPG IV, RPG/400, COBOL/400, and other AS/400 high-level languages, the Relational Database Model as a foundation for DB2/400 and database design, practical database design and data modeling, using SQL/400 to define and access database files, advanced DB2/400 features (including commitment control, the Open Query File command, database constraints, triggers, distributed database access, and others), database security, and data backup and recovery. Paul Conte, a leading DB2/400 authority with extensive application development experience, provides easy-to-follow instruction in the proper way to create efficient, flexible databases on the AS/400. His explanations and advice assure that you'll handle your design and coding challenges with confidence and professional-level techniques. This book provides complete coverage of both DDS, the traditional approach to defining DB2/400 files, and of SQL/400, the industry-standard database language that is IBM's strategic language for the future of DB2/400. With this text, you can be sure of handling not only existing application databases, but also developing new SQL/400 databases. These skills will put you in the forefront of AS/400 application developers. Database Design and Programming for DB2/400 also provides an excellentintroduction to practical database design techniques. You get a solid introduction to the relational database model, which underlies the whole DB2/400 architecture and the SQL language. On that foundation, the book explains a step-by-step method of modeling an organization's database requirements and developing a design for the necessary database files. The text is designed for college-level courses and for independent study. Each chapter has numerous examples and exercises. The material is organized into four parts - DDS, database design, SQL, and advanced DB2/400 features - so you can focus on particular topics as needed. Appendices provide extensive reference material. You can use the book as your single DB2/400 resource, eliminating the need for many IBM manuals. You will find Database Design and Programming for DB2/400 immediately useful, whether you're just beginning to learn DB2/400 or you are an experienced developer. You will turn to this book time and time again for advice on the best way to design and program DB2/400 databases.
Author : Hernando Bedoya
Publisher : IBM Redbooks
Page : 338 pages
File Size : 31,96 MB
Release : 2016-04-25
Category : Computers
ISBN : 0738441643
Structured Query Language (SQL) procedures, triggers, and functions, which are also known as user-defined functions (UDFs), are the key database features for developing robust and distributed applications. IBM® DB2® for i supported these features for many years, and they are enhanced in IBM i versions 6.1, 7.1, and 7.2. DB2 for i refers to the IBM DB2 family member and relational database management system that is integrated within the IBM Power operating system that is known as IBM i. This IBM Redbooks® publication includes several of the announced features for SQL procedures, triggers, and functions in IBM i versions 6.1, 7.1, and 7.2. This book includes suggestions, guidelines, and practical examples to develop DB2 for i SQL procedures, triggers, and functions effectively. This book covers the following topics: Introduction to the SQL/Persistent Stored Modules (PSM) language, which is used in SQL procedures, triggers, and functions SQL procedures SQL triggers SQL functions This book is for IBM i database engineers and data-centric developers who strive to provide flexible, extensible, agile, and scalable database solutions that meet business requirements in a timely manner. Before you read this book, you need to know about relational database technology and the application development environment on the IBM Power SystemsTM with the IBM i operating system.
Author :
Publisher :
Page : 64 pages
File Size : 19,71 MB
Release : 2003-11-24
Category :
ISBN :
InfoWorld is targeted to Senior IT professionals. Content is segmented into Channels and Topic Centers. InfoWorld also celebrates people, companies, and projects.
Author :
Publisher :
Page : 84 pages
File Size : 12,83 MB
Release : 1998-07-06
Category :
ISBN :
For more than 40 years, Computerworld has been the leading source of technology news and information for IT influencers worldwide. Computerworld's award-winning Web site (Computerworld.com), twice-monthly publication, focused conference series and custom research form the hub of the world's largest global IT media network.
Author :
Publisher :
Page : 118 pages
File Size : 29,91 MB
Release : 1999-09-13
Category :
ISBN :
For more than 40 years, Computerworld has been the leading source of technology news and information for IT influencers worldwide. Computerworld's award-winning Web site (Computerworld.com), twice-monthly publication, focused conference series and custom research form the hub of the world's largest global IT media network.
Author : Sherif Talaat
Publisher : Apress
Page : 215 pages
File Size : 46,3 MB
Release : 2015-11-24
Category : Computers
ISBN : 1484206657
This book is written for Windows professionals who are familiar with PowerShell and want to learn to build, operate, and administer their Windows workloads in the Microsoft cloud. Pro PowerShell for Microsoft Azure is packed with practical examples and scripts, with easy-to-follow explanations for a wide range of day-to-day needs and essential administration tasks. Author Sherif Talaat begins by explaining the fundamental concepts behind the Microsoft Azure platform and how to get started configuring it through PowerShell. Readers will find out how to deploy, configure and manage the various components of the Azure platform, from storage and virtual networks to Azure Web Sites, HDInsight clusters and the Azure SQL Database. Workload automation, scheduling and resource management are covered in depth to help build efficiency in everyday tasks, and administrators will gain full control over Azure identity and access rights using Azure Active Directory and Rights Management Services. Put your PowerShell skills to good use and ensure that your applications and data are available anywhere at any time, with Pro PowerShell for Microsoft Azure. What You'll Learn Create and manage virtual networks and VPNs using PowerShell. Configure and maintain Azure Storage accounts, blobs, and containers. Provision and manage a redundant Windows or Linux server. Deploy and configure your sites in the cloud using Microsoft Azure Web Sites. Provision Apache Hadoop clusters in the cloud using Azure HDInsight. Deploy, configure and manage a Microsoft Azure SQL Database. Protect and secure identities and resources with Azure Active Directory and Azure Rights Management Services. Who This Book Is For This is book is for the intermediate to advanced Windows professional who is ready to make the leap to the cloud.
