• Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition)

      The #1 Easy, Commonsense Guide to Database Design! Michael J. Hernandez’s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices. Step by step, Database Design for Mere Mortals ® , Third Edition, shows you how to design databases that are soundly structured, reliable, and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules.   Coverage includes Understanding database types, models, and design terminology Discovering what good database design can do for you—and why bad design can make your life miserable Setting objectives for your database, and transforming those objectives into real designs Analyzing a current database so you can identify ways to improve it Establishing table structures and relationships, assigning primary keys, setting ...

    • ASIN: 0321884493

  • The Mere Mortal's Guide to Fine Dining: From Salad Forks to Sommeliers, How to Eat and Drink in Style Without Fear of Faux Pas

    From aperitif to digestif, approach every meal with savvy and grace.We’ve all experienced Fancy-Pants Restaurant Jitters at some point – the fear that you will unknowingly commit some fine-dining crime, whether it’s using the wrong fork, picking an amateur wine, mispronouncing foie gras, or gasping when your fish entrée arrives with its head still attached. Relax. The Mere Mortal’s Guide to Fine Dining is the ultimate antidote to restaurant anxiety. Where does your napkin go when you leave the table? Should you sniff the wine cork? And why, pray tell, are there so many forks? This comprehensive and accessible primer answers these and dozens of other questions and offers the basics on every aspect of fine dining, including:* How to navigate a place setting* Speaking menu-ese and the language of fine food* A refresher on polite and polished table manners* 911 for wine novices* A carnivore’s guide to beef, pork, lamb, and veal* What local, sustainable, and organic really mean* Japanese dining dos and don’ts* Who’s who on a restaurant’s staff* How to be a regular—or get the perks like one* Top restaurants across the country* What the food snobs know (and you should, too)* And much more…With a little help, any Mere Mortal can order wine with confidence, get great,...

    • Brand: Rush, Colleen
    • ASIN: 0767922034

  • SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (4th Edition)

    The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions Foreword by Keith W. Hare, Vice Chair, USA SQL Standards Committee SQL 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 ...

    • ASIN: 0134858336

  • SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition)

    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 f...

    • Brand: Addison-Wesley Professional
    • ASIN: 0321992474
    • UPC: 884781011352

  • SQL QuickStart Guide: The Simplified Beginner's Guide To SQL

    The Ultimate Beginner's Guide To Learning SQL - From Retrieving Data To Creating Databases!Structured Query Language or SQL (pronounced sequel by many) is the most widely used programming language used in database management and is the standard language for Relational Database Management Systems (RDBMS). SQL programming allows users to return, analyze, create, manage and delete data within a database – all within a few commands. With more industries and organizations looking to the power of data, the need for an efficient, scalable solution for data management is required. More often than not, organizations implement a Relational Database Management System in one form or another. These systems create long-term data “warehouses” that can be easily accessed to return and analyze results, such as, “Show me all of the clients from Canada that have purchased more than $20,000 in the last 3 years.” This “query,” which would have taken an extensive amount of hands-on research to complete prior to the use of database, can now be determined in seconds by executing a simple SELECT SQL statement on a database.SQL can seem daunting to those with little to zero programming knowledge and can even pose a challenge to those that have experience with other languages. Most resou...

    • Brand: ClydeBank Media LLC
    • ASIN: B00UCFK44U

  • Project Management for Mere Mortals

    Praise for Project Management for Mere Mortals® “Project Management for Mere Mortals is a must read for all project managers with responsibilities for large or small projects, regardless of industry or product. Baca has cleverly taken the (sometimes) difficult lexicon of project management and distilled it into easy-to-read, understandable concepts. Her case study examples lead Project Managers from Project Initiation through Project Close–and those between–with ease. In today’s growing discipline of Project Management, we must understand the potential hurdles and where to capitalize on prior knowledge. Baca is a Project Management guru. No person involved with the execution of projects should be without this book…ever.” –Lisa Marie Jacobsen, CAPM, Project Manager, Newtown Square, Pennsylvania   “Project Management for Mere Mortals is an excellent book for the beginning as well as the experienced project manager. At the elementary level, the concepts are clearly explained, and at the advanced level, hints and tips are explained that give new insight to the concepts. I especially liked the case studies that applied each chapter’s lessons.” –Kaaren A. Walsh, PMP   “This book is an excellent learning tool for beginning Project Managers and a terrific r...

    • ASIN: 0321423453
    • UPC: 785342423457

  • SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (2nd Edition)

    Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a "Mere Mortal" will indeed be empowered to perform the superhuman. Do not walk past this book! --Graham Mandeno, Database Consultant SQL Queries for Mere Mortals provides a step-by-step, easy-to-read introduction to writing SQL queries. It includes hundreds of examples with detailed explanations. This book provides the tools you need to understand, modify, and create SQL queries --Keith W. Hare, Convenor, ISO/IEC JTC1 SC32 WG3--the International SQL Standards Committee I learned SQL primarily from the first edition of this book, and I am pleased to see a second edition of this book so that others can continue to benefit from its organized presentation of the language. Starting from how to design your tables so that SQL can be effective (a common problem for database beginners), and then continuing through the various aspects of SQL construction and capabilities, the reader can become a moderate expert upon completing the book and its samples. Learning how to convert a question in English into a meaningful SQL statement will greatly facilitate your mastery of the...

    • ASIN: 0321444434
    • UPC: 785342444438