Free Downloads
SQL Queries For Mere Mortals(R): A Hands-On Guide To Data Manipulation In SQL

Now there's a practical, hands-on guide to SQL for millions of beginning-to-intermediate database users who desperately need to create fast, accurate, effective queries -- whether they have formal database training or not. The authors begin by introducing the fundamental concepts underlying relational databases and SQL. They then introduce the absolute basics of SQL, including the SELECT statement, creating expressions, and applying filters. Next, they introduce techniques for solving one of the most common problems database users encounter: drawing data from multiple tables at once. The book includes detailed coverage of grouping, totaling, and summarizing data; using SQL to update, insert, and delete data; and more. In the final section, Hernandez and Viescas introduce "thinking out of the box" techniques that allow users to solve a wide variety of complex SQL problems. Most chapters end with sample problems, solutions, and result sets -- all based on a library of five real-world databases included on the accompanying CD-ROM.

Series: For Mere Mortals

Paperback: 528 pages

Publisher: Addison-Wesley Professional; 7th edition (August 31, 2000)

Language: English

ISBN-10: 0201433362

ISBN-13: 978-0201433364

Product Dimensions: 7 x 1 x 9.2 inches

Shipping Weight: 1.7 pounds

Average Customer Review: 4.2 out of 5 stars  See all reviews (60 customer reviews)

Best Sellers Rank: #376,676 in Books (See Top 100 in Books) #16 in Books > Computers & Technology > Databases & Big Data > Relational Databases #173 in Books > Computers & Technology > Databases & Big Data > SQL #386 in Books > Textbooks > Computer Science > Database Storage & Design

I have been using MS Access 2000 to develop database solutions for use in sales and marketing departments and needed to go to the next level and develop solutions based on SQL Server, so I was looking for a book to understand SQL queries better and thereby SQL Server. Knowing, that by writing your own SQL queries when working in Access you're able to develop a scaleable application that easily is transferred to SQL Server, the book helped me in this transition since all 5 sample databases included on the CD-ROM is available in both SQL Server 7.0 and MS Access 2000 files.After an introduction to relational database theory and the SQL language in the first 3 chapters, you'll start learning about queries and each of the remaining 14 chapters includes exercises that will train your skills in writing SQL queries. Throughout the book the authors make use of diagrams to visualize the SQL queries, in the beginning they may seem difficult to understand but as you get used to them you will find yourself reading them faster and faster.One of the things I learned the most from was the authors use of a 3-step method to write queries: A simple question in plain English to get the needed information from the data goes through a Translation, then a Clean Up, and finally you've got your SQL. With this method not only do you gain confidence but also an insight into the simple mathematical logic on which the queries are based.To accompany this book and enhance the knowledge you gain from reading it I recommend the following titles: On Access 2000 I recommend John Viescas' "Running MS Access 2000" (ISBN 1572319348), which in my opinion is one of the best books on Access 2000.

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition) SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) NoSQL for Mere Mortals Mere Mortals: Six One-Act Comedies - Acting Edition Data Analytics: Practical Data Analysis and Statistical Guide to Transform and Evolve Any Business Leveraging the Power of Data Analytics, Data Science, ... (Hacking Freedom and Data Driven Book 2) Data Architecture: A Primer for the Data Scientist: Big Data, Data Warehouse and Data Vault Mind Control Mastery 4th Edition: Successful Guide to Human Psychology and Manipulation, Persuasion and Deception! (Mind Control, Manipulation, Deception, ... Psychology, Intuition, Manifestation,) Dental Materials: Properties and Manipulation, 9e (Dental Materials: Properties & Manipulation (Craig)) Data Analysis with Microsoft Access 2010: From Simple Queries to Business Intelligence SQL: Beginner's Guide for Coding SQL (database programming, computer programming, how to program, sql for dummies, java, mysql, The Oracle, python, PHP, ... (HTML, Programming, Coding, CSS Book 7) Big Data For Beginners: Understanding SMART Big Data, Data Mining & Data Analytics For improved Business Performance, Life Decisions & More! The Data Revolution: Big Data, Open Data, Data Infrastructures and Their Consequences Learning Core Data for iOS with Swift: A Hands-On Guide to Building Core Data Applications Queries & Submissions (Elements of Article Writing) Discovering Knowledge in Data: An Introduction to Data Mining (Wiley Series on Methods and Applications in Data Mining) Big Data, MapReduce, Hadoop, and Spark with Python: Master Big Data Analytics and Data Wrangling with MapReduce Fundamentals using Hadoop, Spark, and Python LEARN IN A DAY! DATA WAREHOUSING. Top Links and Resources for Learning Data Warehousing ONLINE and OFFLINE: Use these FREE and PAID resources to Learn Data Warehousing in little to no time