• Fri frakt över 249 kr
  • •
  • Snabba leveranser
  • •
  • Billiga böcker
Kundservice

Du är på sajten för privatpersoner.

Företag, bibliotek eller offentlig verksamhet?

Du handlar på classic.bokus.com, där alla dina funktioner finns intakta.
Till classic.bokus.com
Bokus logotyp. Gå till startsidan.
  • Erbjudanden
  • Nyheter
  • Student
  • Topplistor
  • Barn & ungdom
  • Bokus Play
  • E-böcker
  • Pocketböcker
  • Spel & pussel

10% rabatt på allt med kod NYSTART10 →

Sidfot

Mina sidor

    Hjälp

    • Kundservice
    • Vanliga frågor och svar
    • Frakt och leverans
    • Retur vid ångerrätt
    • Reklamera vara
    • Betalning
    • Köpvillkor
    • Allmänna villkor
    • Information om webbplatsens tillgänglighet

    Om Bokus

    • Om oss
    • Pressrum
    • För studenter
    • För företag
    • För bibliotek och offentlig verksamhet
    • För leverantörer
    • Hållbarhet

    Populärt

    • Aktuella erbjudanden
    • Presentkort
    • Studentlitteratur
    • Nya böcker
    • Topplistor
    • Signerade böcker
    • Engelska böcker

    Inspiration

    • Boktips
    • BookTok
    • Populära bokserier
    • Barnbokskaraktärer
    • Populära författare
    Logotyp för Bokus
    Följ oss på Facebook (extern länk)Följ oss på Instagram (extern länk)Följ oss på YouTube (extern länk)Följ oss på TikTok (extern länk)
    bokus @ CookiesAnpassa cookiesIntegritetspolicyKöpvillkor
    Till Citymail hemsida (extern länk)Till Budbee hemsida (extern länk)Till Postnord hemsida (extern länk)Till Schenker hemsida (extern länk)Till Early Bird hemsida (extern länk)Till Walleys hemsida (extern länk)
    1. Data och IT
    2. Programmeringsböcker

    Joe Celko's SQL Puzzles and Answers

    AvJoe Celko

    Häftad, Engelska, 2006

    Del i serien The Morgan Kaufmann Series in Data Management Systems

    649 kr

    Beställningsvara. Skickas inom 10-15 vardagar. Fri frakt över 249 kr.

    Fler format och utgåvor

    E-bok

    634 kr

    Beskrivning

    Joe Celko's SQL Puzzles and Answers, Second Edition, challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations.

    Author Joe Celko demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but also help develop the mindset needed to solve the many difficult SQL puzzles you face every day. This updated edition features many new puzzles; dozens of new solutions to puzzles; and new chapters on temporal query puzzles and common misconceptions about SQL and RDBMS that leads to problems.

    This book is recommended for database programmers with a good knowledge of SQL.



    • A great collection of tricky SQL puzzles with a variety of solutions and explanations
    • Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems
    • New edition features: Many new puzzles added!, Dozens of new solutions to puzzles, and using features in SQL-99, Code is edited to conform to SQL STYLE rules, New chapter on temporal query puzzles, New chapter on common misconceptions about SQL and RDBMS that leads to problems

    Produktinformation

    • Utgivningsdatum:2006-10-09
    • Mått:191 x 235 x 22 mm
    • Vikt:720 g
    • Format:Häftad
    • Språk:Engelska
    • Serie:The Morgan Kaufmann Series in Data Management Systems
    • Antal sidor:352
    • Upplaga:2
    • Förlag:Elsevier Science
    • ISBN:9780123735966

    Utforska kategorier

    • Programmeringsböcker inom Data och IT

    Mer om författaren

    Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

    Innehållsförteckning

    • PUZZLE 01: FISCAL YEAR TABLES PUZZLE 02: ABSENTEESPUZZLE 03: THE ANESTHESIA PUZZLEPUZZLE 04: SECURITY BADGES PUZZLE 05: ALPHA DATA PUZZLE 06: HOTEL RESERVATIONSPUZZLE 07: KEEPING A PORTFOLIO PUZZLE 08: SCHEDULING PRINTERS PUZZLE 09: AVAILABLE SEATS PUZZLE PUZZLE 10: WAGES OF SIN:PUZZLE 11: WORK ORDER PUZZLE 12: CLAIMS STATUS PUZZLE 13: TEACHERS PUZZLE 14: TELEPHONEPUZZLE 15: FIND THE LAST TWO SALARIESPUZZLE 16: MECHANICS PUZZLE 17: EMPLOYMENT AGENCYPUZZLE 18: JUNK MAIL PUZZLE 19: TOP SALESMENPUZZLE 20: TEST RESULTSPUZZLE 21: AIRPLANES AND PILOTSPUZZLE 22: LANDLORDPUZZLE 23: MAGAZINE PUZZLE 24 ONE IN TENPUZZLE 25: MILESTONE PUZZLE 26: DATAFLOW DIAGRAMSPUZZLE 27: FINDING EQUAL SETSPUZZLE 28: CALCULATE THE SINE FUNCTION PUZZLE 29: FIND THE MODE COMPUTATION PUZZLE 30: AVERAGE SALES WAIT PUZZLE 31: BUYING ALL THE PRODUCTS PUZZLE 32: COMPUTING TAXESPUZZLE 33: COMPUTING DEPRECIATION PUZZLE 34: CONSULTANT BILLING PUZZLE 35: REQUISITIONSPUZZLE 36: DOUBLE DUTYPUZZLE 37: MOVING AVERAGE PUZZLE 38: JOURNAL UPDATING PUZZLE 39: INSURANCE LOSSES PUZZLE 40: PERMUTATIONS:PUZZLE 41: BUDGETING PUZZLE 42: COUNTING FISH PUZZLE 43: GRADUATION PUZZLE 44: PAIRS OF STYLESPUZZLE 45: PEPPERONI PIZZA PUZZLE 46: SALES PROMOTIONSPUZZLE 47: BLOCKS OF SEATS PUZZLE 48: UN-GROUPINGPUZZLE 49: WIDGET COUNTPUZZLE 50: TWO OF THREEPUZZLE 51: BUDGET VERSUS ACTUALPUZZLE 52: PERSONNEL PROBLEMPUZZLE 53: COLLAPSING A TABLE BY COLUMNSPUZZLE 54: POTENTIAL DUPLICATES PUZZLE 55: PLAYING THE PONIESPUZZLE 56: HOTEL ROOM NUMBERSPUZZLE 57: GAPS - 1 PUZZLE 58: GAPS - 2 PUZZLE 59: MERGING TIME PERIODS PUZZLE 60: BARCODES PUZZLE 61: SORTING A STRING PUZZLE 62: REPORT FORMATTING PUZZLE 63: CONTIGUOUS GROUPINGS PUZZLE 64: BOXES PUZZLE 65: AGE RANGES FOR PRODUCTSPUZZLE 66: FOUR CONSECUTIVE ABSENCES PUZZLE 67: STABLE MARRIAGES PROBLEMPUZZLE 68: CATCHING THE NEXT BUS PUZZLE 69: LIFO-FIFO INVENTORYPUZZLE 70: STOCK TRENDSPUZZLE 71: CALCULATIONS PUZZLE 72: SCHEDULING SERVICE CALLSPUZZLE 73: A LITTLE DATA SCRUBBINGPUZZLE 74: DERIVED TABLES OR NOT?PUZZLE 75: FINDING A PUB