Databases

Databases - Introduction

Database planning guide

Developed by: CompuMentor Type of resource: MS Word document Target audience: General Cost: Free access

This guide from CompuMentor is designed to help small and medium-sized nonprofit organizations develop a database plan and purchase or build a database that meets their needs. The guide includes planning worksheets and tools for evaluating different database products.

 

Dhttp://www.techsoup.org/products/downdetails.cfm?downloadid=67  


Free Access Tutorial

Developed by: BrainBell Type of resource: web guide Target audience: General Cost: Free access

This series of nine web-based tutorials covers the basics of using Microsoft Access, including understanding what a database is, developing queries, working with forms and formulating reports and macros. Each tutorial covers a series of specific topics and ends with a review of content and a quiz to test your knowledge. Though there is no download option or printer-friendly version, the tutorial´s clear writing makes the clicking worthwhile.  

Dhttp://www.brainbell.com/tutorials/ms-office/Access_2003/  


Introduction to Databases and MS Access

Developed by: APC Type of resource: MS Word files Target audience: General, Trainers Cost: Free access

This workshop kit for trainers includes an introduction to databases and MS Access. Part of the Multimedia Training Kit.

Dhttp://www.itrainonline.org/itrainonline/mmtk/databases.shtml  


OpenICDL

Developed by: Go-Open Campaign / ICDL Foundation Africa Type of resource: Web site Target audience: General Cost: Free access

"OpenICDL is an open source project that aims to develop and maintain a Free/Open Source version of the training materials used to ready students for the International Computer Driving License certification.\" Materials cover Basic Concepts of IT, Using a Computer and Managing Files (K Desktop Environment), Word Processing (OpenOffice.org Writer), Spreadsheets (OpenOffice.org Calc), Databases (OpenOffice DB), Presentations (OpenOffice.org Impress) and Information and Communications (Mozilla 1.4 and Ximian Evolution 1.4). Materials are available in HTML and PDF versions.

Dhttp://icdl.tsf.org.za/courseware.html


Databases - Choosing a database

Choosing a Database System that Works for You

Developed by: TechSoup Type of resource: Web article Target audience: General Cost: Free access

Short article by Michelle Murrain looking at options for membership databases for non-profits.

Dhttp://www.techsoup.org/articlepage.cfm?ArticleId=261&topicid=6  


A review of open source content management systems

Developed by: Open Advantage / Elliot Smith Type of resource: web site Target audience: General Cost: Free access

Open Advantage's Elliot Smith evaluated six content management systems (Drupal, Exponent CMS, Lenya, Mambo, Plone and Silva) at length. Rather than comparing features for each system, he opted to take a web developer's point of view and examined system flexibility from four vantage points: the default installation capabilities and features; additional features available and ease of installation for such features; template flexibility allowing for easy changes in the look and feel of a site; and "elegant" code - code that may have design patterns for future modular development and is well-commented. The resulting evaluations are quite detailed, and readers will have a clear view of capabilities, which CMS is suited for which "type" of site, and a contrasting of strengths and weaknesses of the different systems.

Dhttp://www.openadvantage.org/articles/oadocument.2005-04-19.0329097790  


20 Point CMS Test

Developed by: Open Advantage / Elliot Smith Type of resource: web site Target audience: General Cost: Free access

This test was developed by Elliot Smith of Open Advantage in order to carry out a systematic evaluation for content management systems. However, the 20 tasks laid out in the test are a useful resource on their own, because they allow website developers to consider different aspects of CMS flexibility, including areas that frequently are unexplored until the site grows: for example, how easy is it for users to self-register, the ability to restrict access to different information types, testing roll-back or reinstalls, easy construction and determination of within-site links, accessible event archiving, making printed versions from dynamic pages, and if site appearance can be changed via cascading style sheets. A useful tool for anyone contemplating an interactive website.

Dhttp://www.openadvantage.org/articles/oadocument.2005-04-20.2420944763  


Open Source CMS

Developed by: Open Source CMS Type of resource: web site Target audience: General Cost: Free access

As it states, this site encourages you "try before you install" by allowing administrator access to multiple PHP-based free and open source software content management systems, in their default installations. The long list of installations to choose from includes what the site terms as "portal" CMS such as Drupal, Joomla, Civic Space, PostNuke (and dozens more) as well as blogs, wikis, e-learning, e-commerce and group ware systems. To see which system best suits your needs, you can explore the look and feel of the CMS backend for two hours, before the systems are automatically reinstalled. The site includes forums for each CMS as well as FAQ's.

Dhttp://www.opensourcecms.com/


Databases - Building a database site

Database-Driven Web Sites

Developed by: TechSoup Type of resource: Web articles Target audience: General Cost: Free access

New TechSoup article

Dhttp://www.techsoup.org/articlepage.cfm?ArticleId=371&topicid=6  


Planning a Database-Driven Web Site

Developed by: Tech Soup Type of resource: website Target audience: General Cost: Free access

This article offers the steps you need to follow to go from the idea of a database-driven Web site to actual design, development, and implementation, in step-by-step format.

