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 347 kr
Medlemspris 353 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 407 kr
Fragt: 59 kr
7 - 10 hverdage
20 kr
Pakkegebyr
Spar 60 kr
Se vores konkurrenters priser her
God 15.809 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

MEDLEMSFORDELE
GRATIS FRAGT
SPAR OP TIL 90%
Andre har også købt
BOG (INDBUNDET)
Eksklusiv medlemspris kr 380

kr 499
Normalpris
kr 392
Medlemspris
SPAR
kr 119
BOG (INDBUNDET)
Eksklusiv medlemspris kr 170

kr 270
Normalpris
kr 180
Medlemspris
SPAR
kr 100
BOG (INDBUNDET)
Eksklusiv medlemspris kr 859

kr 1.499
Normalpris
kr 923
Medlemspris
SPAR
kr 640
BOG (INDBUNDET)
Eksklusiv medlemspris kr 240

kr 349
Normalpris
kr 251
Medlemspris
SPAR
kr 109
BOG (INDBUNDET)
Eksklusiv medlemspris kr 118

kr 149
Normalpris
kr 121
Medlemspris
SPAR
kr 31
BOG (INDBUNDET)
Eksklusiv medlemspris kr 203

kr 300
Normalpris
kr 213
Medlemspris
SPAR
kr 97
BOG (INDBUNDET)
Eksklusiv medlemspris kr 262

kr 349
Normalpris
kr 271
Medlemspris
SPAR
kr 87
BOG (HARDBACK)
Eksklusiv medlemspris kr 25

kr 227
Normalpris
kr 45
Medlemspris
SPAR
kr 202
BOG (HÆFTET)
Eksklusiv medlemspris kr 275

kr 320
Normalpris
kr 280
Medlemspris
SPAR
kr 45
BOG (HÆFTET)
Eksklusiv medlemspris kr 207

kr 269
Normalpris
kr 213
Medlemspris
SPAR
kr 62
BOG (INDBUNDET)
Eksklusiv medlemspris kr 216

kr 279
Normalpris
kr 222
Medlemspris
SPAR
kr 63
BOG (INDBUNDET)
Eksklusiv medlemspris kr 329

kr 499
Normalpris
kr 346
Medlemspris
SPAR
kr 170
BOG (HARDBACK)
Eksklusiv medlemspris kr 278

kr 325
Normalpris
kr 283
Medlemspris
SPAR
kr 47
BOG (HÆFTET)
Eksklusiv medlemspris kr 199

kr 269
Normalpris
kr 206
Medlemspris
SPAR
kr 70
BOG (INDBUNDET)
Eksklusiv medlemspris kr 214

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

kr 199
Normalpris
kr 159
Medlemspris
SPAR
kr 45
BOG (INDBUNDET)
Eksklusiv medlemspris kr 182

kr 249
Normalpris
kr 189
Medlemspris
SPAR
kr 67
BOG (INDBUNDET)
Eksklusiv medlemspris kr 194

kr 270
Normalpris
kr 202
Medlemspris
SPAR
kr 76
BOG (PAPERBACK)
Eksklusiv medlemspris kr 111

kr 150
Normalpris
kr 115
Medlemspris
SPAR
kr 39
BOG (HÆFTET)
Eksklusiv medlemspris kr 211

kr 299
Normalpris
kr 220
Medlemspris
SPAR
kr 88
Vi anbefaler også
BOG (PAPERBACK)
Eksklusiv medlemspris kr 490

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

kr 326
Normalpris
kr 305
Medlemspris
SPAR
kr 23
BOG (PAPERBACK)
Eksklusiv medlemspris kr 259

kr 330
Normalpris
kr 266
Medlemspris
SPAR
kr 71
BOG (PAPERBACK)
Eksklusiv medlemspris kr 242

kr 326
Normalpris
kr 250
Medlemspris
SPAR
kr 84
BOG (PAPERBACK)
Eksklusiv medlemspris kr 296

kr 305
Normalpris
kr 297
Medlemspris
SPAR
kr 9
BOG (PAPERBACK)
Eksklusiv medlemspris kr 253

kr 327
Normalpris
kr 260
Medlemspris
SPAR
kr 74
BOG (PAPERBACK)
Eksklusiv medlemspris kr 358

kr 529
Normalpris
kr 375
Medlemspris
SPAR
kr 171
BOG (PAPERBACK)
Eksklusiv medlemspris kr 249

kr 341
Normalpris
kr 258
Medlemspris
SPAR
kr 92
BOG (PAPERBACK)
Eksklusiv medlemspris kr 330

kr 360
Normalpris
kr 333
Medlemspris
SPAR
kr 30
BOG (PAPERBACK)
Eksklusiv medlemspris kr 295

kr 315
Normalpris
kr 297
Medlemspris
SPAR
kr 20
BOG (PAPERBACK)
Eksklusiv medlemspris kr 312

kr 337
Normalpris
kr 315
Medlemspris
SPAR
kr 25
BOG (PAPERBACK)
Eksklusiv medlemspris kr 280

kr 307
Normalpris
kr 283
Medlemspris
SPAR
kr 27
BOG (PAPERBACK)
Eksklusiv medlemspris kr 373

kr 416
Normalpris
kr 377
Medlemspris
SPAR
kr 43
BOG (PAPERBACK)
Eksklusiv medlemspris kr 216

kr 341
Normalpris
kr 229
Medlemspris
SPAR
kr 125
BOG (PAPERBACK)
Eksklusiv medlemspris kr 360

kr 486
Normalpris
kr 373
Medlemspris
SPAR
kr 126
BOG (PAPERBACK)
Eksklusiv medlemspris kr 358

kr 397
Normalpris
kr 362
Medlemspris
SPAR
kr 39
BOG (PAPERBACK)
Eksklusiv medlemspris kr 365

kr 376
Normalpris
kr 366
Medlemspris
SPAR
kr 11
BOG (PAPERBACK)
Eksklusiv medlemspris kr 373

kr 416
Normalpris
kr 377
Medlemspris
SPAR
kr 43
BOG (PAPERBACK)
Eksklusiv medlemspris kr 268

kr 281
Normalpris
kr 269
Medlemspris
SPAR
kr 13
BOG (PAPERBACK)
Eksklusiv medlemspris kr 185

kr 231
Normalpris
kr 190
Medlemspris
SPAR
kr 46