Category: SQL

New Video – Learning SQL with SQLite

An essential skill … If there is one programming language that I would recommend for everyone, it’s Structured Query Language (SQL). SQL (often pronounced “sequel”) is the main language used to communicate with databases including Oracle, SQL Server and Microsoft Access. It’s the set of commands used to write and retrieve data. If you work […]

Calculated Fields in CiviCRM

One of CiviCRM’s strengths is the ability to add custom fields to hold specific information about your contacts. One thing it doesn’t offer (yet) is a calculated field type that will present the results of calculations of other fields.  While calculated fields are generally discouraged in relational database design, they are sometimes necessary within a […]

Importing Case Data into CiviCase

Migrating to CiviCase On a recent project, I setup CiviCRM and CiviCase to enable a local organization to better manage its client database. The old database had been developed in Borland Paradox and was quickly becoming unusable. As a free and open source solution, CiviCRM turned out to be just the solution needed to accommodate this […]