Download Free Computer Ebooks - NET BOOKS

Designing SQL Server 2000 Databases for Net Enterprise Servers

Posted by bandr under Database

Designing SQL Server 2000 Databases for Net Enterprise Servers

Book Description
A major software release, SQL 2000 is tailor-made for the multitude of programmers working in the Windows 2000 Active Directory environment, which allows administrators and others to manage and share data. This thorough guide is written for users switching from SQL 7 under Windows NT, as well as those starting from scratch. Clear, concise, and packed with examples, it includes: A migration-path chapter for users who are upgrading; configuration techniques using new data warehousing and XML capacities; case studies depicting large-scale deployments of applications and databases built with SQL 2000; a “fast-track” chapter at the end summarizing the entire book; a “secrets” appendix giving information on the least-known, but most powerful features of Microsoft SQL Server 2000; detailing new features of Windows and SQL 2000 and designed for easy reference, this is the professional’s step-by-step, fully illustrated introduction to an exciting new data management system.

Oracle Distributed Systems

Posted by IDM under Database

Oracle Distributed Systems

Book Description
Any organization that uses the Oracle relational database management system (RDBMS) these days needs to use multiple databases. There are many reasons to use more than a single database in a distributed database system:

• Different databases may be associated with particular business functions, such as manufacturing or human resources.
• Databases may be aligned with geographical boundaries, such as a behemoth database at a headquarters site and smaller databases at regional offices.
• Two different databases may be required to access the same data in different ways, such as an order entry database whose transactions are aggregated and analyzed in a data warehouse.
• A busy Internet commerce site may create multiple copies of the same database to attain horizontal scalability.
• A copy of a production database may be created to serve as a development test bed.

Oracle 11i System Administrator Fundamentals Ed 3 D14411GC30

Posted by IDM under Database

What you will learn:
In this course students learn concepts and functions that are critical to the System Administrator role. Students learn information useful for implementing and managing the 11i E-Business Suite. Tasks covered include setting up security and user management, concurrent processing, profiles, and workflows; students also learn how to personalize Oracle E-Business Suite Forms and HTML pages. In addition, students learn how to monitor and audit an E-Business Suite system. The System Administrator Fundamentals course is a part of the Learning Path for Implementation Consultants and provides the foundation needed to effectively control security and ensure smooth operations for an E-Business Suite installation. Demonstrations and hands-on practice reinforce the fundamental concepts.
* Effectively control security
* Monitor and audit applications
* Understand User Management set up
* Utilize profile options to enhance security

Oracle 11i Inventory Management Fundamentals Ed 2 D16356GC20

Posted by IDM under Database

What you will learn:
This class focuses on the features, functions and benefits of the Oracle Inventory application. Students will learn how to set up items, how to use the various inventory controls available, how to do transactions, transfers, and inventory moves, inventory replenishment, cycle counting and physical inventory. Students will also learn where Inventory fits in the overall enterprise structure.
This course reflects the logical flow of the processes involved in inventory management. For example, this course covers defining items, receiving items, issuing items, and replenishing items in the same order. The exercises in this course provide hands-on experience on using Oracle Inventory to perform many of the processing and inquiry transactions such as receiving, moving, replenishing inventory items, and generating count tags for physical inventories. The hands-on exercises also help you understand how to use mobile devices to perform transactions such as cycle counting and inventory replenishment.

Oracle 11i Oracle Payables Fundamentals Ed. 3.2 D16810GC32

Posted by IDM under Database

What you will learn:
In this course, participants learn how to set up and use Oracle Payables to manage the accounts payable process. Participants learn how to manage suppliers, process invoices as well as payments and generate key reports. Participants also learn how to approve invoices for payment, process stop and void payments, setup bank accounts and process payment batches. Finally, the students learn how to close accounts payable periods and transfer accounting details to the general ledger.
Participants will learn how the Payables application fits into Oracle’s e-Business Suite of applications. This is accomplished through a series of tutorials, supplemented with hands-on exercises.
* Describe how the payables process fits into the Oracle eBusiness suite of applications
* Import/Enter invoices and invoice distributions
* Identify Payables integration points
* Apply prepayments and advances
* Define suppliers and supplier sites
* Identify key reports

Oracle 11i Advanced Pricing Fundamentals D17037GC20

Posted by IDM under Database

What you will learn:
Oracle Advanced Pricing supports e-business applications by providing a flexible pricing engine that executes pricing and promotional calculations for Oracle Order Management and other Oracle Applications. Advanced Pricing provides the flexibility to meet the needs of complex pricing situations for a range of industry business requirements including: consumer goods, telecommunications, services, high technology, automotive, and aerospace/defense businesses that sell to other businesses; and, telemarketing, mail order catalog, and web store businesses that sell directly to consumers.
In this course, students learn about the following Advanced Pricing features and concepts: generic setup steps, pricing security, qualifiers, modifiers, price lists, formulas, modifiers, attribute management, and troubleshooting.
* Set up and use price lists with pricing lines to define item and/or item category prices.
* Learn how to use modifiers to set up price adjustments (for example, discounts and surcharges), benefits (for example, free goods, coupons) and freight and special charges.