100,000+ Books, Games & Puzzles in-stock ๐Ÿ‡ณ๐Ÿ‡ฟ

Auckland Bookstore open Sunday until 5pm! ๐ŸŽ‰

SQL All-in-One For Dummies

Brief Description
The most thorough SQL reference, now updated for SQL:2023 SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used... Read More
Format: Paperback / softback
$7599
OVERNIGHT NZ-WIDE DELIVERY

Found a better price? Request a price match

Book Hero Magic formatted this description to make it easier to read. While it's new and still learning, it may not be perfect - your feedback is welcome! Description

The most thorough SQL reference, now updated for SQL:2023

SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, thereโ€™s no end in sight to the need for SQL know-how.

You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career.

  • Get 7 mini-books in one, covering basic SQL, database development, and advanced SQL concepts
  • Read clear explanations of SQL code and learn to write complex queries
  • Discover how to apply SQL in real-world situations to gain control over large datasets
  • Enjoy a thorough reference to common tasks and issues in SQL development

This Dummies All-in-One guide is for all SQL usersโ€”from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey.

Book Details

INFORMATION

ISBN: 9781394242290

Publisher: John Wiley & Sons Inc

Format: Paperback / softback

Date Published: 25 April 2024

Country: United States

Imprint: For Dummies

Edition: 4th edition

Audience: General / adult

DIMENSIONS

Spine width: 46.0mm

Width: 188.0mm

Height: 239.0mm

Weight: 1043g

Pages: 800

About the Author

Allen G. Taylor is a 30-year veteran of the computer industry and the author of more than 40 books, including previous editions of SQL For Dummies and SQL All-in-One For Dummies. Richard Blum has more than 30 years of experience in the IT industry as a systems and network administrator. He is author of Linux All-in-One For Dummies 7th Edition, and PHP, MySQL, & JavaScript All-in-One For Dummies.

Also by Allen G. Taylor

View all
  • Crystal Reports 10 For Dummies
    Updated to reflect the latest version of the Crystal Reports reporting tool. Crystal Reports 10 For Dummies explains how to use Crystal Reports to quickly transform almost any data into interactive content. The book features a jump-start chapter on creating a simple report. It covers both basic and advanced reporting features, such as retrieving data from databases; sorting, grouping, and...
    Paperback
    $5199
    Available
    Ships in 3-4 weeks
  • Crystal Reports 2008 For Dummies
    A report is only useful if those who receive it understand what it means. Knowing how to use Crystal Reports gives you the edge in producing reports from your database that really are crystal clear. Crystal Reports 2008 For Dummies is a quick and easy guide to get you going with the latest version of this bestselling report-writing software. In...
    Paperback
    $5699
    Available
    Ships in 3-4 weeks
  • Data Analytics & Visualization All-in-One For Dummies
    Install data analytics into your brain with this comprehensive introduction Data Analytics & Visualization All-in-One For Dummies collects the essential information on mining, organising, and communicating data, all in one place. Clocking in at around 850 pages, this tome of a reference delivers eight books in one, so you can build a solid foundation of knowledge in data wrangling. Data...
    Paperback
    $9499
    Available
    Ships in 3-4 weeks
  • Database Development For Dummies
    Powerful, low-cost database development tools make it possible for virtually anybody to create their own databaseโ€”and this hands-on guide makes it fun and easy. Databases permeate every nook and cranny of our highly connected, information-intensive world, from ATMs to personal finance, online shopping, and networked information management. Databases have become so integral to the business environment that, nowadays, it's next...
    Paperback
    $7999
    Available
    Ships in 3-4 weeks
  • SQL Essentials For Dummies
    A right-to-the-point guide on all the key topics of SQL programming SQL Essentials For Dummies is your quick reference to all the core concepts of SQLโ€”a valuable common standard language used in relational databases. This useful guide is straightforwardโ€”with no excess review, wordy explanations, or fluffโ€”so you get what you need, fast. Great for a brush-up on the basics or...
    Paperback
    $3199
    Available
    Ships in 3-4 weeks
  • SQL For Dummies
    Get ready to make SQL easy! Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to...
    Paperback
    $6699
    Available
    Ships in 3-4 weeks
  • Access 2013 All-in-One For Dummies
    Get started with the new Access 2013 with this impressive all-in-one reference! Microsoft Access allows you to store, organise, view, analyse, and share data; the new release enables you to build even more powerful, custom database solutions that integrate with the web and enterprise data sources. This compilation of nine indispensable minibooks is exactly what you need to get up...
    Paperback
    Sold Out

