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