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.
A renowned client/server expert provides state-of-the-art techniques for building client/server and intranet applications. This valuable guide shows developers how to leverage cutting-edge development tools and techniques to create real-life business applications. It offers step-by-step procedures for application creation, guidance on selecting appropriate software and hardware, and tips for estimating project costs. The book covers client/server and network architectures, middleware types, and development tools, enabling you to determine the best approach for your projects. It assesses numerous tools by type, features, and specialization, along with detailed guidelines for crafting effective solutions. You'll learn how to form and test your final system, along with expert tips essential for developers and application architects to enhance their effectiveness. In addition to recommendations and warnings, the guide includes case studies and covers the latest client/server development tools and methods, two-tier, three-tier, and multi-tier development models, repository-driven development, programming languages, database connectivity, and middleware. It also explores CORBA-compliant ORBs, the Microsoft Active Platform, and 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 …