Database Workbench is a powerful software for creating database type IDE. It supports basic formats: Interbase, SQL Server, Firebird, MySQL, Oracle, etc.. The application offers tools such as a visual table editor, a tester base and much more. The software is a shareware .
Introduction - Databases ShowWhat is a database?
A database (abbreviated DB) is an entity in which data can be stored in a structured manner, with as little redundancy as possible. Different programs and different users must be able to use this data. Therefore, the concept of...
Databases - Using forms ShowUsing forms
In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or...
Database administrator ShowDatabase administrator
A database administrator (or DBA for short) is in charge of maintaining and operating the databases which form a company's information system. Skills
Given the critical nature of the data he/she is in charge of, the...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel
Below is a tips of how to connect an Access database (MDB) in an application excel
Add reference
Microsoft DAO object librairy X.X
In a general module (eg Module1) paste the code below...
Backup/Restore Mysql database ShowBackup/Restore Mysql database
Backup
Restore your database
Note
A simple approach on how to backup and restore MySQL databases.
Backup
To save an existing database it is recommended that you create a dump.
To dump all...
Display name of the Oracle database ShowDisplay name of the Oracle database
To view the name of the Oracle databases and data related to them, simply run the command:
SELECT * FROM V$DATABASE;
Download Database Editor ShowThe database management is a complex task, for the experimented users in general. For a specific task, specific tools are needed.
Database editor is a tool allowing fast and easy access to any sorts of database. It will help database developers and...
DBMS models ShowThe various database models
Databases appeared in the late 1960s, at a time when the need for a flexible information management system had arisen. There are five models of DBMS, which are distinguished based on how they represent the data...
Database Replication ShowIntroduction to Replication
Replication consists in ensuring data availability by synchronising copies of a data source on different servers.
Replication is mainly used for database management systems that manage thousands or even millions of...