- Page d'accueil /
- Livres /
- 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% des répondants recommanderaient ceci à un ami
€ 59
Détails du prix
Hors frais de livraison et de douane ( Les frais de livraison et de douane seront calculés lors du paiement )
*Tous les articles seront importés depuis Royaume-Uni
17%
QTY:
Ubuy s'engage à protéger votre sécurité et votre confidentialité. Notre système avancé de sécurité des paiements garantit la confidentialité en chiffrant vos informations lors de la transmission grâce aux protocoles AES (Advanced Encryption Standards) et SSL (Secure Socket Layer). Vos coordonnées de paiement sont 100 % sécurisées car nous ne partageons pas vos informations de paiement avec des vendeurs tiers.
SQL Queries for Mere Mortals is the #1 easy-to-read, commonsense guide to SQL, packed with ready-to-use examples
Livraison
rapide
Retour
gratuit*
Emballage sécurisé
Produits 100 % originaux
Conformité PCI DSS
Certifié ISO 27001
Ce qui se démarque
Détails du produit
- 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 |
À qui est-ce destiné ?
-
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.
DESCRIPTION DU PRODUIT
Questions et réponses des clients
-
question:
Who can benefit from SQL Queries for Mere Mortals?
répondre: Whether you're a DBA, developer, user, or student, you can master SQL with this book. -
question:
What does the book cover?
répondre: 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?
répondre: 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?
répondre: Yes, this book is recommended for beginners. -
question:
Are there solutions provided for the practice questions in the book?
répondre: No, the book does not provide solutions for the practice questions. -
question:
Is this book suitable for those with minimal SQL experience?
répondre: Yes, this book may be useful for those with minimal SQL experience. -
question:
Does the book provide clear explanations and logical flow in lessons?
répondre: 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.
Avis et évaluations clients
-
5 étoile
76%
-
4 étoile
14%
-
3 étoile
4%
-
2 étoile
2%
-
1 étoile
4%
Donnez votre avis sur ce produit
Partagez votre avis avec d'autres clients
Avantages
- In-depth coverage of SQL concepts
- Hands-on exercises reinforce learning
- Clear and accessible writing style
- Great for beginners and intermediates
- Comprehensive reference material
Les inconvénients
- Some users may find it lengthy for quick reference
CONFIANCE EN LA PLATEFORME & PROTECTION DE L'ACHETEUR
“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”
Historique des prix du produit
Informations importantes
- Limitations : Pour les produits expédiés à l'international, veuillez noter que toute garantie du fabricant peut ne pas être valide ; les options de service du fabricant peuvent ne pas être disponibles ; les manuels, instructions et avertissements de sécurité des produits peuvent ne pas être dans les langues du pays de destination ; les produits (et les matériaux qui les accompagnent) peuvent ne pas être conçus conformément aux normes, spécifications et exigences d'étiquetage du pays de destination ; et les produits peuvent ne pas être conformes à la tension et aux autres normes électriques du pays de destination (nécessitant l'utilisation d'un adaptateur ou d'un convertisseur le cas échéant). Il incombe au destinataire de s'assurer que le produit peut être importé légalement dans le pays de destination. En cas de commande auprès d'Ubuy ou de ses filiales, le destinataire est l'importateur officiel et doit se conformer à toutes les lois et réglementations du pays de destination.
- Tous les produits listés sur Ubuy ne sont pas à vendre, Ubuy étant un moteur de recherche mondial. Les produits sont soumis aux réglementations en matière d'exportation et de commerce.
€ 59
Commandez maintenant et recevez votre commande aux alentours du Sunday, Octobre 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:
Conforme PCI DSS et certifié ISO 27001:2022, avec des paiements chiffrés et une protection complète de l'acheteur pour chaque commande.
Caractéristiques et avantages
- 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
Assurance Ubuy
Profitez d'une expérience d'achat sereine avec des produits 100 % originaux, une sécurité de paiement conforme PCI DSS, une protection des données certifiée ISO 27001, la livraison transfrontalière la plus rapide, les retours gratuits* et un emballage sécurisé pour chaque commande.



