MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout. This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions. If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language. Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.

Restructuring information in an XML document so that it works in other formats used to be a time-consuming ordeal involving lots of blood, sweat, and tears. Now XSLT (Extensible Stylesheet Language Transformations) makes the process nearly instantaneous. Just provide an example of the kind of information you'd like to see, and XSLT does the rest. With XSLT you can effortlessly transform XML documents into virtually any kind of output, including other XML documents and HTML pages. But mastering XSLT can be tricky, especially if you've never worked with XML or HTML; and most books on the subject are written for people who have. Here comes XSLT For Dummies to the rescue! XSLT For Dummies is your ticket to quickly mastering XSLT—no matter what your prior programming experience. Writing in easygoing, plain English, XML pro Richard Wagner provides expert advice, step-by-step guidance, and tons of crystal-clear examples to help you harness the power of XSLT to transform documen ts. In no time you'll: Understand how XSLT works with XSL and XPath Experiment with templates, stylesheets, and expressions Perform HTML transformations Master XPath data types and functions Combine XSLT stylesheets Explore cool XSLT programming tricks XSLT For Dummies works from the ground up, starting with a practical introduction of the "X-Team"—XML, XSL, XSLT, and X-Path—and instructions on how to write a XSLT stylesheet. From there it quickly moves onward and upward through the whole range of important XSLT topics, including: Transforming with stylesheets Understanding and using template rules Using XPath to locate nodes in XML documents Combining XSLT stylesheets and adding processing instructions Debugging XSLT transformations Ten XSLT processors available online It doesn't matter whether you're a babe in the woods who can't tell a "tag" from an element, or you're an old pro at creating XML documents, XSLT For Dummies offers you a fun, easy way to explore and take full advantage of Extensible Stylesheet Language Transformations.

Special Edition Using XSLT starts with an overview explaining how XSLT fits into the bigger picture of the Extensible Stylesheet Language, and the differences between XSLT and XSL-FO. It then demonstrates practical examples of XSL transformations from XML to a variety of other useful formats including HTML, PDF, SVG and others. Later chapters discuss developer techniques for implementing XSLT within dynamic web environments including ASP and JSP. The author also covers debugging techniques and how XSLT relates to .NET. The book finishes with a useful reference section including detailed coverage of XSLT, XPath and XSL-FO.

"This is a book that deserves a prominent place by anyone who aspires to be a real professional developer of SQL Server applications." --from the Foreword by Ron Soukup The message of this book is that building stored procedures in Transact-SQL is very much like building programs in any other language. It requires the same type of skill, planning, attention to detail, and overall grasp of technology that successful development in other languages requires. To master Transact-SQL, one must first master the fundamental concepts of software development, then build on this foundation by embracing and studying Transact-SQL as a programming language in its own right. This book teaches you how to do that and more. More than just a catalog of coding tricks and syntax subtleties, explores the philosophy of Transact-SQL programming. It teaches readers how to apply this philosophy in order to develop their own coding techniques and discover their own solutions to real-world programming problems. A follow-up to the widely acclaimed The Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML The Guru's Guide to Transact-SQL, this book teaches that stored procedure development does not occur in a vacuum--it involves a wide variety of skills, subjects, and technologies--and helps the reader become a better software engineer, not just a stored procedure expert. Blending theoretical detail with practical application, this comprehensive reference begins with a foundational overview of SQL Server(TM) stored procedure programming. From there, the focus moves on to best practices and design considerations before progressing to advanced topics and a general philosophy of software craftsmanship. In all, this book provides the most complete coverage of SQL Server stored procedure programming available in one source. Topics such as user-defined functions, views, triggers, extended procedures, error handling, OLE Automation, database design, and XML are covered in detail. The book spotlights undocumented language features and brings the first application of design patterns to the SQL language. The preview of .NET and a groundbreaking approach to adding arrays to Transact-SQL make for the most thorough and engaging read published to date on SQL Server programming. The accompanying CD-ROM contains the book's source code. More than 700 SQL scripts, programming utilities, and extended procedures provide a veritable treasure trove of high-quality example code. Theoretically sound, yet immensely practical, provides developers with the tools they need to become expert stored procedure programmers and better software engineers. The Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML 0201700468B11262001

