No products in the cart.
Use coupon code “MARCH20” for a 20% discount on all items! Valid until 31-03-2025
Royal Mail express delivery to UK destinations
Regular sales and promotions
Stock updates every 20 minutes!
We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.
The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ...
Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.
Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.
Use coupon code “MARCH20” for a 20% discount on all items! Valid until 31-03-2025
Royal Mail express delivery to UK destinations
Regular sales and promotions
Stock updates every 20 minutes!
3 in stock
£50.99
Buy new:
Delivery: UK delivery Only. Usually dispatched in 1-2 working days.
Shipping costs: All shipping costs calculated in the cart or during the checkout process.
Standard service (normally 2-3 working days): 48hr Tracked service.
Premium service (next working day): 24hr Tracked service – signature service included.
Royal mail: 24 & 48hr Tracked: Trackable items weighing up to 20kg are tracked to door and are inclusive of text and email with ‘Leave in Safe Place’ options, but are non-signature services. Examples of service expected: Standard 48hr service – if ordered before 3pm on Thursday then expected delivery would be on Saturday. If Premium 24hr service used, then expected delivery would be Friday.
Signature Service: This service is only available for tracked items.
Leave in Safe Place: This option is available at no additional charge for tracked services.
| Product ID: | 9780128007617 |
| Product Form: | Paperback / softback |
| Country of Manufacture: | US |
| Series: | The Morgan Kaufmann Series in Data Management Systems |
| Title: | Joe Celko's SQL for Smarties |
| Subtitle: | Advanced SQL Programming |
| Authors: | Author: Joe Celko |
| Page Count: | 852 |
| Subjects: | Database programming, Database programming |
| Description: | Select Guide Rating SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance.New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth.SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You’ll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions. |
| Imprint Name: | Morgan Kaufmann Publishers In |
| Publisher Name: | Elsevier Science & Technology |
| Country of Publication: | GB |
| Publishing Date: | 2014-12-02 |
GoBookshop!
Proudly owned and operated by:
Raythex LTD
17-19 Saint Georges Street
NORWICH
NR3 1AB
Registered No. 15042401
We accept the following payment methods:
