Database Systems I

See semester study programme.

Presentation of Oracle relational database environment. Basic SQL commands and their implementation in Oracle Database Management System 12c. Data selection and other data manipulation language commands. Creating database objects

SQL as 4GL, standard language for relational databases. Schemas, metadata, database dictionary. Data security and confidentiality. User's privilliges.

Literatura podstawowa:

J. Price Oracle Database 12c.SQL Oracle Press, 2015

Literatura uzupełniająca:

Database Systems. The complete book (2nd edition), H. Garcia-Molina, J. Ullman, J. Widom, 2008.

Wiedza:

is able to indicate, propose command apropriated to user's business task

is able to describe rules of relational database structure

and to describe tasks of relational database management system.

is able to present basic SQL commands and to diffirentiate SQL commands from environmental

knows how to define, diffirentiate database objects and indicate metadata resources

Umiejętności:

is able to use Relational Database Management System.

is able to make use of SQL commands and environmental commands

is able to solve problems when error occurs

is able to control modification results and user's object state

Kompetencje społeczne:

is able to analyze formulated business problem and transform it into SQL statement.

is able to find dependencies between data stored in database tables and associate them with real world business dependencies

knows how to Interpret error and warning messages which are necessary for later test plans construction

egzamin testowy: 90.00%

ocena z ćwiczeń: 10.00%