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

All of the tutorials we’ve examined so far have used a tiered architecture consisting of presentation, Business Logic, and Data Access layers. The Data Access Layer (DAL) was crafted in the first tutorial (Creating a Data Access Layer) and the Business Logic Layer in the second (Creating a Business Logic Layer). Starting with the Displaying Data With the ObjectDataSource tutorial, we saw how to use ASP.NET 2.0’s new ObjectDataSource control to declaratively interface with the architecture from the presentation layer.
Read the rest of this entry »

• 0 Comments

The Maypole web application framework can be used on two levels: first, as a simple way to add an interface to a database (and not much else besides), and second, as a toolkit for building more sophisticated web applications. In principle, there is a continuum of possible usages between these two levels, but it seems best for the purposes of teaching to entirely separate them.
Read the rest of this entry »

• 0 Comments

This tutorial shows a simple example using Hibernate. We will create a simple Java application, showing how Hibernate works. Hibernate is a solution for object relational mapping and a persistence management solution or persistent layer. This is probably not understandable for anybody learning Hibernate.
Read the rest of this entry »

• 0 Comments

SQL - Structured Query Language
Structured Query Language, is a computer language designed for retrieval and management of data in relational database management systems database schema creation and modification database object access control management.
History:
The first version of SQL was developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. Standardized in 1986 by ANSI. Subsequent versions of the SQL standard have been released as ISO standards
Read the rest of this entry »

• 0 Comments

MySQL is an open source relational database management system which is quite popular for light-weight web applications. Over the last few years, the product has also added some features which allow it to be used for larger business tools. This paper will provide an overview of this software on Windows. MySQL does not have as many features as PostgreSQL, and while many of the more advanced features are not as mature. However one would expect it to perform substantially better than PostgreSQL on Windows because of its thread-based architecture (PostgreSQL uses a process-based architecture instead).
Read the rest of this entry »

• 0 Comments