Learn SQL: earn SQL By topics

Date Added: 7/12/2008 | Visits: 33901

Oracle 9i: Online Free Tutorial

Date Added: 7/11/2008 | Visits: 31852

Data Recovery: Data Recovery is exactly what it sounds like - a way to recover important information that was lost from a computer crash, hard disk malfunction, or virus attack. No matter the scale, big corporation database recovery or single user retrieval of files from spontaneous �deleting�, data recovery is an important and necessary part of any operating system. Data Recovery software can be developed, installed and removed from existing systems to retrieve lost data or partial data and minimize damage caused to the system. The goal of data recovery is perfection, as in, not losing a single byte of infor

Date Added: 7/11/2008 | Visits: 31993

PL SQL: Oracle is probably the most popular enterprise database server at the moment. This is the server that powers eBay on the web and countless data warehouses and VLDBs around the world. Oracle is suited for all applications from OLTP to Data Warehousing.

Date Added: 7/11/2008 | Visits: 31765

Data Warehousing: A data warehouse consists of a computer database responsible for the collection and storage of information for a specific organization. This collection of information is then used to manage information efficiently and analyze the collected data. Although data warehouses vary in overall design, majority of them are subject oriented, meaning that the stored information is connected to objects or events that occur in reality. The data provided by the data warehouse for analysis provides information on a specific subject, rather than the functions of the company and is collected from varying sources into one unit having time-variant.

Date Added: 7/11/2008 | Visits: 32407

Oracle 10g: Online Tutorial

Date Added: 7/11/2008 | Visits: 32756

Data Mining: Data Mining is a complex subject that describes a type of database application used to search large amounts of data for patterns using specific tools. Advanced statistical methods and tools such as classification, association rule mining and cluster analysis search large volumes of data for previously unknown relationships within the data. Data Mining can be used to decipher trends in a wide variety of fields such as computer science, the marketing and advertising of goods, services or products, artificial intelligence research, biological sciences and high-level government intelligence.

Date Added: 7/11/2008 | Visits: 31878

SQL server 2005: Microsoft SQL Server 2005 provides the database developer the opportunity to locate programming code in native formats or create server-driven complex systems. The .NET framework, in combination with the SQL Server 2005, delivers the functionality of the powerful class library in combination with modern programming languages. Common Language Runtime (CLR) is used to code procedures, triggers and functions within the chosen language in the .NET framework. Using object-oriented constructs such as structured exception handling, namespaces, classes and arrays assist the programmer in effectively handling procedural issues when programming with SQL Server 2005.

Date Added: 7/11/2008 | Visits: 33336

Sybase Stored Procedures for the World Wide Web : This guide will attempt to show you how to create stored procedures for the World Wide Web. As I was in the middle of writing this guide, I realized it was about 10 times more lengthy than what I intended. The interface you will be using is slick, writing stored procedures is a snap, and you can do some marvelous things in a very short time. But, there is lots of good information in this guide, and I wanted to be as complete as possible.

Date Added: 7/10/2008 | Visits: 32023

Oracle PL/SQL Language Pocket Reference: The purpose of this pocket reference is to help PL/SQL users find the syntax of specific language elements. It is not a self-contained user guide; basic knowledge of the PL/SQL programming language is required.

Date Added: 7/10/2008 | Visits: 31801