Mastering material for dealing with DBA certification exams
Key Features
- Prepare yourself for the IBM C2090-600 certification exam
- Cover over 50 Db2 procedures including database design, performance, and security
- Work through over 150 Q&As to gain confidence on each topic
Book Description
IBM Db2 is a relational database management system (RDBMS) that helps you store, analyze, and retrieve data efficiently. This comprehensive book is designed to help you master all aspects of IBM Db2 database administration and prepare you to take and
pass IBM's Certification Exams C2090-600. Building on years of extensive experience,
the authors take you through all areas covered by the test. The book delves deep into each certification topic: Db2 server management, physical design, business rules implementation, activity monitoring, utilities, high availability, and security. IBM Db2 11.1 Certification Guide provides you with more than 150 practice questions and answers, simulating real certification examination questions. Each chapter includes an extensive set of practice questions along with carefully explained answers.
This book will not just prepare you for the C2090-600 exam but also help you troubleshoot day-to-day database administration challenges.
What you will learn
- Configure and manage Db2 servers, instances, and databases
- Implement Db2 BLU Acceleration and a DB2 pureScale environment
- Create, manage, and alter Db2 database objects
- Use the partitioning capabilities available within Db2
- Enforce constraint checking with the SET INTEGRITY command
- Utilize the Db2 problem determination (db2pd) and dsmtop tools
- Configure and manage HADR
- Understand how to encrypt data in transit and at rest
Who this book is for
The IBM Db2 11.1 Certification Guide is an excellent choice for database administrators, architects, and application developers who are keen to obtain certification in Db2. Basic understanding of Db2 is expected in order to get the most out of this guide.
Rajdeep Dua has over 16 years of experience in the Cloud and Big Data space. He worked in the advocacy team for Google's big data tools, BigQuery. He worked on the Greenplum big data platform at VMware in the developer evangelist team. He also worked closely with a team on porting Spark to run on VMware's public and private cloud as a feature set. He has taught Spark and Big Data at some of the most prestigious tech schools in India: IIIT Hyderabad, ISB, IIIT Delhi, and College of Engineering Pune.
Currently, he leads the developer relations team at Salesforce India. He also works with the data pipeline team at Salesforce, which uses Hadoop and Spark to expose big data processing tools for developers.
His contributions to the open source community are related to Docker, Kubernetes, Android, OpenStack, and cloudfoundry.
Manpreet Singh Ghotra has more than 12 years of experience in software development for both enterprise and big data software. He is currently working on developing a machine learning platform using Apache Spark at Salesforce. He has worked on a sentiment analyzer using the Apache stack and machine learning.
He was part of the machine learning group at one of the largest online retailers in the world, working on transit time calculations using Apache Mahout and the R Recommendation system using Apache Mahout.
With a master's and postgraduate degree in machine learning, he has contributed to and worked for the machine learning community.
Nick Pentreath has a background in financial markets, machine learning, and software development. He has worked at Goldman Sachs Group, Inc., as a research scientist at the online ad targeting start-up, Cognitive Match Limited, London, and led the data science and analytics team at Mxit, Africa's largest social network.
He is a cofounder of Graphflow, a big data and machine learning company focused on user-centric recommendations and customer intelligence. He is passionate about combining commercial focus with machine learning and cutting-edge technology to build intelligent systems that learn from data to add value to the bottom line.
Nick is a member of the Apache Spark Project Management Committee.
