Oracle: Programming Languages SQL and PL/SQL
BASIC DATA
course listing
A - main register
course code
ICA0016
course title in Estonian
Oracle: programmeerimiskeeled SQL ja PL/SQL
course title in English
Oracle: Programming Languages SQL and PL/SQL
course volume CP
-
ECTS credits
3.00
to be declared
yes
fully online course
not
assessment form
Pass/fail assessment
teaching semester
autumn - spring
language of instruction
Estonian
English
Study programmes that contain the course
Structural units teaching the course
IC - IT College
Timetable link
Version:
VERSION SPECIFIC DATA
course aims in Estonian
Kursuse eesmärgiks on päringukeele SQL ja programmeerimiskeele PL/SQL tutvustamine üliõpilastele nii et nad oleksid võimelised sooritama vastavat kvalifikatsioonieksamit ning looma rakendusi Oracle’i andmebaaside juhtimise süsteemis.
course aims in English
Introduction into Query language SQL and PL/SQL on the level of qualification exams; the students are able to create applications on Oracle database management system.
learning outcomes in the course in Est.
Üliõpilane
* tunneb SQL ja PL/SQL põhilauseid ja programmeerimiskeelt;
* suudab kasutada neid keeli andmebaasisüsteemide loomisel ja haldamisel, samuti andmebaasirakenduste loomisel.
* tunneb SQL ja PL/SQL põhilauseid ja programmeerimiskeelt;
* suudab kasutada neid keeli andmebaasisüsteemide loomisel ja haldamisel, samuti andmebaasirakenduste loomisel.
learning outcomes in the course in Eng.
The student
* Understands the main statements and programming languages SQL and PL/SQL;
* Is able to apply these languages by creating and managing the databases and database applications.
* Understands the main statements and programming languages SQL and PL/SQL;
* Is able to apply these languages by creating and managing the databases and database applications.
brief description of the course in Estonian
Päringud relatsioonilises andmebaasis. Päringud andmesõnastikust. Päringud seotud tabelitest. Andmete muutmine tabelites ja andmebaasi transaktsioonid. Andmebaasi objektid. PL/SQL-keele kasutamine ja selle põhikonstruktsioonid.
brief description of the course in English
Queries in relational databases. Queries from data dictionary. Queries from related tables. Updating data in tables and database transactions. Database objects. Using PL/SQL language and its main structures.
type of assessment in Estonian
-
type of assessment in English
-
independent study in Estonian
-
independent study in English
-
study literature
Oracle Help Center, https://docs.oracle.com/en/
Moodle: https://moodle.taltech.ee/course/view.php?id=4296
Moodle: https://moodle.taltech.ee/course/view.php?id=4296
study forms and load
daytime study: weekly hours
2.0
session-based study work load (in a semester):
lectures
0.0
lectures
0.0
practices
2.0
practices
10.0
exercises
0.0
exercises
0.0
lecturer in charge
-
LECTURER SYLLABUS INFO
semester of studies
teaching lecturer / unit
language of instruction
Extended syllabus
2025/2026 autumn
Toomas Lepikult, IC - IT College
Estonian