Also by Richard Blum

View all
  • CompTIA Linux+ Study Guide
    Paperback
    $12399
    Available
    Ships in 3-4 weeks
  • Linux All-In-One For Dummies
    Linux is for everyone! Linux All-in-One For Dummies breaks down the ever-popular operating system to its basics and trains users on the art of Linux. This handy reference covers all the latest updates and operating system features. It presents content on Linux desktops, applications, and more. With eight books in one, youโ€™ll have access to the most comprehensive overview of...
    Paperback
    $7599
    Available
    Ships in 3-4 weeks
  • PHP, MySQL, & JavaScript All-in-One For Dummies
    Explore the engine that drives the internet It takes a powerful suite of technologies to drive the most-visited websites in the world. PHP, MySQL, JavaScript, and other web-building languages serve as the foundation for application development and programming projects at all levels of the web. Dig into this all-in-one book to get a grasp on these in-demand skills and figure...
    Paperback
    $9499
    Available
    Ships in 3-4 weeks
  • PHP, MySQL, & JavaScript All-In-One For Dummies
    Learn the essentials of creating web apps with some of the most popular programming languages. PHP, MySQL, & JavaScript All-in-One For Dummies bundles the essentials of coding in some of the most in-demand web development languages. You'll learn to create your own data-driven web applications and interactive web content. The three powerful languages covered in this book form the backbone...
    Paperback
    $9499
    Available
    Ships in 3-4 weeks
  • SQL Essentials For Dummies
    A right-to-the-point guide on all the key topics of SQL programming SQL Essentials For Dummies is your quick reference to all the core concepts of SQLโ€”a valuable common standard language used in relational databases. This useful guide is straightforwardโ€”with no excess review, wordy explanations, or fluffโ€”so you get what you need, fast. Great for a brush-up on the basics or...
    Paperback
    $3199
    Available
    Ships in 3-4 weeks
  • CompTIA Linux+ Study Guide
    The best-selling, hands-on roadmap to acing the new Linux+ exam In the newly updated Fifth Edition of CompTIA Linux+ Study Guide: Exam XK0-005, IT industry veterans and tech education gurus Richard Blum and Christine Bresnahan deliver a concise and practical blueprint to success on the CompTIA Linux+ exam and in your first role as a Linux network or system administrator....
    Paperback
    $11499
    Available
    Ships in 3-4 weeks
  • Linux Essentials
    Learn Linux, and take your career to the next level! Linux Essentials, 2nd Edition provides a solid foundation of knowledge for anyone considering a career in information technology, for anyone new to the Linux operating system, and for anyone who is preparing to sit for the Linux Essentials Exam. Through this engaging resource, you can access key information in a...
    Paperback
    $7999
    Available
    Ships in 3-4 weeks
  • Linux Command Line and Shell Scripting Bible
    Advance your understanding of the Linux command line with this invaluable resource Linux Command Line and Shell Scripting Bible, 4th Edition, is the newest instalment in the indispensable series known to Linux developers all over the world. Packed with concrete strategies and practical tips, the latest edition includes brand-new content covering: Understanding the Shell Writing Simple Script Utilities Producing Database,...
    Paperback
    $9899
    Available
    Ships in 3-4 weeks
  • LPIC-1 Linux Professional Institute Certification Study Guide
    The bestselling study guide for the popular Linux Professional Institute Certification Level 1 (LPIC-1). The updated fifth edition of LPIC-1: Linux Professional Institute Certification Study Guide is a comprehensive, one-volume resource that covers 100% of all exam objectives. Building on the proven Sybex Study Guide approach, this essential resource offers a comprehensive suite of study and learning tools such as...
    Paperback
    $11999
    Available
    Ships in 3-4 weeks
  • LPIC-2: Linux Professional Institute Certification Study Guide
    Full coverage of the latest LPI-level 2 exams, with bonus online test bank LPIC-2: Linux Professional Institute Certification Study Guide is the one-stop preparation resource for the Linux Professional Institute's Advanced Level certification exam. With 100 percent coverage of all exam objectives, this book provides clear and concise coverage of the Linux administration topics you'll need to know for exams...
    Paperback
    $14699
    Available
    Ships in 3-4 weeks
  • LPI Linux Essentials Study Guide
    Provides a solid foundation for those considering a career in ITโ€”covers the objectives of the new Linux Essentials Exam 010-160 v1.6 Linux is a secure, reliable, open source alternative to costly operating systems such as Microsoft Windows. As large organisations worldwide continue to add Linux servers, the need for IT professionals skilled in Linux continues to grow. The LPI Linux...
    Paperback
    $9499
    Available
    Ships in 3-4 weeks
  • Linux Command Line and Shell Scripting Bible
    The latest update to the gold standard in Linux shell scripting guides In the newly revised fifth edition of Linux Command Line and Shell Scripting Bible, experienced system and network administrator Richard Blum delivers an up-to-date and authoritative discussion of the fundamentals of shell scripting in Linux. The book also covers advanced topics, working examples, and real-world applications that equip...
    Paperback
    $11499
    Available
    Ships in 3-4 weeks

