Product Description
Programming Microsoft
SQL Server 2000 Stored Procedure & XML Programming, Second Edition
Product Description
Get thorough coverage of SQL Server 2000–including extended XML capabilities and VS.NET updates with this expertly written resource. Learn to harness the full benefits of modular programming, and achieve faster execution and a reduction of network traffic. Included are a sample database and an end-to-end solution for a Web search engine.
SQL Server 2000 Stored Procedure & XML Programming, Second Edition
MS Excel 2002 VBA/XML Programming and ASP
Product Description
Designed to provide non-developers with a hands-on guide to Excel Visual Basic for Applications, Learn Microsoft Excel 2002 VBA Programming with XML and ASP gives users a wide range of VBA coverage, along with an introduction to the Extensible Markup Language and Active Server Pages technologies.
* Quickly learn how to program by utilizing the built-in macro recorder.
* Add decision making and repetition to your procedures.
* Control other applications from within Excel through Automation.
* Create and customize user forms, menus, and toolbars.
* Learn how to handle errors and debug your programs by using built-in debugging tools.
* Perform Microsoft Access tasks from within Excel.
* Discover how to put Excel data on a web page and retrieve data from the web into an Excel worksheet.
* Work with Excel spreadsheets saved in XML format.
* Program special features such as the Microsoft Office XP PivotTable and PivotChart web components.
* Learn how to use a number of objects from the Excel 2002 and Office XP Object Models.
ON THE CD:The companion CD-ROM contains example files discussed in the book.
Professional Oracle 8i Application Programming with Java, PL/SQL and XML
- ISBN13: 9781861004840
- Condition: USED – VERY GOOD
- Notes:
Product Description
Oracle Corporation has broadened its development platform, integrating open standards such as Java and XML into the heart of the Oracle 8i database. This extended programming environment continues to exploit the qualities of scalability, reliability and efficiency of the world’s most successful data management software, but at the same time it provides new challenges and opportunities to programmers.
This book shows you how to develop enterprise PL/SQL applications exploiting Java and XML, and how technologies such as EJBs can be moved to the 8i database. You’ll work through case studies using a mix of both familiar and unfamiliar tools and languages, showing you how the various programming approaches can enhance each other. Amazon.com Review
Suitable for any developer or manager who works on the Oracle platform, Professional Oracle 8i Application Programming with Java, PL/SQL, and XML is an excellent guide to the tools and programming techniques you’ll need for successful enterprise development using today’s Oracle.
Unless you buy an armful of books on current Oracle tools and technologies, you won’t likely find as comprehensive a tour as this. First off, the authors are masters at using Oracle tools for high-end enterprise development, including PL/SQL (its proprietary SQL language) and Java. Developers and IT managers will appreciate the clear descriptions of relevant tools in the Oracle arsenal (including Developer and JDeveloper). Business Components for Java (BC4J), which simplify the use of Enterprise JavaBeans with Oracle databases and JSP, are also explained succinctly.
The emphasis is on server-side programming, with all features supported in Oracle, like stored procedures (and objects), written in both PL/SQL and Java. This book excels at showing the nitty-gritty details, with screen shots revealing the actual Oracle tools in action. As for using Enterprise JavaBeans, readers learn two possible methods: with standard EJB, and with BC4J components created with JDeveloper. A sample for a restaurant finder application will help you try your hand at using both approaches.
The discussion of Oracle’s extensive XML support, which will be useful for taking advantage of this popular standard for real-world projects, is very strong. (Material on the emerging Simple Object Access Protocol (SOAP) and WML built with XML/XLST brings the book absolutely up to date.) A longer case study provides an ambitious example of enterprise Oracle at work. This Customer Relationship Management (CRM) system (with support for call centers) demonstrates a true n-tiered architecture built around Oracle.
For developers and IT managers alike, this authoritative tour on the best of the Oracle platform is really a must-have for anyone serious about development. It proves not only that Oracle is a great database platform, but also that it’s ready to run the entire enterprise through powerful Internet and component-based tools. –Richard Dragan
Topics covered:
- History of Oracle
- Introduction to PL/SQL
- Overview of Oracle tools (including Forms, Reports, Portal, Designer, Oracle 8i, and JDeveloper)
- SQLJ and JavaServer Pages (JSP)
- Enterprise JavaBeans on the Oracle platform
- XML support in Oracle
- Enterprise Application Design (EAD) and n-tiered architectures on the Oracle platform
- Oracle database fundamentals (including data dictionaries, indices, and object/relational design)
- Oracle Net8 for scalability
- Designer 6i (case study for an online course-registration database)
- PL/SQL tutorial (including PL/SQL Server Pages and the Web Toolkit for Web programming)
- Case study for an online stock-tracker application
- Java stored procedures
- JDBC tutorial (including APIs, binary fields, connection pooling, and caching)
- SQLJ tutorial
- Introduction to EJB
- Oracle performance tuning
- Oracle Business Components for Java (BC4J)
- Case study for a discussion database using PL/SQL and Java
- Search engines with Oracle interMedia
- XML fundamentals and Oracle
- Case study for a Customer Relationship Management (CRM) enterprise system
- The Simple Object Access Protocol (SOAP)
Professional Oracle 8i Application Programming with Java, PL/SQL and XML




