Hurtig levering
Fremragende Trustpilot
Op til 20% Rabat på nye medlemsordrer
Kurv
SQL Queries for Mere Mortals
Af: John L. Viescas, John Viescas Engelsk Paperback
SPAR
kr 60
SQL Queries for Mere Mortals
Af: John L. Viescas, John Viescas Engelsk Paperback
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!

Eksklusiv medlemspris 356 kr
Medlemspris 362 kr
Eksklusiv medlemspris og medlemspris er kun for medlemmer. Du bliver automatisk medlem når du køber til eksklusiv medlemspris eller medlemspris. Få 7 dages gratis medlemskab (herefter automatisk 89 kr/30 dage). Læs mere om fordelene
Gratis fragt
5 - 7 hverdage
10 kr
Lavt pakkegebyr
Normalpris 416 kr
Fragt: 59 kr
7 - 10 hverdage
20 kr
Pakkegebyr
Spar 60 kr
Se vores konkurrenters priser her
God 15.849 anmeldelser på
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!

Produktdetaljer
Sprog: Engelsk
Sider: 960
ISBN-13: 9780134858333
Indbinding: Paperback
Udgave:
ISBN-10: 0134858336
Udg. Dato: 19 apr 2018
Længde: 54mm
Bredde: 178mm
Højde: 231mm
Oplagsdato: 19 apr 2018
Forfatter(e): John L. Viescas, John Viescas
Forfatter(e) John L. Viescas, John Viescas


Kategori Brandværn og brandsikkerhed


Sprog Engelsk


Indbinding Paperback


Sider 960


Udgave


Længde 54mm


Bredde 178mm


Højde 231mm


Udg. Dato 19 apr 2018


Oplagsdato 19 apr 2018

MEDLEMSFORDELE
GRATIS FRAGT
SPAR OP TIL 90%
Andre har også købt
BOG (HÆFTET)
Eksklusiv medlemspris kr 189

kr 280
Normalpris
kr 198
Medlemspris
SPAR
kr 91
BOG (INDBUNDET)
Eksklusiv medlemspris kr 208

kr 299
Normalpris
kr 217
Medlemspris
SPAR
kr 91
BOG (INDBUNDET)
Eksklusiv medlemspris kr 380

kr 499
Normalpris
kr 392
Medlemspris
SPAR
kr 119
LYDBOG
Eksklusiv medlemspris kr 95

kr 129
Normalpris
kr 98
Medlemspris
SPAR
kr 34
BOG (INDBUNDET)
Eksklusiv medlemspris kr 220

kr 320
Normalpris
kr 230
Medlemspris
SPAR
kr 100
BOG (INDBUNDET)
Eksklusiv medlemspris kr 172

kr 250
Normalpris
kr 180
Medlemspris
SPAR
kr 78
BOG (INDBUNDET)
Eksklusiv medlemspris kr 262

kr 349
Normalpris
kr 271
Medlemspris
SPAR
kr 87
BOG (INDBUNDET)
Eksklusiv medlemspris kr 214

kr 320
Normalpris
kr 225
Medlemspris
SPAR
kr 106
BOG (HÆFTET)
Eksklusiv medlemspris kr 149

kr 249
Normalpris
kr 159
Medlemspris
SPAR
kr 100
BOG (INDBUNDET)
Eksklusiv medlemspris kr 919

kr 1.499
Normalpris
kr 977
Medlemspris
SPAR
kr 580
BOG (HÆFTET)
Eksklusiv medlemspris kr 188

kr 269
Normalpris
kr 196
Medlemspris
SPAR
kr 81
BOG (INDBUNDET)
Eksklusiv medlemspris kr 203

kr 300
Normalpris
kr 213
Medlemspris
SPAR
kr 97
BOG (HARDBACK)
Eksklusiv medlemspris kr 25

kr 227
Normalpris
kr 45
Medlemspris
SPAR
kr 202
BOG (INDBUNDET)
Eksklusiv medlemspris kr 329

kr 499
Normalpris
kr 346
Medlemspris
SPAR
kr 170
BOG (HÆFTET)
Eksklusiv medlemspris kr 199

