Beginning SQL Queries: From Novice to Professional

Clare Churcher’s Beginning SQL Queries is your guide to mastering the lingua franca of the database industry: the SQL language. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare lays well in her book.

* Does not bore with syntax!
* Helps you learn the underlying concepts involved in querying a database, and from there the syntax is easy
* Provides exceptionally clear examples and explanations
* Is academically sound while being practical and approachable

What you’ll learn

* Write simple queries to extract data from a single table.
* Understand relational algebra and calculus and why they are important.
* Combine data from many tables into one business result.
* Avoid pitfalls and traps such as Cartesian products and difficulties with null values.
* Summarize large amounts of data for reporting purposes.
* Apply set theory to the problems of manipulating data and generating reports.


Who is this book for?

Beginning SQL Queries is aimed at intelligent laypeople who need to extract information from a database, and at developers and other IT people who are new to SQL. The book is especially useful for business intelligence analysts who must ask more complex questions of their database than their GUI–based reporting software supports. Such people might be business owners wanting to target specific customers, scientists and students needing to extract subsets of their research data, or end users wanting to make the best use of databases for their clubs and societies.
About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry–level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from “novice to professional.” You’ll start your journey by seeing what you need to know—but without needless theory and filler. You’ll build your skill set by learning how to put together real–world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there—it is your trusted guide through unfamiliar territory!
Related Titles

* Beginning Database Design: From Novice to Professional
* Date on Database: Writings 2000-2006
* Applied Mathematics for Database Professionals



About the Author
Clare Churcher holds a Ph.D. in physics and has designed several databases for a variety of large and small projects. She is currently the head of the applied computing group at Lincoln University where her teaching has included analysis and design, database, and programming. She has supervised over 70 undergraduate projects designing databases for small projects.
Download Here

Patterns of Software: Tales from the Software Community

A wide-ranging set of essays by a long-time Silicon Valley insider. Gabriel muses on software development, factors that have led to the success or failure of software companies, the nature of successful programming languages, and more. Evidently, Gabriel is currently writing poetry, and his concern for language and the well-turned phrase shows up in this book as well.

Download Here

Professional SharePoint 2007 Development

Product Description

* Beginning with an introduction to the technologies in Microsoft's application platform, this thorough guide then goes on to highlight the technologies in SharePoint 2007 that are new for developers
* The author team focuses on how SharePoint fits in and complements the underlying platform; this is discussed throughout the book so that readers can learn how to take existing investments in the MSFT platform and move those to SharePoint
* Places special emphasis on the key areas of SharePoint development: base platform, collaboration, portal and composite application frameworks, enterprise search, ECM, business process/workflow/electronic forms and finally business intelligence
* Demonstrates how to develop applications with RSS, blogs, and wikis; use and customize enterprise search, XML, XSLT in search, and the search Web service; build Portal solutions; and develop Collaboration using calendars, tasks, issues and email events




From the Back Cover
If you're a .NET or Microsoft Office developer, this book gives you the tools to utilize the entire SharePoint platform. It offers practical insights that will help you take advantage of this integrated suite of server capabilities along with specific examples of how to implement classes of solutions on top of the platform. You'll be able to apply this information in order to create a collaborative environment and build web-based applications.

You'll build your SharePoint foundation on the solid details provided on SharePoint technologies, architecture, and development tools. The core of the book takes you into the key areas of development on SharePoint: base platform, collaboration, enterprise search, enterprise content management (ECM), records management (RM), document management (DM), web content management (WCM), workflow, electronic forms, and business intelligence. With these skills, you will be able to set up a SharePoint environment that enhances productivity and delivers rich-looking sites.

What you will learn from this book

* All about the Microsoft® Application Platform, WSS 3.0, MOSS 2007, and SharePoint's relationship to ASP.NET
*

What tools you'll need and how to build your development environment
*

Ways to enhance collaboration using calendars, tasks, issues, lists, and e-mail events
*

Techniques for developing applications with RSS, blogs, and wikis
*

Strategies for using enterprise search, XML, and XSLT
*

How to create solutions integrating custom workflows and e-forms

Who this book is for

This book is for ASP.NET, .NET, and Microsoft Office developers who want to learn SharePoint development. .NET code examples are given in C#.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Enhance Your Knowledge

Advance Your Career

Download Here

Head First PMP: A Brain-Friendly Guide to Passing the Project Management Professional Exam

A PMP certification is more than just passing a test. It means that you have the knowledge to solve most common project problems, and proves that you know your stuff. Once you're certified, your projects are more likely to succeed because you have the skills and knowledge to make them successful. Not only that, it can mean a better job, more money, and greater respect from your peers.

But studying for a difficult four-hour exam on project management isn't easy, even for experienced project managers. You want to remember everything that you're learning about project management, but your brain is working against you! Your brain craves novelty, and most PMP certification prep books are anything but novel. When you keep putting down a boring book instead of studying, it's because your brain doesn't think the information in it is worth learning. Your brain has more important stuff to think about, like how to keep you alive and out of danger-and it doesn't think that failing the PMP exam qualifies as life-threatening!


So how do you trick your brain into thinking that your life does depend on learning everything you need to know to pass the PMP Exam? Head First PMP is the answer! Using the latest research in neurobiology, cognitive science and learning theory, Head First PMP has a visually rich format designed for the way your brain works-a multi-sensory experience that helps the material stick, not a text-heavy approach that puts you to sleep.

Head First PMP offers 100% coverage of The PMBOK® Guide principles and certification objectives in a way that's engaging, not tedious. This book helps you prepare for the PMP certification exam with a unique method that goes beyond answers to specific questions and makes you think about the big picture of project management. By putting project management concepts into context, you will be able to understand, remember, and apply them-not just on the exam, but also on the job.

With Head First PMP, you get the best of both worlds: a thorough and effective preparation guide for the PMP certification exam with hundreds of practice questions and exam strategies, along with puzzles, games, problems, exercises and the unique Head First approach that makes learning easy and entertaining. When you're done with Head First PMP, you'll know your stuff, you'll pass the exam, and you'll be able to bring everything you've learned to your job.
Download Here