Building on the success of the first and second editions of The XML Companion, Neil Bradley has up-dated this accessible, in-depth reference to cover many of the new supporting standards that have emerged since XML was released in 1998. Apart from the core chapters on the XML standard itself, this book concentrates on related standards developed by the W3C and on the two most popular applications of this technology: document publishing and data exchange. The XML Companion Provides accessible, comprehensive description of each XML feature Does not assume experience of HTML or SGML Detailed study of the standard is supported by the inclusion of cross-referenced ‘roadmaps’ of the building blocks that comprise the standard. Includes an extensive glossary Related standards for cataloguing, processing, linking and styling XML are covered in detail.

XSLT documents a core technology for processing XML. Originally created for page layout, XSLT (Extensible Stylesheet Transformations) is now much more: a general-purpose translation tool, a system for reorganizing document content, and a way to generate multiple results-- such as HTML, WAP, and SVG--from the same content. What sets XSLT apart from other books on this critical tool is the depth of detail and breadth of knowledge that Doug Tidwell, a developer with years of XSLT experience, brings to his concise treatment of the many talents of XSLT. He covers XSLT and XPath, a critical companion standard, and addresses topics ranging from basic transformations to complex sorting and linking. He explores extension functions on a variety of different XSLT processors and shows ways to combine multiple documents using XSLT. Code examples add a real-world dimension to each technique. Useful as XSLT is, its peculiar characteristics make it difficult to get started in, and the ability to use advanced techniques depends on a clear and exact understanding of how XSLT templates work and interact. For instance, the understanding of "variables" in XSLT is deeply different from the understanding of "variables" in procedural languages. The author explains XSLT by building from the basics to its more complex and powerful possibilities, so that whether you're just starting out in XSLT or looking for advanced techniques, you'll find the level of information you need.

While the XML "buzz" still dominates talk among Internet developers, the critical need is for information that cuts through the hype and lets Java programmers put XML to work. Java & XML shows how to use the APIs, tools, and tricks of XML to build real-world applications, with the end result that both the data and the code are portable. This second edition of Java & XML adds chapters on Advanced SAX and Advanced DOM, new chapters on SOAP and data binding, and new examples throughout. A concise chapter on XML basics introduces concepts, and the rest of the book focuses on using XML from your Java applications. Java developers who need to work with XML, or think that they will in the future--as well as developers involved in the new peer-to-peer movement, messaging, or web services--will find the new Java & XML a constant companion. This book covers: The basics of XML, including DTDs, namespaces, XML Schema, XPath, and XSL The SAX API, including all handlers, the SAX 2 extensions, filters, and writers The DOM API, including DOM Level 2, Level 3, and the Traversal, Range, CSS, Events, and HTML modules. The JDOM API, including the core, a look at XPath support, and JDOM as a JSR Using web publishing frameworks like Apache Cocoon Developing applications with XML-RPC Using SOAP and UDDI for web services Data Binding, using both DTDs and XML Schema for constraints Building business-to-business applications with XML Building information channels with RSS and dynamic content with XSP Includes a quick reference on SAX 2.0, DOM Level 2, and JDOM.

Gain total control over your information with XSLT and XPath! Master XSLT and XPath—the "keys to the XML kingdom" Build custom XML output solutions that won't become obsolete Learn everything from basic XML-to-HTML conversions to leading edge techniques CD-ROM includes all examples from the book Mastering XSLT and XPath gives you unprecedented control over your information—and helps you leverage virtually every new XML technology, from XLink to schemas. Discover XSLT's powerful vocabulary of easy, programming-like features, and learn how to build custom solutions that resist obsolescence. By the end of the first chapter, you'll be performing XML-to-HTML conversions for display in any Web browser. Then build on your knowledge through a series of hands-on examples that transform you into an XSLT/XPath expert! XSLT as an XML document instance: leveraging your existing XML skills XSLT stylesheet concepts and constructs: fundamental through advanced level XPath patterns and functions XSLT subroutine functions and variables XSLT processing of multiple nodes: iterative and conditional XSLT elements Controlling output options XSLT extensions, and more Whether you're an experienced programmer or a novice markup specialist, here's your chance to master XML's most potent tools for organizing, updating, and delivering digital information—any data, anywhere, any time!

Inside XSLT is designed to be a companion guide to Inside XML. This example oriented book covers XML to HTML, XML to Music, XML with Java, style sheet creation and usage, nodes and attributes, sorting data, creating Xpath expressions, using Xpath and XSLT functions, namespaces, names templates, name variables, designing style sheets and using XSLT processor API's, the 56 XSL formatting objects, the XSLT DTD, and much much more.

