Home Books Ebooks Database-books Database books Page1
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

Database books Page1

Advertisement
The Structured Query Language is used in manipulating data stored in Relational Database Management Systems

Database books Page1

     

  1. The SQL Tutorial
    The Structured Query Language is used in manipulating data stored in Relational Database Management Systems (RDBMS). SQL provides commands through which data can be extracted, sorted, updated, deleted and inserted. SQL has the full support of ANSI (American National Standards Institute), which has laid down certain rules for the language. SQL can be used with any RDBMS such as MySQL, mSQL, PostgresSQL, Oracle, Microsoft SQL Server, Access, Sybase, Ingres etc. All the important and common SQL statements are supported by these RDBMS, however, each has its own set of proprietary statements and extensions.
      
  2. The APNIC Who is Database
    APNIC maintains of a database of IP address and AS number allocations in the Asia Pacific region. The APNIC Who is Database is a publicly searchable database that contains records of numeric Internet resources from the ranges administered by APNIC in the Asia Pacific region, specifically:
    * IP address space allocations and assignments  * AS numbers (ASNs) 
    Each record contains a number of different objects which describe things such as people, IP address allocations, AS numbers, and domains (for reverse delegations). Objects can make reference to other objects. For example, the IP address allocation object, called inetnum, makes reference to person and maintainer objects.
     
  3. The fundamental of database
    Databases are designed to offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables. If you?re familiar with spreadsheets like Microsoft Excel, you?re probably already accustomed to storing data in tabular form. It?s not much of a stretch to make the leap from spreadsheets to databases. Let?s take a look.  Just like Excel tables, database tables consist of columns and rows. Each column contains a different type of attribute and each row corresponds to a single record. For example, imagine that we were building a database table that contained names and telephone numbers. 
      
  4. The transact-SQL user Guide 
    This book is a complete guide to Transact-SQL. It contains an introductory chapter which gives an overview of SQL. The remaining chapters are divided into two main parts: Basic Topics and Advanced Topics. Describes the naming conventions used by SQL and the enhancements added by Transact-SQL. It also includes a description of how to get started with Transact-SQL using the isql utility. All users should read this chapter, because it prepares you for the other chapters. These chapters introduce you to the basic functionality of SQL. Users new to SQL should become familiar with the concepts described in these chapters before moving on to Part 2. Experienced users of SQL may want to skim through these chapters to learn about the several Transact-SQL extensions introduced there, and to review the material.
Advertisements

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: April 3, 2006

Ask Questions?    Discuss: Database books Page1  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com