- Əsas Səhifə /
- Kitablar /
- Kompüterlər və Texnologiya /
- 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 ABŞ
19%
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
Məhsul təfərrüatları
- 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.
MƏHSUL TƏSVİRİ
Müştəri Sualları və Cavabları
-
Sual:
Who can benefit from SQL Queries for Mere Mortals?
Cavab: Whether you're a DBA, developer, user, or student, you can master SQL with this book. -
Sual:
What does the book cover?
Cavab: 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. -
Sual:
Is the book software-specific?
Cavab: 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. -
Sual:
Is this book recommended for beginners?
Cavab: Yes, this book is recommended for beginners. -
Sual:
Are there solutions provided for the practice questions in the book?
Cavab: No, the book does not provide solutions for the practice questions. -
Sual:
Is this book suitable for those with minimal SQL experience?
Cavab: Yes, this book may be useful for those with minimal SQL experience. -
Sual:
Does the book provide clear explanations and logical flow in lessons?
Cavab: 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 ulduz
76%
-
4 ulduz
12%
-
3 ulduz
5%
-
2 ulduz
2%
-
1 ulduz
5%
Bu məhsulu nəzərdən keçirin
Fikirlərinizi digər müştərilərlə bölüşün
Pros
- Comprehensive book with ample examples
- Clear explanations and logical flow of lessons
- Provides both practical and theoretical knowledge
- Excellent diagrams and table designs
Eksiler
- Presence of strikethrough lines
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
Vacib məlumat
- Məhdudiyyətlər: Zəhmət olmasa unutmayın ki, beynəlxalq göndərilən məhsullar üçün, hər hansı bir istehsalçı zəmanəti keçərli olmaya bilər; istehsalçının xidmət seçimləri mövcud olmaya bilər; məhsul təlimatları, göstərişləri və təhlükəsizlik xəbərdarlıqları təyinat ölkəsinin dillərində olmaya bilər; məhsullar (və müşayiət olunan materiallar) təyinat ölkəsinin standartlarına, spesifikasiyalarına və etiketləmə tələblərinə uyğun olaraq dizayn edilməmiş ola bilər; və məhsullar təyinat ölkəsinin gərginliyinə və digər elektrik standartlarına uyğun olmaya bilər (lazım olduqda adapter və ya konvertordan istifadə tələb olunur). Alıcı məhsulun təyinat ölkəsinə qanuni olaraq idxal oluna biləcəyini təmin etmək üçün cavabdehdir. Ubuy və ya onun filiallarından sifariş verərkən, alıcı qeydin idxalçısıdır və təyinat ölkəsinin bütün qanun və qaydalarına riayət etməlidir.
- Ubuy qlobal bir axtarış motoru olduğu üçün Ubuy-də sadalanan bütün məhsullar satışda deyil.Məhsullar ixrac/ticarət qaydalarına tabedir.
AZN 110
Elə indi sifariş verin və əldə edin Çərşənbə axşamı, İyul 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.
Xüsusiyyətlər və Üstünlüklər
- 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.



