Description: About this Item The item is a book Paperback The Author Name is John L. Viescas The Title is SQL Queries for Mere Mortals : A Hands-On Guide to Data Manipulation in SQL Condition New Other Comments Pages Count - 960. Category - Computers Product Description - The 1 Easy, Common-Sense Guide to SQL Queries-Updated with More Advanced Techniques and SolutionsForeword by Keith W. Hare, Vice Chair, USA SQL Standards CommitteeSQL 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 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! We Use Stock Images Because we have over 2 million items for sale we have to use stock images, this listing does not include the actual image of the item for sale. The purchase of this specific item is made with the understanding that the image shown in this listing is a stock image and not the actual item for sale. For example: some of our stock images include stickers, labels, price tags, hyper stickers, obi's, promotional messages, signatures and or writing which may not be available in the actual item. When possible we will add details of the items we are selling to help buyers know what is included in the item for sale. The details are provided automatically from our central master database and can sometimes be wrong. Books are released in many editions and variations, such as standard edition, re-issue, not for sale, promotional, special edition, limited edition, and many other editions and versions. The Book you receive could be any of these editions or variations. If you are looking for a specific edition or version please contact us to verify what we are selling. Gift IdeasThis is a great Christmas gift idea. Hours of ServiceWe have many warehouses, some of the warehouses process orders seven days a week, but the Administration Support Staff are located at a head office location, outside of the warehouses, and typically work only Monday to Friday. Location ID 9000z iHaveit SKU ID 167243841
Price: 84.15 USD
Location: US
End Time: 2024-11-21T10:44:14.000Z
Shipping Cost: 0 USD
Product Images
Item Specifics
Restocking Fee: No
Return shipping will be paid by: Buyer
All returns accepted: Returns Accepted
Item must be returned within: 30 Days
Refund will be given as: Money Back
Fiction/Non-Fiction: Non-Fiction
Genre/Subject: Computers
Brand: Pearson Education (US)
Weight: 1.45
Style: NA
Title: SQL Queries for Mere Mortals A Hands-On Guide to Data Manipulat
Release Title: SQL Queries for Mere Mortals A Hands-On Guide to Data Manipulat
Record Grading: New
Sleeve Grading: New
Platform: NA
Size: NA
Film/TV Title: SQL Queries for Mere Mortals A Hands-On Guide to Data Manipula
Colour: NA
Material: NA
Department: NA
Movie/TV Title: SQL Queries for Mere Mortals A Hands-On Guide to Data Manipula
UPC: 9780134858333
EAN: 9780134858333
ISBN: 9780134858333
Main Stone: NA
Metal Purity: NA
Metal: NA
Connectivity: NA
Model: NA
Number of Pages: 960 Pages
Publication Name: Sql Queries for Mere Mortals : a Hands-On Guide to Data Manipulation in Sql
Language: English
Publisher: Addison Wesley Professional
Item Height: 2 in
Publication Year: 2018
Subject: Computer Graphics, Programming Languages / Sql, Databases / General
Item Weight: 53.6 Oz
Type: Textbook
Author: John Viescas
Item Length: 9.1 in
Subject Area: Computers
Item Width: 7 in
Series: For Mere Mortals Ser.
Format: Trade Paperback
