Search

Databases I

Field	Work language	Acad. cycle	ECTS credits	Semester	Course code
Computer Sciences	LV ENG	Bachelor	6	Autumn	DatZ2003

Subject Aim

To provide knowledge and understanding of databases, database management systems operating framework, database technology and SQL language. To acquire skills in administration and usage of database management system, database design and SQL query building.

Subject Content

The course aims to provide knowledge and understanding of databases, database management systems and the SQL language.
Acquired skills in database design, SQL query design and database management system administration.

Expected Results

After the acquisition of the course students will:

·      be able to analyze and select the most appropriate database management system (DBMS) for database development,

·      be able to perform database design and implement it with chosen DBMS,

·      be able to create SQL queries,

·      be able to use database technology,

·      be able to install and configure Microsoft SQL and MySQL DBMS,

·      be able to administer users in DBMS system,

·      be able to administer access right in DVBS system,

·      be able to perform data indexing for new and existing database,

·      be able to perform database maintenance and administration,

·      be able to perform database table maintenance and administration

Requirements to gain ECTS

Exam

Successfully passed test. Successfully passed final test and all the practical tasks are fulfilled.