SFr. 50.40
€ 54.43
BTC 0.0008
LTC 0.663
ETH 0.0168


bestellen

Artikel-Nr. 19161208


Diesen Artikel in meine
Wunschliste
Diesen Artikel
weiterempfehlen
Diesen Preis
beobachten

Weitersagen:



Autor(en): 
  • John Viescas
  • Ben Clothier
  • Douglas Steele
  • Effective SQL: 61 Specific Ways to Write Better SQL 
     

    (Buch)
    Dieser Artikel gilt, aufgrund seiner Grösse, beim Versand als 2 Artikel!


    Übersicht

    Auf mobile öffnen
     
    Lieferstatus:   Auf Bestellung (Lieferzeit unbekannt)
    Veröffentlichung:  Februar 2017  
    Genre:  EDV / Informatik 
    ISBN:  9780134578897 
    EAN-Code: 
    9780134578897 
    Verlag:  Pearson Academic 
    Einband:  Kartoniert  
    Sprache:  English  
    Serie:  Effective Software Development  
    Dimensionen:  H 230 mm / B 176 mm / D 14 mm 
    Gewicht:  540 gr 
    Seiten:  352 
    Bewertung: Titel bewerten / Meinung schreiben
    Inhalt:
    “Given the authors’ reputations, I expected to be impressed. I was blown away! . . . Most SQL books sit on my shelf. This one will live on my desk.”
    –Roger Carlson, Microsoft Access MVP (2006-2015)
    “Rather than stumble around reinventing wheels or catching glimpses of the proper approaches, do yourself a favor: Buy this book.”
    —Dave Stokes, MySQL Community Manager, Oracle Corporation
    Effective SQL brings together practical solutions and insights so you can solve complex problems with SQL and design databases that simplify data management in the future. It’s the only modern book that brings together advanced best practices and realistic example code for all of these versions of SQL: IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL.
    Drawing on their immense experience as world-class database consultants and instructors, the authors identify 61 proven approaches to writing better SQL. Wherever SQL versions vary, the authors illuminate the key nuances, so you can get the most out of whatever version you prefer. This full-color guide provides clear, practical explanations; expert tips; and plenty of usable code. Going far beyond mere syntax, it addresses issues ranging from optimizing database designs to managing hierarchies and metadata. If you already know SQL’s basics, this guide will help you become a world-class SQL problem-solver.

    • Craft better logical data models, and fix flawed models
    • Implement indexes that improve query performance
    • Handle external data from sources you don’t control
    • Extract and aggregate the information you need, as efficiently as possible
    • Write more flexible subqueries
    • Analyze and retrieve metadata using your database platform of choice
    • Use Cartesian Products and Tally Tables to solve problems you can’t address with conventional JOINs
    • Model hierarchical data: managing SQL’s tradeoffs and shortcomings
      



    Wird aktuell angeschaut...
     

    Zurück zur letzten Ansicht


    AGB | Datenschutzerklärung | Mein Konto | Impressum | Partnerprogramm
    Newsletter | 1Advd.ch RSS News-Feed Newsfeed | 1Advd.ch Facebook-Page Facebook | 1Advd.ch Twitter-Page Twitter
    Forbidden Planet AG © 1999-2024
    Alle Angaben ohne Gewähr
     
    SUCHEN

     
     Kategorien
    Im Sortiment stöbern
    Genres
    Hörbücher
    Aktionen
     Infos
    Mein Konto
    Warenkorb
    Meine Wunschliste
     Kundenservice
    Recherchedienst
    Fragen / AGB / Kontakt
    Partnerprogramm
    Impressum
    © by Forbidden Planet AG 1999-2024
    Jetzt auch mit LiteCoin bestellen!