- Домашняя страница /
- Книги /
- Компьютеры и технологии /
- Programming /
- Software Design, Testing & Engineering /
- Structured Design /
- SQL Queries for Mere Mortals: A Hands-On Guid...
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
KZT 34834
Price Details
Excluding Shipping & Custom charges ( Shipping and custom charges will be calculated on checkout )
*All items will import from США
18%
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
Информация о продукте
- 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 | February 9, 2018 |
| Edition | 4th |
| Language | English |
| Print length | 960 pages |
| ISBN-10 | 0134858336 |
| ISBN-13 | 978-0134858333 |
| Item Weight | 2.31 pounds (1.05 kg) |
| Dimensions | 2.1 x 7 x 9.1 inches (5.3 x 17.8 x 23.1 cm) |
| Part of series | For Mere Mortals |
Who Should Buy?
-
Beginners in SQL
Ideal for those new to SQL, providing an approachable introduction to data manipulation and query writing.
-
Data Analysts
Perfect for data analysts seeking to enhance their SQL skills for effective data querying and reporting.
-
Self-learners
Great resource for self-learners wanting practical exercises and hands-on experience with SQL queries.
-
Advanced Users
Not suitable for experienced SQL practitioners looking for advanced techniques or complex query optimization.
ОПИСАНИЕ ТОВАРА
Вопросы и ответы клиентов
-
вопрос:
Who can benefit from SQL Queries for Mere Mortals?
отвечать: Whether you're a DBA, developer, user, or student, you can master SQL with this book. -
вопрос:
What does the book cover?
отвечать: 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. -
вопрос:
Is the book software-specific?
отвечать: 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. -
вопрос:
Is this book recommended for beginners?
отвечать: Yes, this book is recommended for beginners. -
вопрос:
Are there solutions provided for the practice questions in the book?
отвечать: No, the book does not provide solutions for the practice questions. -
вопрос:
Is this book suitable for those with minimal SQL experience?
отвечать: Yes, this book may be useful for those with minimal SQL experience. -
вопрос:
Does the book provide clear explanations and logical flow in lessons?
отвечать: Yes, the book provides clear explanations and has a logical flow in lessons.
Structured Design Editorial Review
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL 4th Edition is a comprehensive book that is well thought out and provides ample examples for beginners. The author's explanations are clear and the book flows logically from one lesson to another. It not only teaches practical knowledge but also provides theoretical knowledge. The diagrams and table designs in the book are excellent. However, some readers found the book challenging to read due to the presence of strikethrough lines and ambiguous practice questions. There were also a few mistakes in the examples. The lack of solution for the practice questions in the book was a downside for some readers. Overall, this book is recommended for beginners or those with minimal SQL experience.
Customer Reviews & Ratings
-
5 звезда
76%
-
4 звезда
12%
-
3 звезда
5%
-
2 звезда
2%
-
1 звезда
5%
Оцените этот товар
Поделитесь своими впечатлениями
Плюсы
- Comprehensive book with ample examples
- Clear explanations and logical flow of lessons
- Provides both practical and theoretical knowledge
- Excellent diagrams and table designs
Минусы
- Presence of strikethrough lines
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
Важная информация
- Ограничения: обратите внимание, что для товаров, поставляемых за границу, гарантия производителя может быть недействительной; обслуживание от производителя может быть недоступно; руководства по эксплуатации, а также инструкции и предупреждения о безопасности могут быть не на языках страны назначения; товары (и сопутствующие материалы) могут не быть разработаны в соответствии со стандартами, спецификациями и требованиями к маркировке страны назначения; товары также могут не соответствовать напряжению в стране назначения и другим электрическим стандартам (при необходимости требуется использование адаптера или преобразователя). Получатель несет ответственность за обеспечение законного ввоза товара в страну назначения. При заказе через Ubuy или его аффилированных лиц получатель является зарегистрированным импортером и должен соблюдать все законы и правила страны назначения.
- Не все товары на Ubuy выставлены на продажу, поскольку Ubuy — это глобальная поисковая система. На товары распространяются законы в области экспорта и торговли.
KZT 34834
Закажите сейчас и получите товар приблизительно Суббота, Октябрь 03
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.
Особенности и преимущества
- 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.



