Plan dvuhnedel'nogo kursa po SUBD INFORMIX.
---------------------------------------------------------------
Predpolagaetsya 10 uchebnyh dnej iz rascheta:
po 4 chasa v den' lekcii
ostal'noe vremya - vyhod na mashinu, prakticheskaya rabota.
---------------------------------------------------------------
---------------------------------------------------------------
Dlya obucheniya INFORMIX ispol'zuyutsya dve pachki listochkov. Predpo-
lagaetsya chitat' "lekcii", parallel'no sveryayas' s sootvetstvuyu-
shchimi razdelami "shpargalok", soderzhashchimi polnyj format sintaksi-
sa yazyka.
Pervaya pachka: "SHpargalki po INFORMIH" s sintaksisom operatorov.
** 4GL Format operatorov h4gl
** 4GL Funkcii h4fi
** 4GL |krannye formy h4per
** 4GL Format otchetov h4rer
4GL OTLADCHIK h4deb
4GL UTILITY h4util
SQL Format operatorov hsql
SQL |krannye formy hsper
Vtoraya pachka: "Lekcii po INFORMIH" s primerami.
Plan pyatidnevnogo obucheniya schoolplap
Plan dvuhnedel'nogo obucheniya schoolpl10
** Vvedenie v bazy dannyh INFORMIX school0
** Urovni yazykov programmirovaniya BD DBMSrrogrbd
** Lekcii po SQL schoolsql
INFORMIX-4GL za dvadcat' minut h4rtwentu
** Lekcii po INFORMIX-4GL school4gl
** Primer programmy s otchetom schoolrer
** Primer ekrannoj formy schoolper
Rasshireniya fajlov v INFORMIX infext
Upravlyayushchie klavishi i menyu INFOR h4keu
4GL-RDS MAIN MENU h4mm
4GL-Compiler MAIN MENU h4cmm
SQL MAIN MENU hsmm
Spisok dokumentacii po INFORMIX infdocls
Fajly, vhodyashchie v INFORMIX infdir
Nastrojka INFORMIX infnastr
Russkaya sortirovka v INFORMIX russort.dir
Rabota s 132 simvol'nym ekranom 132simw
---------------------------------------------------------------
---------------------------------------------------------------
1 den'.
1. Vvodnaya lekciya po bazam dannyh i INFORMIX:
Osnovnye ob®ekty i ponyatiya mnogopol'zovatel'skih
relyacionnyh baz dannyh.
Klassifikaciya SUBD.
SQL - Strukturnyj YAzyk Zaprosov.
4GL yazyk programmirovaniya baz dannyh INFORMIX.
Obzor semejstva produktov INFORMIX.
2. Organizaciya programmirovaniya v srede INFORMIX:
Rasshireniya fajlov v INFORMIX
Klavishi i menyu v INFORMIX
3. Praktika: vyhod na mashinu.
Rabota s menyu INFORMIX-SQL:
sozdanie bazy, tablic, zanesenie znachenij
Rabota s menyu INFORMIX-4GL RDS:
zakachivanie demonstracionnoj bazy zawod
demonstraciya programmy primer (baza zawod)
Firmennaya demonstracionnaya baza stores. *demo.
Ispol'zuemye materialy:
Vvedenie v bazy dannyh INFORMIX school0
Urovni yazykov programmirovaniya BD DBMSrrogrbd
Rasshireniya fajlov v INFORMIX infext
Klavishi i menyu v INFORMIX h4keu
4GL-RDS Glavnoe Menyu h4mm
4GL-Compiler Glavnoe Menyu h4cmm
INFORMIX-SQL Glavnoe Menyu hsmm
1. Strukturnyj yazyk zaprosov SQL. Razbor sintaksisa vseh opera-
torov.
Soglasheniya o yazyke SQL i nachal'nye ponyatiya.
Tipy dannyh v BD INFORMIX
Vidy operacii nad dannymi.
Sintaksis operatorov yazyka SQL.
- Operatory opisaniya dannyh:
CREATE, DROP, ALTER i dr.
- Operatory manipulyacii dannymi:
INSERT, DELETE, UPDATE i dr.
2. Praktika. Vyhod na mashinu.
Rabota s interpretatorom yazyka SQL INFORMIX-SQL.
Sozdanie bazy dannyh, opisaniya tablic, prostejshih ek-
rannyh form INFORMIX-SQL.
1. - Operatory manipulyacii dannymi:
SELECT
- Operatory zadaniya prav dostupa v baze dannyh:
GRANT / REVOKE , LOCK / UNLOCK , SET LOCK MODE
- Operatory zashchity i vosstanovleniya dannyh.
2. Praktika. Vyhod na mashinu.
Rabota s interpretatorom yazyka SQL INFORMIX-SQL.
Realizaciya zaprosov i manipulyaciya dannymi s pomoshch'yu in-
terpretatora SQL i ekrannyh form INFORMIX-SQL
Ispol'zuemye materialy:
Format operatorov SQL hsql
Lekcii po SQL schoolsql
1. Bystroe vvedenie v yazyk 4GL. Programmirovanie elementarnyh
operacij s bazoj dannyh.
Znakomstvo so sredoj 4GL.
Kratkij obzor vozmozhnostej.
Menyu.
Poisk. Prosmotr, vvod, korrekciya dannyh v tablice
cherez ekrannuyu formu.
Operatory INPUT, DISPLAY, INSERT, UPDATE, DELETE.
Generaciya standartnoj ekrannoj formy.
2. Praktika.
Menyu INFORMIX-4GL RDS, Compiler.
Vvod i otladka razobrannyh na zanyatiyah programm.
Ispol'zuemye materialy:
"INFORMIX-4GL za dvadcat' minut" h4rtwentu
Programma primer rrimer*.4gl
1. YAzyk 4GL. Naznachenie i obshchie soglasheniya o yazyke.
Tipy dannyh.
Identifikatory.
Oblast' dejstviya identifikatorov.
Obzor operatorov yazyka 4GL:
Organizaciya programmy,
- operatory MAIN FUNCTION REPORT
Ob®yavleniya peremennyh
- DEFINE GLOBALS
Prisvoeniya
- LET INITIALIZE
Programmnye
- CALL EXIT GOTO RETURN FOR LABLE CASE WHILE RUN IF
- CONTINUE SLEEP
Perehvat preryvanij
- WHENEVER DEFER
Dinamicheskoe sozdanie operatorov SQL
- PREPARE EXECUTE FREE
Svyaz' mezhdu programmnymi peremennymi i dannymi v tabli-
cah BD. Kursory dlya SELECT i INSERT operatorov:
- DECLARE OPEN FOREACH PUT CLOSE FETCH FLUSH
Operatory ekrannogo obmena.
Upravlenie oknami.
Menyu.
Vyvod ekrannoj formy.
Prostye operatory vvoda vyvoda
- MESSAGE, ERROR, PROMPT
Upravlenie parametrami vvoda vyvoda
- OPTIONS, ATTRIBUTE
2. Vyhod na mashinu. Razbor i programmirovanie primerov
po projdennomu materialu.
1. Vvod vyvod dannyh cherez ekrannye formy
- INPUT, DISPLAY, CONSTRUCT
"Goryachie klyuchi" pri vvode/vyvode.
Vvod vyvod dannyh cherez ekrannye massivy.
- INPUT ARRAY, DISPLAY ARRAY
2. Generaciya ekrannyh form.
Podmenyu FORM glavnogo menyu INFORMIX-4GL.
Format fajla s opisaniem ekrannoj formy.
3. Vstroennye funkcii 4GL
Ispol'zuemye materialy:
Lekcii po INFORMIX-4GL school4gl
Format operatorov 4GL h4gl
Primer ekrannoj formy schoolper
|krannye formy 4GL h4per
Vstroennye funkcii 4GL h4fi
Generaciya otchetov
1. Generaciya i pechat' otchetov.
- operatory START REPORT OUTPUT TO REPORT FINISH REPORT
Format bloka REPORT
2. Vyhod na mashinu.
Sobstvennoe programmirovanie.
Ispol'zuemye materialy:
Format otchetov 4GL h4rer
Primer programmy s otchetom schoolrer
1. Nastrojka INFORMIX
2. Vyzov vseh programm INFORMIX v srede UNIX.
3. Otladchik 4GL.
4. Utility 4GL.
1. Dokumentaciya po INFORMIX.
2. Sostav programnogo produkta INFORMIX.
3. Kratkij obzor ESQL/C, CISAM, QuickStep.
4. Ispol'zovanie vstroennogo HELP po INFORMIX v redaktore RK.
5. Prisoedinenie podprogramm na Si k programmam na 4GL.
6. Rasshirenie vozmozhnostej 4GL. Problemy russkoj sortirovki.
Osobennosti INFORMIX i UNIX na rabochej stancii BESTA 88.
Rezerv.
Last-modified: Wed, 17 Apr 1996 04:41:34 GMT