Описание: The #1 Easy, Common-Sense Guide to SQL Queries--Updated with More Advanced Techniques and SolutionsForeword by Keith W. Hare, Vice Chair, USA SQL Standards CommitteeSQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques. Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think "outside the box." In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation. Practice all you want with downloadable sample databases for today's versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL and PostgreSQL databases. Whether you're a DBA, developer, user, or student, there's no better way to master SQL. 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
NEW Using advanced GROUP BY keywords to create subtotals, roll-ups, and more
NEW Applying window functions to answer more sophisticated questions, and gain deeper insight into your data
Software-Independent Approach If you work with database software such as Access, MS SQL Server, Oracle, DB2, MySQL, Ingres, or any other SQL-based program, this book could save you hours of time and aggravation--before you write a single query
Every day, funeral director Caitlin Doughty receives dozens of questions about death. The best questions come from kids. What would happen to an astronaut's body if it were pushed out of a space shuttle? Do people poop when they die? Can Grandma have a Viking funeral?
In Will My Cat Eat My Eyeballs?, Doughty blends her mortician's knowledge of the body and the intriguing history behind common misconceptions about corpses to offer factual, hilarious, and candid answers to thirty-five distinctive questions posed by her youngest fans. In her inimitable voice, Doughty details lore and science of what happens to, and inside, our bodies after we die. Why do corpses groan? What causes bodies to turn colors during decomposition? And why do hair and nails appear longer after death? Readers will learn the best soil for mummifying your body, whether you can preserve your best friend's skull as a keepsake, and what happens when you die on a plane.
Beautifully illustrated by Diann Ruz, Will My Cat Eat My Eyeballs? shows us that death is science and art, and only by asking questions can we begin to embrace it.
Описание: From what we know of history, Egypt, along with Sumer, were the foundations of civilization. The Fertile Crescent, which stretched from the Nile Valley to the twin rivers in Mesopotamia, gave us our earliest glimpse of organized man. But organized how? For one, both locations gave us writing-hieroglyphics in Egypt and cuneiform in Sumer.
Описание: This title is part of UC Press's Voices Revived program, which commemorates University of California Press's mission to seek out and cultivate the brightest minds and give them voice, reach, and impact. Drawing on a backlist dating to 1893, Voices Revived makes high-quality, peer-reviewed scholarship accessible once again using print-on-demand technology. This title was originally published in 1993.
Автор: Cruickshank MR Pete Название: The Kinsmen: Between Gods and Mortals ISBN: 0992796407 ISBN-13(EAN): 9780992796402 Издательство: Неизвестно Цена: 1895.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Captivating Stories of the Gods, Goddesses, Monsters and Mortals This book on Egyptian mythology is part of the best-selling series "Norse Mythology - Egyptian Mythology - Greek Mythology." In this ultimate guide on Egyptian Mythology, you will discover captivating stories of the Gods, Goddesses, Monsters, and Mortals. In this book, you will also find factual history as well as insightful information regarding Egyptian mythology. This book is broken into two parts:
Fantastic Images-Ancient Egyptian myths and legends as we know them today.
Factual History-Covering pre-history through classical antiquity.
This book is jam-packed with fascinating facts and stories. For instance, it covers perhaps the most popular of all the Egyptian stories - the myth of Osiris. Pieces of this story have been found throughout Egypt. One of the most appealing aspects of the Osiris myth is the human-like behavior of the gods within the story. Many of the other gods of the Egyptian pantheon were rather emotionless and their stories far less interesting. With the Osiris story, the gods display a broad range of emotions that made them more real to mere mortals. Just some of the questions and topics covered in this book include:
Creation
Fall of Humanity
Osiris Myth
Chief Gods of the Egyptian Pantheon
Lesser Known Pantheon
Ancient Egyptian History
Get the book now and learn more about egyptian mythology
Автор: Matsuo Alex Название: The Brave Mortal`s Guide to Ghost Hunting ISBN: 1707543712 ISBN-13(EAN): 9781707543717 Издательство: Неизвестно Цена: 2585.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: If you could ask a ghost any question, what would it be? Have you thought about ghost hunting? Do you dream of exploring a haunted locale but don't know where to start? Want to learn more about ghost hunting, but you don't understand all of the paranormal lingo? The excitement of ghost hunting is enticing people all over the world. Whether it's solving the mystery of the afterlife or the allure of the unknown, the paranormal field teases us just enough to want to dive in head-on. But exploring the paranormal can also be overwhelming and confusing. In this book, you will learn about multiple areas of the paranormal from ghost hunting, research, evidence review, equipment, to what to do when you encounter a ghost. Join Alex Matsuo, respected paranormal researcher and leader in the ghost hunting field, as she walks you through the basics of becoming a ghost hunter. Alex is known for her balance of skepticism, belief, and rigorous research. You can apply her strategies to your paranormal experience with this how-to manual. Are you brave enough to take the plunge?
Описание: "Experimental Investigation of the Spirit Manifestations" is an 1855 work by American chemist Robert Hare. In this volume, Hare deals with the subject of spiritualism, a religious movement based on the belief that spirits of the deceased exist and are able to communicate with living people. He explores in detail the evidence for the existence of spirits, looking at purported methods of communication, historical cases from around the world, intuitive evidence, and more. This vintage book is highly recommended for those with an interest in spiritualism and the existence of an afterlife, and it is not to be missed by collectors of related literature. Robert Hare (1781 - 1858) was an early American chemist. Other notable works by this author include: "Chemical Apparatus and Manipulations" (1836), "Compendium of the Course of Chemical Instruction in the Medical Department of the University of Pennsylvania" (1840), and "Memoir on the Explosiveness of Niter" (1850). Contents include: "The Evidence of the Existence of a Deity", "Intuitive Evidence of the Existence of Spirits", "Corroborative Evidence of the Existence of Spirits", "Foreign Corroborative Evidence of the Existence of Spirits", "Communications from the Spirit World", "Of Spiritual Birth", "Convocation of Spirits", etc. Many vintage books such as this are becoming increasingly scarce and expensive. We are republishing this volume now in an affordable, modern, high-quality edition complete with the original text and artwork.
Описание: Shock And Awe is a way of gaining superior shape, definition and balance. If you're a competitive bodybuilder, fitness, figure or physique athlete, actor, model, dancer, trainer or beach bum, Shock And Awe is a super-productive tool for the everyday and competitive athlete alike. Shock And Awe will push stamina and endurance to extremes while virtually eliminating injury. It is greatly challenging, yet overly satisfying when you look in the mirror at the fine, balanced, proportionate body in front of you. If your gym time is limited, this is the top-level executive workout that makes every minute count.This is the workout book that will take your level of training to being the envy of every BODY in the gym.People will ask what you're doing to achieve your muscularity, and how they can get some. Shock And Awe will make your physique stand out from the "mere mortals."
Описание: This title is part of UC Press's Voices Revived program, which commemorates University of California Press's mission to seek out and cultivate the brightest minds and give them voice, reach, and impact. Drawing on a backlist dating to 1893, Voices Revived makes high-quality, peer-reviewed scholarship accessible once again using print-on-demand technology. This title was originally published in 1993.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
