Author: Susan Lawson
Publisher: MC Press
Release Date: 2016-07-15
Written primarily for database administrators who work on z/OS and who are taking the IBM DB2 11 for z/OS Database Administration certification exam (Exam 312), this resource also appeals to those who simply want to master the skills needed to be an effective database administrator of z/OS mainframes. This study guide is designed to provide those seeking certification with an intense overview of DB2 11 for z/OS and all topics covered on the exam. Sample questions are provided at the end of each chapter, along with answers and explanations.
Author: Susan Lawson
Publisher: Mc PressLlc
Release Date: 2011-11-01
The key to mastering IBM's DB2 for z/OS Written primarily for database administrators who work on z/OS and who are taking the IBM DB2 10 for z/OS Database Administration certification exam (Exam 612), this resource also appeals to those who simply want to master the skills needed to be an effective database administrator of z/OS mainframes. The guide covers all the topics on the exam, including database design and implementation, operation and recovering, security and auditing, performance, and installation and migration. Complete with sample questions and detailed answers as well as a full-length practice exam this study guide serves as an essential tool. Programmers will learn how to create, maintain, and administer DB2 10 databases on the z/OS platform and how to implement XML with a DB2 10 database, making them successful database administrators after they pass certification.
This book provides an in-depth review of the skills required to pass IBM’s DB2 11 for z/OS System Administration exam 317 certification exam. This book addresses the changes in this new release of the DB2 11 for z/OS System Administration certification test, specifically for the latest version of DB2 for z/OS, version 11. Each section of the exam addresses a detailed set of skills that a DB2 system administrator on DB2 11 for z/OS should have. This book takes those sections, chapter by chapter, and provides the information a DB2 for z/OS system administrator will need to know to pass the certification exam. Practice questions and answers follow each chapter. A new practice final exam has been added to the book. The reader will come away being fully prepared to pass exam 317 and acquire certification, an important milestone showing significant academic and/or professional achievement.
Author: Robert Wingate
Release Date: 2016-11-02
This book will help you pass IBM Exam C2090-320 and become an IBM Certified Database Associate - DB2 11 Fundamentals for z/OS. The 189 questions and answers in the book (three full practice exams) offer you a significant advantage by helping you to gauge your readiness for the exam, to better understand the objectives being tested, and to get a broad exposure to the DB2 11 knowledge you'll be tested on.
Author: Sanders E Roger
Publisher: Mc PressLlc
Release Date: 2014-08-15
Beginning with an explanation of the certification process and working through fundamental exam objectives, this guide gives test-takers all they need to know to pass IBM's DB2 10.1 Fundamentals certification exam (Exam 610). All the subjects covered on the exam are included: planning, security, data concurrency, working with databases and database objects, working with data using SQL and XQuery, working with DB2 tables, views, and indexes—and more. The book concludes with an extensive set of 150 practice questions that mirror the questions found on the exam and detailed answers that explain why the chosen answer is correct and why the others are wrong. Written by a DB2 authority who has helped IBM develop 21 DB2 certification exams, this is the ultimate resource for those who plan to earn their IBM Certified Database Associate certification.
Author: Robert Wingate
Release Date: 2017-08-25
This book will help you pass IBM Exam C2090-313 and become an IBM Certified Application Developer - DB2 11 for z/OS. The instruction, examples and questions/answers in the book offer you a significant advantage by helping you to gauge your readiness for the exam, to better understand the objectives being tested, and to get a broad exposure to the DB2 11 knowledge you'll be tested on.
This book will help you pass IBM Exam C2090-616 and become an IBM Certified Database Associate (DB2 11.1 for Linux, Unix and Windows). The questions and answers in the book offer you a significant advantage by helping you to gauge your readiness for the exam, to better understand the objectives being tested, and to get a broad exposure to the knowledge you'll be tested on.
Author: Tony Andrews
Publisher: IBM Press
Release Date: 2012-10-15
The Definitive Solutions-Oriented Guide to IBM® DB2® for z/OS®: Now Fully Updated for Both v9 and v10! The largest database tuning performance gains can often be obtained from tuning application code, and applications that use SQL to retrieve data are the best candidates for tuning. This well-organized, easy-to-understand reference brings together more than 100 SQL-related skills and techniques that any developer can use to build and optimize DB2 applications for consistently superior performance. DB2 tuning expert Tony Andrews (“Tony the Tuner”) draws on more than 20 years of DB2-related experience, empowering you to take performance into your own hands, whether you’re writing new software or tuning existing systems. Tony shows you exactly how to clear bottlenecks, resolve problems, and improve both speed and reliability. This book fully reflects the latest SQL programming best practices for DB2 V9 and DB2 V10 on z/OS: techniques that are taught in no other book and are rarely covered in general DB2 SQL courses. Drawing on his extensive consulting experience and highly praised training with Themis Inc., Tony also presents practical checklists and an invaluable 15-step methodology for optimizing virtually any DB2 application. Coverage includes Empowering developers on knowing what to do and where to look in resolving performance problems in queries or programs Providing many programming and SQL coding examples Establishing standards and guidelines that lead to high-performance SQL Implementing time-efficient code walkthroughs to ensure that your standards are followed Focusing on the small number of SQL statements that consume the most resources Identifying simple solutions that deliver the most sizable benefits Optimizing performance by rewriting query predicates more efficiently Providing a better understanding of SQL optimization and Runstat statistics Recognizing opportunities to tweak your code more effectively than the Optimizer Optimizing SQL code with COBOL applications Efficiently checking for the existence of data, rows, or tables Using Runstats’ newest capabilities to consistently optimize paths to data
Written primarily for readers who work with the DB2 system, this book covers everything they need to know in order to pass the exam to become IBM-certified database administrators for DB2 10.1 or DB2 10.5 for Linux, UNIX, and Windows. This comprehensive study guide goes step by step through all of the topics on the test. Each chapter contains an extensive set of practice questions along with carefully explained answers, and a complete practice test that closely models the actual exam is included with an answer key. The book discusses server management, activity monitoring, high availability, security, and connectivity and networking, among other issues.
This book will help you pass IBM Exam C2090-313 and become an IBM Certified Application Developer - DB2 11 for z/OS. The 180 questions and answers in the book (three full practice exams) offer you a significant advantage by helping you to gauge your readiness for the exam, to better understand the objectives being tested, and to get a broad exposure to the DB2 11 knowledge you'll be tested on.
This book will help you learn the basic information and skills you need to develop applications with DB2 11 for z/OS. The instruction, examples and questions/answers in this book are a fast track to becoming productive as quickly as possible. The content is easy to read and digest, well organized and focused on honing real job skills. DB2 11 for z/OS Basic Training for Application Developers is a key step in the direction of mastering DB2 application development so you'll be ready to join a technical team.
Author: Craig S. Mullins
Release Date: 2012-10-11
Genre: Business & Economics
Database Administration, Second Edition , is the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices and proven solutions for any database platform or environment, this text fully reflects the field’s latest realities and challenges. Drawing on more than thirty years of database experience, Mullins focuses on problems that today’s DBAs actually face, and skills and knowledge they simply must have. Mullins presents realistic, thorough, and up-to-date coverage of every DBA task, including creating database environments, data modeling, normalization, design, performance, data integrity, compliance, governance, security, backup/recovery, disaster planning, data and storage management, data movement/distribution, data warehousing, connectivity, metadata, tools, and more. This edition adds new coverage of “Big Data,” database appliances, cloud computing, and NoSQL. Mullins includes an entirely new chapter on the DBA’s role in regulatory compliance, with substantial new material on data breaches, auditing, encryption, retention, and metadata management. You’ll also find an all-new glossary, plus up-to-the-minute DBA rules of thumb.
Author: Grant Allen
Release Date: 2008-11-20
IBM’s DB2 Express Edition is one of the most capable of the free database platforms available in today’s marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you’ll find: A friendly introduction to DB2 Express Edition, an industrial–strength, relational database from IBM Dozens of examples so that you are never in doubt as to how things work Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more The book is aimed at developers who want a robust database to back their applications.
The Easy, Visual Way to Master IBM® DB2 for Linux®, UNIX®, and Windows®—Fully Updated for Version 9.5 IBM DB2 9 and DB2 9.5 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2: Learning Visually with Examples, Second Edition, is the easiest way to master the latest versions of DB2 and apply their full power to your business challenges. Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors' experience working with DB2 in enterprise environments. Thoroughly updated for DB2 9.5, it covers new innovations ranging from manageability to performance and XML support to API integration. Each concept is presented with easy-to-understand screenshots, diagrams, charts, and tables. This book is for everyone who works with DB2: database administrators, system administrators, developers, and consultants. With hundreds of well-designed review questions and answers, it will also help professionals prepare for the IBM DB2 Certification Exams 730, 731, or 736. Coverage includes Choosing the right version of DB2 for your needs Installing and configuring DB2 Understanding the DB2 environment, instances, and databases Establishing client and server connectivity Working with database objects Utilizing breakthrough pureXML™ technology, which provides for nativeXML support Mastering administration, maintenance, performance optimization, troubleshooting, and recovery Understanding improvements in the DB2 process, memory, and storage models Implementing effective database security Leveraging the power of SQL and XQuery