SQL is the de facto standard for database retrieval, and if you need to access, update, or utilize data in a modern database management system, you may need SQL to do it. This title teaches scores of advanced techniques that can be used with any product, in any SQL environment.
Joe Celko's SQL for Smarties: Advanced SQL Programming provides advanced programming tips and techniques across 39 chapters. It begins with a comparison of databases and file systems, then delves into transactions, currency control, schema-level objects, and the organization of data through base and auxiliary tables. The book explores procedural, semi-procedural, and declarative programming styles, as well as various normal forms in database normalization, including first through fifth normal forms, elementary key, domain-key, and Boyce-Codd normal forms, along with practical guidance for normalization and denormalization. It covers different data types—numeric, temporal, and character—alongside predicates and both simple and advanced SELECT statements. Virtual tables, data partitioning in queries, grouping operations, simple aggregate functions, and descriptive statistics, matrices, and graphs in SQL are also discussed. The concluding chapters focus on SQL optimization, making this resource invaluable for SQL programmers. Key features include expert advice from a recognized SQL authority and columnist, teaching numerous advanced techniques applicable in any SQL environment, whether SQL 92 or SQL 2008, while providing insights into overcoming real-world challenges and deficiencies.
"Take Linthicum's warnings seriously . . . he's been through the fire!"-Rusty Weston, Senior Editor, PC Week.A renowned client/server expert provides state-of-the-art techniques for building client/server and intranet applications.In this valuable guide, client/server guru David Linthicum shows developers how to use cutting-edge development tools and techniques to build real-life business applications. The book provides step-by-step procedures for creating these applications, explains how to select the software and hardware that's right for your projects, and even provides guidelines on estimating project costs.This unique book covers client/server and network architectures, types of middleware, and development tools so you can determine the right approach to building a client/server or intranet system. Linthicum assesses dozens of tools by type, features, and specialization and provides detailed, step-by-step guidelines for creating the perfect solution. You'll learn how to form and test your final system and find expert tips every developer and application architect needs to work more effectively.In addition to providing recommendations, warnings, and case studies, Dave * The latest client/server development tools and methods* Two-tier, three-tier, and multi-tier client/server development models and related technologies* Repository-driven development, programming languages, database connectivity, and middleware* The use of CORBA-compliant ORBs and the inner workings of Microsoft Active Platform* Next-generation application partitioning tools like Forte and Dynasty.
Der 16-jährige Max hatte es bislang nicht leicht im Leben. Aufgrund von Konflikten mit den Eltern wohnt er in einer Wohngruppe für Jugendliche und in der Schule ist er ständigem Mobbing ausgesetzt. Doch als er aus einem Gully einen kranken Kater rettet, beginnt sich das Blatt zu wenden. Pixel wird für Max zu einem treuen Freund. Und dann zieht auch noch Konni in die WG, den Max zunächst eher furchteinflößend findet. Doch schnell wird klar, so gruselig wie er aussieht, ist Konni gar nicht …