Databases DeMYSTiFieD

November 22, 2010

Databases Demystified


Databases DeMYSTiFieD

Author: Andy Oppel
ISBN: 9780071747998 / 0071747990
©2011 | 2nd Edition | 448 pages | Paperback
Pub Date: DEC-10
Price: US$ 22.00
Learn More


Hard stuff made easy! Your practical, self-paced guide to database fundamentals

Databases Demystified, Second Edition is the curriculum-based tutorial for anyone overwhelmed by confusing subjects and complex textbooks. The book is user friendly, engaging, easy to follow, and designed for the student or non-expert wanting to quickly learn the ins and outs of databases and immediately apply the concepts learned.

Clear language, step-by-step discussions, and quizzes at the end of each chapter make understanding databases easy. Learn how to form database queries using Microsoft Access and SQL, explore methods for connecting a database to applications, and discover how to store historical data for analyses. From logical data design using normalization, to database security and data warehousing, this hands-on guide is simple enough for a beginner but challenging enough for an advanced student.

Databases Demystified, Second Edition

  • Covers Access 2010, the latest ANSI/ISO standard, and MySQL 5.5
  • Includes new coverage of advanced normal forms, UML diagrams, and integrating XML and objects into databases
  • Features chapter-opening objectives that offer insight into what you’re going to learn in each step
  • Provides questions at the end of every chapter to reinforce learning and pinpoint weaknesses
  • Contains a final exam for overall self-assessment


About the Author

Andrew J. (Andy) Oppel (Alameda, CA) is a proud graduate of The Boys’Latin School of Maryland and of Transylvania University (Lexington, Kentucky) where he earned a BA in computer science. He has been continuously employed in a wide variety of information technology positions, including programmer, programmer/analyst, systems architect, project manager, senior database administrator, database group manager, consultant, database designer, data modeler, and data architect.

In addition, he has served as a part-time instructor with the University of California, Berkeley, Extension, for more than 25 years and received the Honored Instructor Award for the year 2000. His teaching work included developing three courses for UC Extension, “Concepts of Database Management Systems,” “Introduction to Relational Database Management Systems,” and “Data Modeling and Database Design.” He also earned his Oracle 9i Database Associate certification in 2003. He is currently a senior data modeler for Blue Shield of California. Andy has designed and implemented hundreds of databases for a wide range of applications, including medical research, banking, insurance, apparel manufacturing, telecommunications, wireless communications, and human resources.

He is the author of Databases Demystified (McGraw-Hill Professional, 2004), SQL Demystified (McGraw-Hill Professional, 2005), Databases: A Beginner’s Guide (McGraw-Hill Professional, 2009), and Data Modeling: A Beginner’s Guide (McGraw-Hill Professional, 2010), and is co-author of two other books. His database product experience includes IMS, DB2, Sybase ASE, Microsoft SQL Server, Microsoft Access, MySQL, and Oracle (versions 7, 8, 8i, 9i, and 10g). The current edition of the book had 20 five-star reviews on Amazon.


Related Title

  1. 9780071608466 Databases A Beginner’s Guide


Read the rest of this entry »


The Technical Author – Robin Nixon

April 7, 2010

  

Robin NixonRobin Nixon has worked with and written about computers since the early 1980s (his first computer was a Tandy TRS 80 Model 1 with a massive 4KB of RAM!). During this time he has written in excess of 500 articles for many of the U.K.’s top computer magazines.

Robin started his computing career in the Cheshire homes for disabled people, where he was responsible for setting up computer rooms in a number of residential homes, and for evaluating and tailoring hardware and software so that disabled people could use the new technology – sometimes by means of only a single switch operated by mouth or finger.

After writing articles for computer magazines about his work with disabled people, he eventually worked full time for one of the country’s main IT magazine publishers, where he held several roles including editorial, promotions, and cover disc editing.

With the dawn of the Internet in the 1990s, Robin branched out into developing websites. One of these presented the world’s first radio station licensed by the music copyright holders, and was featured in several news reports on TV and radio networks in the United Kingdom. In order to enable people to continue to surf while listening, Robin also developed the first known pop-up windows.

Robin lives on the southeast coast of England with his wife Julie, a trained nurse, and five children, where he also finds time to foster three disabled children, as well as working full time from home as a technical author.

 

Robin has contributed an article to “The Daily Tip” section on “IT World,” and Plug-In PHP is one of the featured books on the company’s web site. For a look at the article, please click HERE.

Read the rest of this entry »


Plug-In PHP: 100 Power Solutions

March 8, 2010

 

Plug-In PHP

Plug-In PHP: 100 Power Solutions

Authors: Nixon, Robin
ISBN-13: 978-0-07-166659-6
ISBN-10: 0071666591
©2010 | 1st Edition | 384 pages , Softcover
Pub Date: March 2010
Price: US$ 39.99

   

100 PHP power solutions in one handy guide

This practical resource contains 100 ready-to-run PHP plug-ins you can use to create dynamic Web content. The book begins by showing you how to install, configure, and use a powerful web development environment. Then, each chapter in Plug-In PHP offers complete, working examples for specific end results you can achieve right away. In this time-saving tool, all of the code is extensively documented along with tips for adapting it for your own requirements.

Get ready-made PHP plug-ins for:

  • Text processing
  • Image handling
  • Content management
  • Forms and user input
  • Internet integration
  • Chat and messaging
  • MySQL, sessions, and cookies
  • APIs, RSS, and XML
  • JavaScript and Ajax
  • Geo-location
  • Spelling and language translation
  • And much more

Download all of the book’s plug-ins at www.pluginphp.com

   

About the Author

Robin Nixon (UK) is a developer and freelance technical writer who has published more than 500 articles in magazines such as PC Plus, PCW, Web User, .net, PC Advisor, and PC Answers. He is the author of 3 computing books, including the upcoming Learning PHP, MySQL & JavaScript (O’Reilly).

Learn More


Follow

Get every new post delivered to your Inbox.