Databases Build and Exploitation 223061-D
Laboratorium (LAB) Semestr letni 2019/20

Relational and object relational Database Management Systems, ERD Model, Set up tables, retrieving data using SQL SELECT statement.

Restricting and sorting data, single-row functions.

Reporting aggregated data using the group functions.

Displaying data from multiple tables.

Using subqueries to solve queries, using the set operators.

Manipulating data, Using DDL Statements.

Creating other schema objects.

Managing objects with data dictionary views.

Controlling user access, manage schema objects.

Manipulating large data sets.

Generating reports by grouping related data.

Managing data in different time zones.

Retrieving data using advanced subqueries.

Hierarchical retrieval.

Regular Expression suport.