The #1 Easy, Common-Sense Guide to SQL Queries--Updated for Today's Databases, Standards, and Challenges SQL Queries for Mere Mortals ® has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques. Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Three brand-new chapters teach you how to solve a wide range of challenging SQL problems. You'll learn how to write queries that apply multiple complex conditions on one table, perform sophisticated logical evaluations, and think "outside the box" using unlinked tables. Coverage includes -- Getting started: understanding what relational databases are, and ensuring that your database structures are sound -- SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE -- Summarizing and grouping data with GROUP BY and HAVING clauses -- Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries -- Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more Practice all you want with downloadable sample databases for today's versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL database. Whether you're a DBA, developer, user, or student, there's no better way to master SQL. informit.com/aw forMereMortals.com

In this thought-provoking follow-up to his acclaimed StarTalk book, uber astrophysicist Neil deGrasse Tyson tackles the world's most important philosophical questions about the universe with wit, wisdom, and cutting-edge science. For science geeks, space and physics nerds, and all who want to understand their place in the universe, this enlightening new book from Neil deGrasse Tyson offers a unique take on the mysteries and curiosities of the cosmos, building on rich material from his beloved StarTalk podcast. In these illuminating pages, illustrated with dazzling photos and revealing graphics, Tyson and co-author James Trefil, a renowned physicist and science popularizer, take on the big questions that humanity has been posing for millennia--How did life begin? What is our place in the universe? Are we alone?--and provide answers based on the most current data, observations, and theories. Populated with paradigm-shifting discoveries that help explain the building blocks of astrophysics, this relatable and entertaining book will engage and inspire readers of all ages, bring sophisticated concepts within reach, and offer a window into the complexities of the cosmos. or all who loved National Geographic's StarTalk with Neil deGrasse Tyson, Cosmos: Possible Worlds, and Space Atlas, this new book will take them on more journeys into the wonders of the universe and beyond.

This book constitutes the refereed proceeding of the 7th International Conference on Flexible Query Answering Systems, FQAS 2006, held in Milan, Italy in June 2006. The 60 revised full papers presented were carefully reviewed and selected from numerous submissions. The papers are organized in topical sections on flexibility in database management and quering, vagueness and uncertainty in XML quering and retrieval, information retrieval and filtering, multimedia information access, user modeling and personalization, knowledge and data extraction, intelligent information extraction from text, and knowledge representation and reasoning.

Learn to crunch huge amounts of data with PowerPivot and Power Query Do you have a ton of data you need to make sense of? Microsoft’s Excel program can handle amazingly large data sets, but you’ll need to get familiar with PowerPivot and Power Query to get started. And that’s where Dummies comes in. With step-by-step instructions—accompanied by ample screenshots—Excel PowerPivot & Power Query For Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization’s data. Then use PowerPivot to model it in Excel. You’ll also learn to: Make use of databases to store large amounts of data Use custom functions to extend and enhance Power Query Add the functionality of formulas to PowerPivot and publish data to SharePoint If you’re expected to wrangle, interpret, and report on large amounts of data, Excel PowerPivot & Power Query For Dummies gives you the tools you need to get up to speed quickly.

Following on from Rob Davis’ successful introductory book, ARIS Design Platform: Getting Started with BPM, Rob now covers in detail some of the more advanced concepts of using ARIS Business Architect. This is a practical ‘how-to’ guide and contains tips, techniques and short cuts gained from practical experience and explains clearly how to use ARIS and why ARIS is a powerful tool for process modeling. Advanced concepts such as the following are presented in this reader-friendly and concise guide: - Matrix editor, - Find and query, - Model generation, - Method filters and method changes, - Templates and fonts, - Reports and semantic checks, - Macros, - Transformations, - Database administration, - User management. This easy-to-follow advanced text is a must have guide and reference for all users who want to increase their ARIS skills, and for those who need to undertake advanced model and database management.

* A completely revised edition of a book that is highly-regarded in the community (as evidenced by Amazon reviews and other customer feedback). * The only comprehensive, practical guide to performance optimization techniques for SQL Server applications. * Essential reading for any DBA or developer resposible for the eprformance of an exisiting SQL Server system, or the design of a new one.