XML, the Extensible Markup Language, is the next-generation markup language for the Web. It provides a more structured (and therefore more powerful) medium than HTML, allowing you to define new document types and stylesheets as needed. Although the generic tags of HTML are sufficient for everyday text, XML gives you a way to add rich, well-defined markup to electronic documents. The XML Pocket Reference is both a handy introduction to XML terminology and syntax, and a quick reference to XML instructions, attributes, entities, and datatypes. Although XML itself is complex, its basic concepts are simple. This small book combines a perfect tutorial for learning the basics of XML with a reference to the XML and XSL specifications. The new edition introduces information on XSLT (Extensible Stylesheet Language Transformations) and Xpath.

The arrival of support for XML--the Extensible Markup Language--in browsers and authoring tools has followed a long period of intense hype. Major databases, authoring tools (including Microsoft's Office 2000), and browsers are committed to XML support. Many content creators and programmers for the Web and other media are left wondering, "What can XML and its associated standards really do for me?" Getting the most from XML requires being able to tag and transform XML documents so they can be processed by web browsers, databases, mobile phones, printers, XML processors, voice response systems, and LDAP directories, just to name a few targets. In Learning XML, the author explains XML and its capabilities succinctly and professionally, with references to real-life projects and other cogent examples. Learning XML shows the purpose of XML markup itself, the CSS and XSL styling languages, and the XLink and XPointer specifications for creating rich link structures. The basic advantages of XML over HTML are that XML lets a web designer define tags that are meaningful for the particular documents or database output to be used, and that it enforces an unambiguous structure that supports error-checking. XML supports enhanced styling and linking standards (allowing, for instance, simultaneous linking to the same document in multiple languages) and a range of new applications. For writers producing XML documents, this book demystifies files and the process of creating them with the appropriate structure and format. Designers will learn what parts of XML are most helpful to their team and will get started on creating Document Type Definitions. For programmers, the book makes syntax and structures clear It also discusses the stylesheets needed for viewing documents in the next generation of browsers, databases, and other devices.

Sams Teach Yourself XML in 24 Hours teaches you the fundamental concepts of XML using practical, hands-on examples. Rather than dwelling on dry theory, the book is filled with clear, real-world examples of how the technology can be used today. Coverage includes displaying XML files in HTML files, parsing HTML files into corresponding hierarchical tree structure, embedding XML code into an HTML file, using Extensible Style Sheets (XSL), performing queries in XSL, and building an online store.

XML by Example teaches Web developers to make the most of XML with short, self-contained examples every step of the way. The book presumes knowledge of HTML, the Web, Web scripting, and covers such topics as: Document Type Definitions, Namespaces, Parser Debugging, XSL (Extensible Stylesheet Language), and DOM and SAX APIs. At the end, developers will review the concepts taught in the book by building a full, real-world e-commerce application.

XML, the Extensible Markup Language, is the next-generation markup language for the Web. It provides a more structured (and therefore more powerful) medium than HTML, allowing us to define new document types and stylesheets as needed. Although the generic tags of HTML are sufficient for everyday text, XML gives us a way to add rich, well-defined markup to electronic documents. The XML Pocket Reference is both a handy introduction to XML terminology and syntax, and a quick reference to XML instructions, attributes, entities, and datatypes. It also covers XSL (Extensible Stylesheet Language), necessary to ensure that your XML documents have a consistent look and feel across platforms. Although XML itself is complex, its basic concepts are simple. This small book acts both as a perfect tutorial for learning the basics of XML, and as a reference to the XML and XSL specifications.

This compact guide provides the jump-start Oracle developers need to make the transition from traditional programming to the development of useful Web applications for Oracle8i. Even readers who start out knowing nothing about HTML, PL/SQL, or Oracle's other tools will learn how to create simple Web applications in a matter of days. The book focuses on Oracle8i, but also covers Web development for earlier Oracle versions (Oracle8 and Oracle7). Background: The explosion in the use of the Internet and the Web has resulted in a whole new way of doing business. Developers who only yesterday were using COBOL to write accounts payable systems are now being asked to create a broad range of new Internet-based applications ranging from electronic commerce (e-commerce) Web sites to internal data warehouses to enterprise resource planning (ERP) systems. Unfortunately, the filesystem architectures of most Web systems aren't up to the task. The new breed of Web applications -- which are quickly becoming critical resources that companies need to survive -- demand a platform that provides production-quality tools for content management, application development, and application integration. And current Web techniques are inadequate in many ways. Oracle8i, Oracle's "Internet database," gives Web developers a way to build Web technology on top of a relational database, rather than on a traditional filesystem. With Oracle8i, companies can apply well understood, reliable, production-quality database methodologies to Web content management. Oracle8i also supports a wide variety of application development platforms and tools that are tightly integrated to the core database. Finally, Oracle8i supports technologies that help companies tie their Web-based applications into legacy applications. There is a lot to learn in Oracle8i. Not only does it enhance basic database features, it introduces Java and a variety of Web development tools. Oracle8i provides a soup-to-nuts platform for Web site and Web application development that extends traditional database concepts to Web content. It replaces the traditional filesystem used by most Web servers with a database management system. Many users are intimidated by the vast array of new technologies in Oracle8i. And yet, they are under pressure to use these technologies to build complex Web applications right now. This book gives such users a way to start using Oracle8i immediately to create useful Web applications. It is a concise, easy-to-read guide to the basic technologies developers need to understand in order to build Web applications. Contains: The book describes the following Web development tools: PL/SQL-- a structured programming language that combines procedural constructs and standard SQL. It offers such features as cursors, loops, conditional and sequential control statements, exception handlers, records, tables, and constructs for developing modular code (functions, procedures, and packages). PL/SQL Toolkit -- a set of PL/SQL packages supplied by Oracle for use in developing Web applications. HTML -- an ASCII-based markup language used to create Web pages. WebDB -- A software system for building, monitoring, and creating content-driven Web sites; it allows users to use a Web browser to access and store information in the Oracle8i database. Oracle Application Server (OAS) -- an extensible Web server that uses plug-in programs called cartridges to allow database-integrated Web systems to be developed in a variety of languages (e.g., PL/SQL, Java, Perl). XML -- An emerging standard for creating self-describing documents. It is similar to HTML but allows you to create your own markup tags. XML is expected to be a key technology in electronic commerce systems. The book also presents several fully realized sample Web applications that will teach you how to build such applications of your own. NOTE: Although this book touches on the Java features of Oracle8i, it doesn't cover Java development per se. Switching to Java represents an enormous change for most Oracle developers. This book provides an evolutionary path for readers who want to do useful Oracle8i Web development now, using mostly familiar tools. Additional books will provide Java training for those who have mastered these Web tools and want to take the next step.

MySQL and mSQL are popular and robust database products that support key subsets of SQL on both Linux and Unix systems. Both products are free for nonprofit use and cost a small amount for commercial use. Even a small organization or web site has uses for a database. Perhaps you keep track of all your customers and find that your information is outgrowing the crude, flat-file format you started with. Or you want to ask your web site's visitors for their interests and preferences and put up a fresh web page that tallies the results. Unlike commercial databases, MySQL and mSQL are affordable and easy to use. If you know basic C, Java, Perl, or Python, you can quickly write a program to interact with your database. In addition, you can embed queries and updates right in an HTML file so that a web page becomes its own interface to the database. This book is all you need to make use of MySQL or mSQL. It takes you through the whole process from installation and configuration to programming interfaces and basic administration. Includes reference chapters and ample tutorial material. Topics include: Introductions to simple database design and SQL Building, installation, and configuration Basic programming APIs for C, C++, Java (JDBC), Perl, and Python CGI programming with databases in C and Perl Web interfaces: PHP, W3-mSQL, Lite, and mSQLPerl

"Each chapter is... a practice run for the way we all ought to design our data marts and hence our data warehouses."-Ralph Kimball, from the Foreword. Let the experts show you how to customize data warehouse designs for real business needs in Data Warehouse Design Solutions. To effectively design a data warehouse, you have to understand its many business uses. This guidebook shows you how business managers in different corporate functions actually use data warehouses to make decisions. You'll get a rich set of data warehouse designs that flow from realistic business cases. Two top experts show you how to customize your data warehouse designs for real-life business needs including: Sales and marketing Production and inventory management Budgeting and financial reporting Quality control Product delivery and fulfillment Strategic business analysis such as determining market share, rates of return on investment, and other key analytic ratios. CD-ROM includes All sample data warehouse designs with accompanying preformatted reports in HTML for specific business uses such as marketing, sales, and financial analysis. This title includes additional digital media when purchased in print format. For this digital book edition, media content may not be included. Contact the publisher's customer service directly for assistance.