BOOKZONE
SQL Queries for Mere Mortals, 3/E (Paperback)
Paperback
by John L. Viescas
SKU:9789332555341
Bulk Discount Get Exta 5% upto 10%
Share
SQL Queries for Mere Mortals is the easiest, most practical guide to writing modern SQL queries. Now extensively updated to cover new database platforms and include more advanced techniques, it guides the reader step-by-step through creating and modifying queries for virtually any SQL-based database. Michael J. Hernandez and John L. Viescas demystify all facets of query writing with SQL Features • SQL queries explained in plain English, with plenty of examples using the latest database products and SQL standards • Covers everything needed to create efficient queries, work with multiple tables, summarize and group data, modify datasets, and more
• Includes three new chapters of advanced techniques, covering complex Not/And problems, unlinked tables, and problem-solving with CASE and driver
tables Content
Chapter 1 What Is Relational
Chapter 2 Ensuring Your Database Structure Is Sound
Chapter 3 A Concise History of SQL
Chapter 4 Creating a Simple Query
Chapter 5 Getting More Than Simple Columns
Chapter 6 Filtering Your Data
Chapter 7 Thinking in Sets
Chapter 8 INNER JOINs
Chapter 9 OUTER JOINs
Chapter 10 UNIONs
Chapter 11 Subqueries
Chapter 12 Simple Totals
Chapter 13 Grouping Data
Chapter 14 Filtering Grouped Data
Chapter 15 Updating Sets of Data
Chapter 16 Inserting Sets of Data
Chapter 17 Deleting Sets of Data
Chapter 18 "NOT" and "AND" Problems
Chapter 19 Condition Testing