- Домашняя страница /
- Книги /
- Компьютеры и технологии /
- 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
AZN 110
Price Details
Excluding Shipping & Custom charges ( Shipping and custom charges will be calculated on checkout )
*All items will import from США
19%
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.
-
Software Developers
Developers may find the content basic, lacking the depth needed for integration or advanced SQL programming.
-
Database Administrators
DBAs may not find it relevant, as it focuses more on query writing than on database management or architecture.
ОПИСАНИЕ ТОВАРА
Вопросы и ответы клиентов
-
вопрос:
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
Customer Reviews & Ratings
-
5 звезда
76%
-
4 звезда
12%
-
3 звезда
5%
-
2 звезда
2%
-
1 звезда
5%
Оцените этот товар
Поделитесь своими впечатлениями
Platform Trust & Buyer Confidence
“The product received very good packaging & safe…Thank You”
“Accurate delivery timing given”
“Not madly expensive like I thought, and much quicker than promised.”
“Never dealt with Ubuy before, but everything worked out great. Seamless cross border purchasing and shipping. Thanks!”
“The process was smooth, with clear communication and timelines. This was my 1st purchase and I am really impressed. I will definitely be coming back.”
Product Price History
Важная информация
- Ограничения: обратите внимание, что для товаров, поставляемых за границу, гарантия производителя может быть недействительной; обслуживание от производителя может быть недоступно; руководства по эксплуатации, а также инструкции и предупреждения о безопасности могут быть не на языках страны назначения; товары (и сопутствующие материалы) могут не быть разработаны в соответствии со стандартами, спецификациями и требованиями к маркировке страны назначения; товары также могут не соответствовать напряжению в стране назначения и другим электрическим стандартам (при необходимости требуется использование адаптера или преобразователя). Получатель несет ответственность за обеспечение законного ввоза товара в страну назначения. При заказе через Ubuy или его аффилированных лиц получатель является зарегистрированным импортером и должен соблюдать все законы и правила страны назначения.
- Не все товары на Ubuy выставлены на продажу, поскольку Ubuy — это глобальная поисковая система. На товары распространяются законы в области экспорта и торговли.
AZN 110
Закажите сейчас и получите товар приблизительно Вторник, Июль 21
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.



