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 119
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!

Kampagne pris Velkomst pris 347 kr
Medlemspris 359 kr
Kampagnepris og medlemspris er kun for medlemmer. Du bliver automatisk medlem når du køber til medlems- og kampagnepris. 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 466 kr
Fragt: 59 kr
7 - 10 hverdage
20 kr
Pakkegebyr
Spar 119 kr
Velkommen 10%
God 15.777 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)
Kampagne pris kr 262

kr 349
Normalpris
kr 271
Medlemspris
SPAR
kr 87
BOG (INDBUNDET)
Kampagne pris kr 199

kr 320
Normalpris
kr 211
Medlemspris
SPAR
kr 121
BOG (INDBUNDET)
Kampagne pris kr 380

kr 499
Normalpris
kr 392
Medlemspris
SPAR
kr 119
BOG (INDBUNDET)
Kampagne pris kr 919

kr 1.499
Normalpris
kr 977
Medlemspris
SPAR
kr 580
BOG (INDBUNDET)
Kampagne pris kr 148

kr 199
Normalpris
kr 153
Medlemspris
SPAR
kr 51
BOG (INDBUNDET)
Kampagne pris kr 182

kr 250
Normalpris
kr 189
Medlemspris
SPAR
kr 68
BOG (INDBUNDET)
Kampagne pris kr 29

kr 134
Normalpris
kr 40
Medlemspris
SPAR
kr 105
BOG (HÆFTET)
Kampagne pris kr 188

kr 269
Normalpris
kr 196
Medlemspris
SPAR
kr 81
BOG (INDBUNDET)
Kampagne pris kr 119

kr 120
Normalpris
kr 119
Medlemspris
SPAR
kr 1
BOG (INDBUNDET)
Kampagne pris kr 191

kr 300
Normalpris
kr 202
Medlemspris
SPAR
kr 109
BOG (HÆFTET)
Kampagne pris kr 27

kr 227
Normalpris
kr 47
Medlemspris
SPAR
kr 200
BOG (INDBUNDET)
Kampagne pris kr 199

kr 300
Normalpris
kr 209
Medlemspris
SPAR
kr 101
BOG (INDBUNDET)
Kampagne pris kr 203

kr 300
Normalpris
kr 213
Medlemspris
SPAR
kr 97
BOG (HÆFTET)
Kampagne pris kr 186

kr 249
Normalpris
kr 192
Medlemspris
SPAR
kr 63
BOG (HARDBACK)
Kampagne pris kr 223

kr 299
Normalpris
kr 231
Medlemspris
SPAR
kr 76
BOG (INDBUNDET)
Kampagne pris kr 211

kr 299
Normalpris
kr 220
Medlemspris
SPAR
kr 88
BOG (PAPERBACK)
Kampagne pris kr 165

kr 197
Normalpris
kr 168
Medlemspris
SPAR
kr 32
BOG (HÆFTET)
Kampagne pris kr 189

kr 299
Normalpris
kr 200
Medlemspris
SPAR
kr 110
BOG (HÆFTET)
Kampagne pris kr 164

kr 199
Normalpris
kr 168
Medlemspris
SPAR
kr 35
BOG (PAPERBACK)
Kampagne pris kr 114

kr 127
Normalpris
kr 115
Medlemspris
SPAR
kr 13
Vi anbefaler også
BOG (PAPERBACK)
Kampagne pris kr 478

kr 552
Normalpris
kr 485
Medlemspris
SPAR
kr 74
BOG (PAPERBACK)
Kampagne pris kr 303

kr 401
Normalpris
kr 313
Medlemspris
SPAR
kr 98
BOG (PAPERBACK)
Kampagne pris kr 259

kr 359
Normalpris
kr 269
Medlemspris
SPAR
kr 100
BOG (PAPERBACK)
Kampagne pris kr 236

kr 311
Normalpris
kr 244
Medlemspris
SPAR
kr 75
BOG (PAPERBACK)
Kampagne pris kr 323

kr 456
Normalpris
kr 336
Medlemspris
SPAR
kr 133
BOG (PAPERBACK)
Kampagne pris kr 296

kr 305
Normalpris
kr 297
Medlemspris
SPAR
kr 9
BOG (PAPERBACK)
Kampagne pris kr 253

kr 327
Normalpris
kr 260
Medlemspris
SPAR
kr 74
BOG (PAPERBACK)
Kampagne pris kr 358

kr 529
Normalpris
kr 375
Medlemspris
SPAR
kr 171
BOG (PAPERBACK)
Kampagne pris kr 249

kr 332
Normalpris
kr 257
Medlemspris
SPAR
kr 83
BOG (PAPERBACK)
Kampagne pris kr 330

kr 360
Normalpris
kr 333
Medlemspris
SPAR
kr 30
BOG (PAPERBACK)
Kampagne pris kr 295

kr 315
Normalpris
kr 297
Medlemspris
SPAR
kr 20
BOG (PAPERBACK)
Kampagne pris kr 312

kr 337
Normalpris
kr 315
Medlemspris
SPAR
kr 25
BOG (PAPERBACK)
Kampagne pris kr 280

kr 307
Normalpris
kr 283
Medlemspris
SPAR
kr 27
BOG (PAPERBACK)
Kampagne pris kr 373

kr 505
Normalpris
kr 386
Medlemspris
SPAR
kr 132
BOG (PAPERBACK)
Kampagne pris kr 216

kr 332
Normalpris
kr 228
Medlemspris
SPAR
kr 116
BOG (PAPERBACK)
Kampagne pris kr 360

kr 486
Normalpris
kr 373
Medlemspris
SPAR
kr 126
BOG (PAPERBACK)
Kampagne pris kr 358

kr 397
Normalpris
kr 362
Medlemspris
SPAR
kr 39
BOG (PAPERBACK)
Kampagne pris kr 365

kr 376
Normalpris
kr 366
Medlemspris
SPAR
kr 11
BOG (PAPERBACK)
Kampagne pris kr 373

kr 416
Normalpris
kr 377
Medlemspris
SPAR
kr 43
BOG (PAPERBACK)
Kampagne pris kr 268

kr 281
Normalpris
kr 269
Medlemspris
SPAR
kr 13