Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and the publisher was aware of a trademark claim, the designations have been printed with initial capital letters or in all capitals.

The author and publisher have taken care in the preparation of this book, but make no expressed or implied warranty of any kind and assume no responsibility for errors or omissions. No liability is assumed for incidental or consequential damages in connection with or arising out of the use of the information or programs contained herein.

For information about buying this title in bulk quantities, or for special sales opportunities (which may include electronic versions; custom cover designs; and content particular to your business, training goals, marketing focus, or branding interests), please contact our corporate sales department at [email protected] or (800) 382-3419.

For government sales inquiries, please contact [email protected].

For questions about sales outside the U.S., please contact [email protected].

Visit us on the Web: informit.com/aw

Library of Congress Control Number: 2016941977

Copyright © 2017 Pearson Education, Inc.

All rights reserved. Printed in the United States of America. This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permissions, request forms and the appropriate contacts within the Pearson Education Global Rights & Permissions Department, please visit www.pearsoned.com/permissions/.

The following are registered trademarks of Google: Android^™, Google Play^™.

Google and the Google logo are registered trademarks of Google Inc., used with permission.

The following are trademarks of HWACI: SQLite, sqlite.org, HWACI.

Gradle is a trademark of Gradle, Inc.

Linux^® is the registered trademark of Linus Torvalds in the U.S. and other countries.

Square is a registered trademark of Square, Inc.

Facebook is a trademark of Facebook, Inc.

Java and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates.

MySQL trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates.

The following are registered trademarks of IBM: IBM, IMS, Information Management System.

PostgreSQL is copyright © 1996-8 by the PostgreSQL Global Development Group, and is distributed under the terms of the Berkeley license.

Some images in the book originated from the sqlite.org and used with permission.

Twitter is a trademark of Twitter, Inc.

ISBN-13: 978-0-13-443799-6
ISBN-10: 0-13-443799-3

Text printed in the United States on recycled paper at RR Donnelley
in Crawfordsville, Indiana.
First printing, July 2016

Publisher
Mark L. Taub

Executive Editor
Laura Lewin

Development Editor
Michael Thurston

Managing Editor
Sandra Schroeder

Full-Service Production Manager
Julie B. Nahil

Project Editor
codeMantra

Copy Editor
Barbara Wood

Indexer
Cheryl Lenser

Proofreader
codeMantra

Editorial Assistant
Olivia Basegio

Cover Designer
Chuti Prasertsith

Compositor
codeMantra