Cursos de Delphi - Programação Orientada a Objetos

Curso Delphi - POO (Delphi Course - OOP)

Learning Object Oriented Programming with Delphi

Delphi - Manipulando BDE Alias (Manipulating BDE Aliases)

Manipulando Alias da BDE direto do código.

http://delphi.about.com/od/dbbde/a/bdealiases.htm


Alternativa 2 - Lendo parâmetros de arquivo de configuração .ini

procedure TFPrincipal.SQLConnection1BeforeConnect(Sender: TObject);
var ConfigIni: TIniFile;
begin
//Seta as propriedades da conexão em tempo de execução pegando os dados do arquivo config.ini
ConfigIni := TIniFile.Create(ExtractFilePath(ParamStr(0)) + 'Config.ini');
SQLConnection1.Params.Values['Database']:= ConfigIni.ReadString('CONFIG', 'DATABASE', '');
SQLConnection1.Params.Values['User_Name']:= ConfigIni.ReadString('CONFIG', 'USERNAME', '');
SQLConnection1.Params.Values['Password']:= ConfigIni.ReadString('CONFIG', 'PASSWORD', '');
SQLConnection1.Params.Values['ServerCharSet']:= 'DOS860';
ConfigIni.Free;
end;

Sql Sintaxe (syntax)

Referência rápida a sintaxe das clausulas SQL. Acesse o link no fim do post para informações mais detalhadas.

Select Statement
SELECT "column_name" FROM "table_name"

Where
SELECT "column_name"
FROM "table_name"
WHERE "condition"

Between
SELECT "column_name"
FROM "table_name"
WHERE "column_name" BETWEEN 'value1' AND 'value2'

Like
SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE '%PEDACO_DA_PALAVRA%'

Order By
SELECT "column_name"
FROM "table_name"
[WHERE "condition"]
ORDER BY "column_name" [ASC, DESC]

Group By
SELECT "column_name1", SUM("column_name2")
FROM "table_name"
GROUP BY "column_name1"

Insert Into Statement
INSERT INTO "table_name" ("column1", "column2", ...)
VALUES ("value1", "value2", ...)

Update Statement
UPDATE "table_name"
SET "column_1" = [new value]
WHERE {condition}

Delete From Statement
DELETE FROM "table_name"
WHERE {condition}

Fonte: http://www.1keydata.com/sql/sql-syntax.html