Dhttp://www.techsoup.org/howto/articlepage.cfm?ArticleId=375&topicid=13  


Databases - Content management systems

Commissioning an open source content management system

Developed by: Steve Cowie Type of resource: Web article Target audience: General Cost: Free access

Steve Cowie looks at key issues to take into account when adopting an open source content management system, and offers an overview of some of the most popular systems.

Dhttp://www.icthubknowledgebase.org.uk/commissioninganopensourcecms  


Comparing Open Source CMSes: Joomla, Drupal and Plone

Developed by: idealware Type of resource: Web article Target audience: General Cost: Free access

"Open source content management systems can make creating and managing your website a lot easier - and there's no licensing fee involved. But which should you use? We look carefully at Joomla, Drupal, and Plone to compare their strengths and weaknesses."

Dhttp://www.idealware.org/articles/joomla_drupal_plone.php  


Content Management Problems and Open Source Solutions

Developed by: Optaros Type of resource: PDF Target audience: General Cost: Free access

This white paper explores content management systems (CMS) available from the open source community to fulfill a variety of information scenarios: the online brochure, the news periodical, collaborative spaces, wikis, and online communities. The paper also examines support solutions and why one would want to chose an open source CMS. One big advantage of open source CMS is that the offer the opportunity to deliver tailored content management solutions without the high licensing or management fees associated with commercially-licensed or hosted software. This paper from Optaros White Papers and Reports, available in PDF format, provides an excellent basis for choosing the most appropriate CMS for your needs.
 

Dhttp://www.optaros.com/pdf/optaros_cmsReport_012206_sgg.pdf  


Drupal

Developed by: Drupal Type of resource: Software tool Target audience: General Cost: Free access

Drupal is an open-source platform and content management system for building dynamic web sites offering a broad range of features and services including user administration, publishing workflow, discussion capabilities, news aggregation, metadata functionalities using controlled vocabularies and XML publishing for content sharing purposes.

Dhttp://drupal.org/project/drupal


Editor's choice: Step Two Content Management Articles

Developed by: Step Two Type of resource: Web site Target audience: General Cost: Free access

Articles from Step Two Designs on topics relating to content management. While not specifically aimed at the NGO sector, these short articles will be of use to those new to content management, as well as to more experienced users.

Dhttp://www.steptwo.com.au/papers/index.php?subject=cm  


ActionApps

Developed by: APC Type of resource: Content management software Target audience: General Cost: Free access

The ItrainOnline site is driven by ActionApps, an OpenSource content management system developed by APC.

Dhttp://www.apc.org/actionapps/english/


ActionApps Admin Training

Developed by: APC Type of resource: MS Word document Target audience: Trainers Cost: Free access

Guide by Anna Feldman aimed at trainers who running workshops on ActionApps administration.

Download D


Back-End - A Bilingual Content Management System

Developed by: OpenConcept Consulting Type of resource: Open Source content management software Target audience: General Cost: Free access

Back-End is a bilingual, open source CMS built on the PHP scripting language and the MySQL database. Back-End is particularly aimed at advocacy organisations, and includes a suite of tools that allow you to create and manage polls and petitions.

Dhttp://www.back-end.org/


How to Evaluate a Content Management System

Developed by: Step Two Designs / James Robertson Type of resource: web site Target audience: General Cost: Free access

A comprehensive document from Step Two Designs detailing all angles of content management considerations: technical specifications, authoring needs, content management, publication and presentation, and more. The article does not suggest a particular CMS, and is written for organisations or businesses who might be hiring a developer or vendor for their specific CMS needs. It's objective is to help organisations assess CMS needs in a systematic way, before approaching vendors or adopting a system that will not grow with them, or does not prioritise the content creation needs.

Dhttp://www.steptwo.com.au/papers/kmc_evaluate/


Databases - General

EcoLegis: Cross-cultural Collaboration and Dealing with Databases

Developed by: FARN Type of resource: Web case study Target audience: General Cost: Free access

The EcoLegis environmental legal access facility is the result of a cooperative effort between FARN in Argentina and REC in Hungary. Both organizations had legal databases that they had been developing on an ongoing basis since 1993 for FARN and 1995 for REC. While several similarities and positive differences existed to make the project viable, a certain amount of collaboration was needed to launch an integrated project online.

Dhttp://www.sdcn.org/webworks/cases/database_farn1.htm  


Managing Information Using Databases

Developed by: AWORC Type of resource: MS Word and PowerPoint files. Target audience: Trainers, General, Women Cost: Free access

Materials from the Asian Women's Resource Exchange's 2001 WENT training course. Modules consist of handout and PowerPoint presentations on topics including database concepts, the database development cycle, developing database specifications and Web-database integration.

Dhttp://www.aworc.org/went2001/tracks/t3.html

Сачак (Ламперия) http://www.emsien3.com/sachak от ЕМСИЕН-3
Дюшеме http://www.emsien3.com/дюшеме от EMSIEN-3