More from Computing & Technology

View all
  • Digital Minimalism
    Digital Minimalism by Cal Newport presents a revolutionary strategy for optimising your interaction with digital technology in a way that fosters productivity, focus, happiness, and creativity. Most of us recognise that our reliance on texting, Instagram, Facebook, and Twitter is not due to sheer lack of intelligence or depth, but because these platforms truly offer significant value in the form...
    Paperback
    $2400
    Elsewhere:
    $2600
    In Stock
    Ships tomorrow
  • Careless People
    Shocking and darkly funny, Careless People gives you a front-row seat to the decisions that are shaping our world and the people who make them. Welcome to Facebook. Sarah Wynn-Williams, a young diplomat from New Zealand, pitched for her dream job. She saw Facebook's potential and knew it could change the world for the better. But, when she got there...
    Paperback
    $2800
    In Stock
    Ships tomorrow
  • New Release
    Empire of AI
    An eye-opening account of the tech arms race shaping our planet, from an award-winning journalist and AI insider to the world of Sam Altman and OpenAI. When longtime AI expert and journalist Karen Hao first began covering OpenAI in 2019, she thought they were the good guys. Founded as a nonprofit with safety enshrined as its core mission, it was...
    Paperback
    $2899
    Elsewhere:
    $3700
    (1)
    In Stock
    Ships tomorrow
  • Open to Work
    โ€˜Open To Work helps you stop fearing the future and start shaping it with purpose.โ€™ Jay Shettyโ€˜An instantly useful guide to futureproofing your career.โ€™ Adam Grantโ€˜Open to Work lays out a smart and clear path to the future of workโ€™ Brenรฉ Brown In a world where AI is transforming work at a rapid pace, Open to Work is your essential...
    Paperback
    $2999
    Elsewhere:
    $3799
    In Stock
    Ships tomorrow
  • If Anyone Builds It, Everyone Dies
    The founder of the field of AI risk explains why superintelligent AI is a global suicide bomb and we must halt development immediately. AI is the greatest threat to our existence that we have ever faced. The technology may be complex but the facts are simple. We are currently on a path to build superintelligent AI. When we do, it...
    Paperback
    $3200
    Elsewhere:
    $4000
    In Stock
    Ships tomorrow
  • The Amazing Generation
    A children's version of the global bestseller The Anxious Generation How can we live a happy and exciting life without a smartphone? The Anxious Generation started a world-changing conversation about the effects of smartphones and social media on young people. Now bestselling authors Jonathan Haidt and Catherine Price have teamed up to talk directly to those young people about how...
    Paperback
    $2500
    Elsewhere:
    $3000
    In Stock
    Ships tomorrow
  • The Infinity Machine
    A revelatory portrait of the visionary behind Google DeepMind, the race to control the future - and what it means to win. Even in a tech world crowded with visionary leaders, Demis Hassabis is recognised as a special case. Born to working-class, immigrant parents in North London, a chess prodigy by five and wizard coder in his teens, he turned...
    Paperback
    $3499
    Elsewhere:
    $4500
    In Stock
    Ships tomorrow
  • Co-Intelligence
    From Wharton professor and author of the One Useful Thing Substack, comes an urgent and definitive playbook for working, learning and living in the new age of AI. For fans of Kevin Kelly, Ray Kurzweil, Cal Newport, and Martin Ford. A New York Times Bestseller Co-Intelligence is the very best book I know about the ins, outs, and ethics of...
    Paperback
    $3400
    Elsewhere:
    $4000
    In Stock
    Ships tomorrow
  • The Bullet Journal Method
    The Bullet Journal Method by Ryder Carroll is an indispensable guide to gaining control over your chaotic life using the power of a simple pen and notebook. Whether you're a seasoned planner or a beginner, this book lays out a revolutionary system that provides structure, clarity, and purpose to your everyday activities. It's not just a method of organising your...
    Paperback
    $2400
    Elsewhere:
    $2799
    In Stock
    Ships tomorrow
  • Careless People
    Shocking and darkly funny, Careless People gives you a front-row seat to the decisions that are shaping our world and the people who make them. Welcome to Facebook. Sarah Wynn-Williams, a young diplomat from New Zealand, pitched for her dream job. She saw Facebook's potential and knew it could change the world for the better. But, when she got there...
    Paperback
    $3200
    Elsewhere:
    $3999
    (4)
    In Stock
    Ships tomorrow
  • Little Book of Data
    Data is not about number crunching. Itโ€™s about ideas. And when used properly (read: ethically), it is the problem solver of our time. Yet many savvy people seem to be in data denial: they donโ€™t think they need to understand data, or itโ€™s too complicated, or worse, using it is somehow unethical. As data and AI (just an accelerated way...
    Paperback
    $3400
    Elsewhere:
    $3799
    In Stock
    Ships tomorrow
  • Donโ€™t Burn Anyone at the Stake Today
    An electrifying, thought-provoking exploration of how the digital era is reshaping our world, by bestselling, Women's Prize-winning writer Naomi Alderman. What's the most useful thing you could know about your own life? In this era-defining book, developed from her groundbreaking Radio 4 essay series, Naomi Alderman turns her boundless curiosity and incisive thinking to a question that affects us allโ€”how...
    Hardback
    $3500
    Elsewhere:
    $4500
    (1)
    In Stock
    Ships tomorrow

Why buy from us?

Book Hero is not a chain store or big box retailer. We're an independent 100% NZ-owned business on a mission to help more Kiwis rediscover a love of books and reading!

Service & Delivery

Service & Delivery

Our warehouse in Auckland holds over 80,000 books, toys, board games and puzzles in-stock so you're not waiting for your order to arrive from overseas.

Auckland Bookstore

Auckland Bookstore

We're primarily an online store, but for your convenience you can pick up your order for free from our bookstore, which is right next door to our warehouse in Hobsonville.

Our Gifting Service

Our Gifting Service

Books make wonderful thoughtful gifts and we're here to help with gift-wrapping and cards. We can even send your gift directly to your loved one.