- Home Page /
- Books /
- Computing & Internet /
- Databases /
- Data Storage & Management /
- Database Management Systems /
- SQL Queries for Mere Mortals: A Hands-On Guid...
Item #:
87257480
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
85% of respondents would recommend this to a friend
Item #:
87257480
THB 2298
Price Details
Excluding Shipping & Custom charges ( Shipping and custom charges will be calculated on checkout )
*All items will import from UK
0 ratings
Write a review
In stock
Imported from UK store
QTY:
Only 12 items left in stock.
Order now and get it around Sunday, October 18
Secured transaction
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.
Our Top Logistics Partners
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
Hands-On Approach
Provides practical exercises that help users gain real-world experience in SQL data manipulation, ensuring that readers can apply concepts directly to their projects.
Illustrated Format
Utilizes visual aids and illustrations throughout the guide to enhance understanding, making complex SQL concepts more accessible for beginners.
Beginner-Friendly
Tailored for those new to SQL, this book simplifies learning with clear explanations and examples, effectively addressing common user challenges in data manipulation.
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
Have any Query? Chat with us
Customer Questions & Answers
-
Question:
How to Shop SQL Queries for Mere Mortals: A Hands-On Guide to Online From Ubuy?
Answer: It’s easy to shop SQL Queries for Mere Mortals: A Hands-On Guide to online from Ubuy. You just have to search for the product, choose your shipping method while checking out and get it delivered to your location. -
Question:
Is SQL Queries for Mere Mortals: A Hands-On Guide to Available to Shop Online in Thailand?
Answer: Yes, at Ubuy Thailand this product is available for you to shop at a reasonable price. The SQL Queries for Mere Mortals: A Hands-On Guide to is not available locally but you can trust us with our express shipping services. -
Question:
How Long Does It Take to Get Product After Placing the Order?
Answer: The delivery time of your ordered product varies as per what you've ordered and the shipping method that you've chosen. The estimated delivery time is mentioned during the checkout process, so be carefree while shopping.
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
302 customers 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
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.
THB 2298
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:
Only 12 items left in stock.
Secured transaction
PCI DSS compliant and ISO 27001:2022 certified, with encrypted payments and full buyer protection on every order.
Our Top Logistics Partners
Fastest cross-border delivery
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.