Book Description

Introduce your students to the new generation of Microsoft Office with the new generation of Shelly Cashman Series books! For the past three decades, the Shelly Cashman Series has effectively introduced computer skills to millions of students. With Access 2010, we’re continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today’s students. In Microsoft Access 2010: Complete you’ll find features that are specifically designed to engage students, improve retention, and prepare them for future success. Our trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of the Access 2010 software through experimentation, exploration, and planning ahead. Brand new end of chapter exercises prepare students to become more capable software users by requiring them to use critical thinking and problem-solving skills to create real-life documents.

• A step-by-step, screen-by-screen approach allows students to successfully learn and retain information to be used in their personal and professional lives
• Increases students’ retention with brand new end-of-chapter exercises, including Make It Right, Extend Your Knowledge, and Make It Personal, which emphasize problem-solving and experimentation.

Table of Contents
Access Common Elements.
1. Databases and Database Objects: An Introduction. Download Now »

Book Description

SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL.

This second edition includes new material on recursive queries, “missing information” without nulls, new update operators, and topics such as aggregate operators, grouping and ungrouping, and view updating. If you have a modest-to-advanced background in SQL, you’ll learn how to deal with a host of common SQL dilemmas.

• Why is proper column naming so important?
• Nulls in your database are causing you to get wrong answers. Why? What can you do about it?
• Is it possible to write an SQL query to find employees who have never been in the same department for more than six months at a time?
• SQL supports “quantified comparisons,” but they’re better avoided. Why? How do you avoid them?
• Constraints are crucially important, but most SQL products don’t support them properly. What can you do to resolve this situation?

Database theory and practice have evolved since the relational model was developed more than 40 years ago. SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of SQL available. Download Now »

Book Description

MongoDB in Action is a comprehensive guide to MongoDB for application developers. The book begins by explaining what makes MongoDB unique and describing its ideal use cases. A series of tutorials designed for MongoDB mastery then leads into detailed examples for leveraging MongoDB in e-commerce, social networking, analytics, and other common applications.

Big data can mean big headaches. MongoDB is a document-oriented database designed to be flexible, scalable, and very fast, even with big data loads. It’s built for high availability, supports rich, dynamic schemas, and lets you easily distribute data across multiple servers.

MongoDB in Action introduces you to MongoDB and the document-oriented database model. This perfectly paced book provides both the big picture you’ll need as a developer and enough low-level detail to satisfy a system engineer. Numerous examples will help you develop confidence in the crucial area of data modeling. You’ll also love the deep explanations of each feature, including replication, auto-sharding, and deployment

This book is written for developers. No MongoDB or NoSQL experience required.

What’s Inside

• Indexes, queries, and standard DB operations
• Map-reduce for custom aggregations and reporting
• Schema design patterns Download Now »

Book Description

With the rise of Web 2.0, the need for a highly scalable database, capable of storing diverse user-generated content is increasing. MongoDB, an open-source, non-relational database has stepped up to meet this demand and is being used in some of the most popular websites in the world. MongoDB is one of the NoSQL databases which is gaining popularity for developing PHP Web 2.0 applications.

PHP and MongoDB Web Development Beginner’s Guide is a fast-paced, hands-on guide to get started with web application development using PHP and MongoDB. The book follows a “Code first, explain later” approach, using practical examples in PHP to demonstrate unique features of MongoDB. It does not overwhelm you with information (or starve you of it), but gives you enough to get a solid practical grasp on the concepts.

The book starts by introducing the underlying concepts of MongoDB. Each chapter contains practical examples in PHP that teache specific features of the database.
The book teaches you to build a blogging application, handle user sessions and authentication, and perform aggregation with MapReduce. You will learn unique MongoDB features and solve interesting problems like real-time analytics, location-aware web apps etc. You will be guided to use MongoDB alongside MySQL to build a diverse data back-end.

With its concise coverage of concepts and numerous practical examples, PHP and MongoDB Web Development Beginner’s Guide is the right choice for the PHP developer to get started with learning MongoDB. Download Now »

Book Description

It hasn’t taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open-source combination. Add this book to the mix, and there’s no limit to the powerful, interactive Web sites that developers can create. With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This guide is indispensable for beginning to intermediate level Web designers who want to replace their static sites with something dynamic. In this edition, the bulk of the new material covers the latest features and techniques with PHP and MySQL. Also new to this edition are chapters introducing jQuery and object-oriented programming techniques.

Table of Contents
Introduction
Chapter 1. Introduction to PHP
Chapter 2. Programming with PHP
Chapter 3. Creating Dynamic Web Sites
Chapter 4. Introduction to MySQL Download Now »

Book Description

If you can build websites with CSS and JavaScript, this book takes you to the next level—creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users through queries and web forms. With step-by-step tutorials, real-world examples, and jargon-free explanations, you’ll soon discover the power of server-side programming.

The important stuff you need to know:

• Get a running start. Write PHP scripts and create a web form right away.
• Learn the language. Get up to speed on PHP and SQL syntax quickly.
• Build a database. Use MySQL to store user information and other data.
• Make it dynamic. Create pages that change with each new viewing.
• Be ready for mistakes. Plan error messages to help direct users.
• Manage your content. Use the file system to access user data, including images and other binary files.
• Control operations. Create an administrative interface to oversee your site.

Table of Contents
Part I: PHP and MySQL Basics
Chapter 1. PHP: What, Why, and Where?
Chapter 2. PHP Syntax: Weird and Wonderful Download Now »