Home | Amazing | Today | Tags | Publishers | Years | Search 
Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition

Buy
In the SQL database community, Joe Celko is a well-known columnist and purveyor of valuable insights. In Joe Celko's SQL for Smarties: Advanced SQL Programming, he picks up where basic SQL training and experience leaves many database professionals and offers tips, techniques, and explanations that help readers extend their capabilities to top-tier SQL programming.

Although Celko denies that the book is about database theory, he nevertheless alludes to theory often to buttress his practical points. This title is not for novices, as the author points out. Instead, its intended audience is SQL programmers with at least a year's experience. The book maintains a fine balance between technical discussion and practical explanation--picking hot topics and offering advice on a wide range of issues.

The book uses ANSI SQL-89 as its baseline standard, with some mention of SQL-92 features. It does not, however, focus on any commercial product; this guide zeroes in on the SQL language. Celko covers all aspects of database design, optimization, and manipulation, with easy-to-understand explanations of key issues such as why not to use too many nulls, how to use practical normalization, and how to optimize queries.

This insightful text is manna for all the day-to-day SQL coders banging their heads over the language's subtle challenges. --Stephen W. Plain

Topics covered: Database design and normalization, SQL data types, querying, grouping, set operations, optimization, data scaling, and encoding.

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, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance.

In the third edition, Joe features new examples and updates to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics.

* Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums.
* Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment.
* Offers tips for working around system deficiencies.
* Continues to use war stories--updated!--that give insights into real-world SQL programming challenges.

MCTS Guide to Microsoft Windows Server 2008 Network Infrastructure Configuration (exam #70-642) (Test Preparation)
MCTS Guide to Microsoft Windows Server 2008 Network Infrastructure Configuration (exam #70-642) (Test Preparation)

MCTS Guide to Microsoft Windows Server 2008 Network Infrastructure Configuration (Exam 70-642) prepares the reader to configure networks using the Microsoft Windows Server 2008 operating system and to pass the MCTS 70-642 certification exam. Focusing on updates to the software and in-depth coverage of the network aspects of Windows Server...

Data and Computer Communications: Networking and Internetworking
Data and Computer Communications: Networking and Internetworking
Hura and Singhal discuss all the complex issues involved in networking and provide an excellent resource for practitioners and instruction for students. They offer a comprehensive treatment …
-CHOICE, October 2001, Vol. 39 No. 2

This book covers a vast area of communications technology in 1,140 pages. It is aimed at
...
Climate Friendly Goods and Technologies in Asia: Opportunities for Trade (SpringerBriefs in Environmental Science)
Climate Friendly Goods and Technologies in Asia: Opportunities for Trade (SpringerBriefs in Environmental Science)

This book investigates the potential trade opportunity of climate friendly goods and technology (CFGT) in Asia and South Asia region, and uses a case study of India to clarify India's position on global warming and efforts to mitigate climate change impacts regionally and globally. In four main sections, the book applies...


Complete Adobe Photoshop CS4 for Digital Photographers
Complete Adobe Photoshop CS4 for Digital Photographers

Learn how to get the most out of all the newest features of Photoshop and improve your images with "Complete Adobe Photoshop CS4 for Digital Photographers." Photoshop is the new darkroom, providing instant results and making professional-level tools accessible even to amateurs. This new edition of the book is filled with brand new...

Network-Embedded Management and Applications: Understanding Programmable Networking Infrastructure
Network-Embedded Management and Applications: Understanding Programmable Networking Infrastructure

Despite the explosion of networking services and applications in the past decades, the basic technological underpinnings of the Internet have remained largely unchanged.  At its heart are special-purpose appliances that connect us to the digital world, commonly known as switches and routers.  Now, however, the traditional framework...

Yahoo! Web Analytics: Tracking, Reporting, and Analyzing for Data-Driven Insights
Yahoo! Web Analytics: Tracking, Reporting, and Analyzing for Data-Driven Insights
Yahoo! Web Analytics teaches readers how to collect data, report on that data, and derive useful insights using Yahoo!’s free Web analytics tool . This detailed resource from Yahoo!’s Director of Data Insights discusses the why of Web analytics as well as the how while revealing secrets and tricks not documented elsewhere. The...
©2024 LearnIT (support@pdfchm.net) - Privacy Policy