Everybody who wants to install a web server database but does not know which software is necessary and how it is installed should benefit from reading this text. This text provides all information necessary to get a SQL database for a web server going; it does not go into any detail of CGI programming, nor does it explain the SQL database language. Excellent books are available on both topics, and it is the intention of this text to provide a working platform based on which a user can then study CGI programming and SQL. For getting a small scale SQL system running (not the notorious example of a major airline booking system, or space mission management database) it will be sufficient to have the software described in this text and the documentation accompanying it. The user manual of msql (a database introduced in this text) provides sufficient information on SQL for building your own database.
Read the rest of this entry »

• 0 Comments

The Oracle Academy’s Hosted Database offering provides web-enabled access to an Oracle database for schools that have experienced IT staff to teach database fundamentals using their own curriculum. Using Oracle’s HTML DB web interface, schools harness the power of the Oracle database to teach students relational database concepts. Because this service is hosted by Oracle, there is no need to install or maintain any hardware or software.
Read the rest of this entry »

• 0 Comments

Microsoft Access 2003 is a powerful, yet easy to learn, relational database application for Microsoft Windows. This tutorial is designed for users who are new or only have little experience using Access 2003. It introduces fundamental database concepts and operations and illustrates how they are performed in Microsoft Access 2003. This tutorial does not cover all of the features and functions of Microsoft Access 2003; emphasis will be on basic and frequently-used features, such as the creation of tables and queries, or importing spreadsheet into Access.
Read the rest of this entry »

• 0 Comments

The purpose of these tutorials is not to teach you Microsoft Access, but rather to teach you some generic information systems concepts and skills using Access. Of course, as a side effect, you will learn a great deal about the software enough to write your own useful applications. However, keep in mind that Access is an enormously complex, nearly- industrial-strength software development environ- ment. The material here only scrapes the surface of Access development and database programming.
Read the rest of this entry »

• 0 Comments

Basic Database Terminology Many relational database concepts are really quite simple. In fact, much of the appeal of relational databases stems from the simplicity of their foundational concepts. Structural Terminology Within the database world, MySQL is classified as a relational database management system (RDBMS). That phrase breaks down as follows:
• The database (the “DB” in RDBMS) is the repository for the information you want to store, structured in a simple, regular fashion: o The collection of data in a database is organized into tables. o Each table is organized into rows and columns. o Each row in a table is a record. o Records can contain several pieces of information; each column in a table corresponds to one of those pieces.
Read the rest of this entry »

• 0 Comments