SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL - Image 1

£41.78

PEARSON EDUCATION SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

Name: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
Brand: PEARSON EDUCATION
Price: 41.78 GBP
Availability: InStock

Database Management Systems

This is the most expensive it has ever been. Walk away.

£42 today · previous high £42 · all-time low £32

NEW HERE?

Amazon shows you one price. We show you all of them.

Tosheroon watches Amazon prices so you don't have to. Every product on Amazon has a price history — we make it visible. Set the price you'd actually pay, and we'll email you the second it gets there. No app, no account, one email.

WHAT'S ON THIS PAGE

↓ Price chart
when this has been cheap or pricey

↓ Forecast
where the price is heading next

↓ Statistics
all-time high & low, recent range

↑ Price alert
name your number, we'll email you

Price History & Forecast

Grey patches = out of stock. Cheaper = lower on the chart. Hover for exact prices.

Last 83 days · 83 data points (no recent data)

Historical

Generating forecast…

Price Distribution

Price distribution over 83 days • 6 price levels

Days at Price

Current Price

Price Analysis

Most common price: £35 (43 days, 51.8%)

Price range: £32 - £42

Price levels: 6 different prices over 83 days

Description

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 sound SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE Summarizing and grouping data with GROUP BY and HAVING clauses Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more NEW! Using advanced GROUP BY keywords to create subtotals, roll-ups, and more NEW! Applying window functions to answer more sophisticated questions, and gain deeper insight into your data Software-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!

Key Features

New Store Stock

Product Specifications

Brand: PEARSON EDUCATION
Format: paperback
ASIN: 0134858336
Category: Books > Subjects > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
Domain: Amazon UK
Release Date: 19 April 2018
Listed Since: 25 August 2017

Barcode

No barcode data available

PEARSON EDUCATION SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

This is the most expensive it has ever been. Walk away.

Price History & Forecast

Price Distribution

Price Analysis

Description

Key Features

Product Specifications

Barcode

Similar Products You Might Like

Learn SQL in a Month of Lunches

Practical Mdx Queries: For Microsoft Sql Server Analysis Services 2008 (DATABASE & ERP - OMG)

Oracle Database 11g Sql (Oracle Press)

Windows Azure SQL Database Programming & Design

SQL Server Query Tuning and Optimization: Optimize Microsoft SQL Server 2022 queries and applications

Microsoft SQL A Complete Guide - 2021 Edition

Pro T-SQL Programmer's Guide

Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition (DATABASE & ERP - OMG)

PROC SQL: Beyond the Basics Using SAS, Third Edition

PostgreSQL DA Handbook: PostgreSQL DATA ANALYST Handbook - Unlocking Insights with Advanced Database Techniques 110 Best Practices (GitHub link ... Data, with Unstructured Data, Advanced Skills

PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries

jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions

Multi Pack:Database Systems:A Practical Approach to Design, Implementation and Management with Learning SQL:A Step-By-Step Guide Using Oracle

100 SQL Server Mistakes and How to Avoid Them

Microsoft SQL Server Master Data Services A Complete Guide

Introducing Microsoft Access Using Macro Programming Techniques: An Introduction to Desktop Database Development by Example

Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel (Business Skills)

XQuery 2e: Search Across a Variety of XML Data

Modern Data Access with Entity Framework Core: Database Programming Techniques for .NET, .NET Core, UWP, and Xamarin with C#

Relational Databases:Design,Implementation,and Application Development

Graph Databases in Action

Practical Database Programming with Visual Basic.NET

Power Query for Power BI and Excel

A Complete Visual Basic Database Training Course