- Home Page /
- Books /
- Computing & Internet /
- Databases /
- Data Storage & Management /
- Database Management Systems /
- SQL Queries for Mere Mortals: A Hands-On Guid...
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
85% of respondents would recommend this to a friend
TWD 2216
Price Details
Excluding Shipping & Custom charges ( Shipping and custom charges will be calculated on checkout )
*All items will import from UK
17%
QTY:
Ubuy works hard to protect your security and privacy. Our advanced payment security system ensures confidentiality by encrypting your information during transmission using AES (Advanced Encryption Standards) and SSL (Secure Socket Layer) protocols. Your payment details are 100% secure as we do not share your payment details with third party sellers.
SQL Queries for Mere Mortals is the #1 easy-to-read, commonsense guide to SQL, packed with ready-to-use examples
Fast
Shipping
Free
Return*
Secure Packaging
100% Original Products
PCI DSS Compliance
ISO 27001 Certified
What Stands Out
Product Details
- 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 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 soundSQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERESummarizing and grouping data with GROUP BY and HAVING clausesDrawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueriesModifying data sets with UPDATE, INSERT, and DELETE statementsAdvanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and moreNEW! Using advanced GROUP BY keywords to create subtotals, roll-ups, and moreNEW! Applying window functions to answer more sophisticated questions, and gain deeper insight into your dataSoftware-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!
| Publisher | Addison-Wesley Professional |
| Publication date | 19 April 2018 |
| Edition | 4th |
| Language | English |
| Print length | 960 pages |
| ISBN-10 | 0134858336 |
| ISBN-13 | 978-0134858333 |
| Item weight | 1.05 kg |
| Dimensions | 5.33 x 17.78 x 23.11 cm |
| Part of series | For Mere Mortals |
Who Should Buy?
-
Beginners in SQL
Ideal for individuals new to SQL, it provides foundational knowledge and practical exercises to enhance learning.
-
Data Analysts
Data analysts looking to improve their SQL skills will find this book helpful for manipulating and querying data effectively.
-
Self-learners
Perfect for self-directed learners, it offers hands-on practice that allows users to learn at their own pace.
-
Advanced Users
Experienced SQL users may find the content too basic and not challenging enough for their skill level.
Product Description
Customer Questions & Answers
-
Question:
Who can benefit from SQL Queries for Mere Mortals?
Answer: Whether you're a DBA, developer, user, or student, you can master SQL with this book. -
Question:
What does the book cover?
Answer: The book covers relational databases, SQL basics, summarizing and grouping data, drawing data from multiple tables, modifying data sets, and advanced queries such as complex NOT and AND conditions, subqueries, and unlinked tables. -
Question:
Is the book software-specific?
Answer: No, the book takes a software-independent approach. Whether you work with Access, SQL Server, Oracle, or any other SQL-based program, this book can save you time and reduce frustration with writing SQL queries. -
Question:
Is this book recommended for beginners?
Answer: Yes, this book is recommended for beginners. -
Question:
Are there solutions provided for the practice questions in the book?
Answer: No, the book does not provide solutions for the practice questions. -
Question:
Is this book suitable for those with minimal SQL experience?
Answer: Yes, this book may be useful for those with minimal SQL experience. -
Question:
Does the book provide clear explanations and logical flow in lessons?
Answer: Yes, the book provides clear explanations and has a logical flow in lessons.
Database Management Systems Editorial Review
SQL Queries For Mere Mortals: A Hands-On Guide To Data Manipulation In SQL is an essential resource for anyone looking to master SQL. With its comprehensive 960 pages, this fourth edition published by Addison-Wesley Professional on April 19, 2018, offers clear guidance and practical examples that make complex topics accessible to beginners. Readers have praised its straightforward approach, often highlighting how the book alleviates the difficulties of learning SQL by providing hands-on exercises. This guide stands out not just for its depth but also its commitment to making data manipulation clear and manageable for mere mortals, ensuring users build a solid foundation in SQL.
Customer Reviews & Ratings
-
5 Star
76%
-
4 Star
14%
-
3 Star
4%
-
2 Star
2%
-
1 Star
4%
Review this product
Share your thoughts with other customers
Pros
- In-depth coverage of SQL concepts
- Hands-on exercises reinforce learning
- Clear and accessible writing style
- Great for beginners and intermediates
- Comprehensive reference material
Cons
- Some users may find it lengthy for quick reference
Platform Trust & Buyer Confidence
“Great products and very good service: very easy and very fast international delivery.”
“Wonderful online shopping experience, smooth transaction from the start. Payment method works conveniently and delivery is unexpectedly fast and reliable. You go the extra mile for service. What makes this even more amazing, you deliver to Namibia. I will remain a happy Ubuy customer and will increase my purchases for sure! Thank you!”
“Very easy to find the products what you need, and so fast delivery, that’s why I highly recommended to others costumers to used ubuy.”
“I received exactly what I ordered I was skeptical about your site because that was my first time to order. But the order came timely and neatly packaged. I was not disappointed. Thank you.”
“Easy to find and order what you want on the website. Delivery is quick to the UK”
Product Price History
Important information
- Limitations : For products shipped internationally, please note that any manufacturer warranty may not be valid; manufacturer service options may not be available; product manuals, instructions, and safety warnings may not be in destination country languages; the products (and accompanying materials) may not be designed in accordance with destination country standards, specifications, and labeling requirements; and the products may not conform to destination country voltage and other electrical standards (requiring use of an adapter or converter if appropriate). The recipient is responsible for assuring that the product can be lawfully imported to the destination country. When ordering from Ubuy or its affiliates, the recipient is the importer of record and must comply with all laws and regulations of the destination country.
- Not all the products listed on Ubuy are for sale, as Ubuy is a global search engine. Products are subject to export/trade regulations.
TWD 2216
Order now and get it around Sunday, October 18
This item is not restrict in my country.(Please click on above link if this item is not restrict in your country, So our team will review and allow.)
QTY:
PCI DSS compliant and ISO 27001:2022 certified, with encrypted payments and full buyer protection on every order.
Features & Benefits
- Easy-to-read and commonsense guide
- Latest SQL standards and database applications
- Reliable queries for virtually any current SQL-based database
- Solving challenging real-world problems
- Advanced techniques for complex calculations and more flexibility
- Practice with downloadable sample databases
Ubuy Assurance
Experience worry-free shopping with 100% original products, PCI DSS-compliant payment security, ISO 27001-certified data protection, the fastest cross-border delivery, free returns *, and secure packaging on every order.