kr 299
Normalpris
kr 209
Medlemspris
SPAR
kr 100
BOG (INDBUNDET)
Eksklusiv medlemspris kr 183

kr 270
Normalpris
kr 192
Medlemspris
SPAR
kr 87
BOG (HARDBACK)
Eksklusiv medlemspris kr 145

kr 190
Normalpris
kr 150
Medlemspris
SPAR
kr 45
BOG (HÆFTET)
Eksklusiv medlemspris kr 164

kr 199
Normalpris
kr 168
Medlemspris
SPAR
kr 35
BOG (HÆFTET)
Eksklusiv medlemspris kr 199

kr 299
Normalpris
kr 209
Medlemspris
SPAR
kr 100
BOG (INDBUNDET)
Eksklusiv medlemspris kr 214

kr 320
Normalpris
kr 225
Medlemspris
SPAR
kr 106
Vi anbefaler også
BOG (PAPERBACK)
Eksklusiv medlemspris kr 255

kr 360
Normalpris
kr 266
Medlemspris
SPAR
kr 105
BOG (PAPERBACK)
Eksklusiv medlemspris kr 265

kr 337
Normalpris
kr 272
Medlemspris
SPAR
kr 72
BOG (PAPERBACK)
Eksklusiv medlemspris kr 222

kr 349
Normalpris
kr 235
Medlemspris
SPAR
kr 127
BOG (PAPERBACK)
Eksklusiv medlemspris kr 306

kr 326
Normalpris
kr 308
Medlemspris
SPAR
kr 20
BOG (PAPERBACK)
Eksklusiv medlemspris kr 376

kr 416
Normalpris
kr 380
Medlemspris
SPAR
kr 40
BOG (PAPERBACK)
Eksklusiv medlemspris kr 490

kr 563
Normalpris
kr 497
Medlemspris
SPAR
kr 73
BOG (PAPERBACK)
Eksklusiv medlemspris kr 222

kr 349
Normalpris
kr 235
Medlemspris
SPAR
kr 127
BOG (PAPERBACK)
Eksklusiv medlemspris kr 376

kr 416
Normalpris
kr 380
Medlemspris
SPAR
kr 40
BOG (PAPERBACK)
Eksklusiv medlemspris kr 322

kr 478
Normalpris
kr 338
Medlemspris
SPAR
kr 156
BOG (PAPERBACK)
Eksklusiv medlemspris kr 367

kr 404
Normalpris
kr 371
Medlemspris
SPAR
kr 37
BOG (PAPERBACK)
Eksklusiv medlemspris kr 332

kr 360
Normalpris
kr 335
Medlemspris
SPAR
kr 28
BOG (HARDBACK)
Eksklusiv medlemspris kr 236

kr 326
Normalpris
kr 245
Medlemspris
SPAR
kr 90
BOG (PAPERBACK)
Eksklusiv medlemspris kr 308

kr 317
Normalpris
kr 309
Medlemspris
SPAR
kr 9
BOG (PAPERBACK)
Eksklusiv medlemspris kr 376

kr 416
Normalpris
kr 380
Medlemspris
SPAR
kr 40
BOG (PAPERBACK)
Eksklusiv medlemspris kr 315

kr 337
Normalpris
kr 317
Medlemspris
SPAR
kr 22
BOG (PAPERBACK)
Eksklusiv medlemspris kr 357

kr 540
Normalpris
kr 375
Medlemspris
SPAR
kr 183
BOG (PAPERBACK)
Eksklusiv medlemspris kr 428

kr 484
Normalpris
kr 434
Medlemspris
SPAR
kr 56
BOG (PAPERBACK)
Eksklusiv medlemspris kr 367

kr 378
Normalpris
kr 368
Medlemspris
SPAR
kr 11
BOG (PAPERBACK)
Eksklusiv medlemspris kr 397

kr 461
Normalpris
kr 403
Medlemspris
SPAR
kr 64
BOG (PAPERBACK)
Eksklusiv medlemspris kr 297

kr 315
Normalpris
kr 299
Medlemspris
SPAR
kr 18