Relational Databases for Demographers - MD360P44N
Title: Relační databáze pro demografy
Czech title: Relační databáze pro demografy
Guaranteed by: Department of Demography and Geodemography (31-360)
Faculty: Faculty of Science
Actual: from 2019
Semester: winter
E-Credits: 3
Examination process: winter s.:combined
Hours per week, examination: winter s.:1/1, Ex [HT]
Capacity: unlimited
Min. number of students: unlimited
4EU+: no
Virtual mobility / capacity: no
State of the course: cancelled
Language: Czech
Level: specialized
Is provided by: MD360P44
Note: enabled for web enrollment
Guarantor: Ing. Jaroslav Kraus, Ph.D.
Teacher(s): Mgr. Ondřej Nývlt, Ph.D.
Incompatibility : MD360P44
Is incompatible with: MD360P44
Opinion survey results   Examination dates   Schedule   
Annotation -
The aim is to get elemental information about relational databases, to work as a client and to process basic user-defined queries, based on SAS environment.
Last update: Kraus Jaroslav, Ing., Ph.D. (09.11.2014)
Literature -

Databázové systémy a jejich použití v informačních systémech, Pokorný J., Academia, 1992
Vytváříme relační db aplikace, Riordan R., CPress

SAS® 9.4 SQL Procedure - User’s Guide:

http://support.sas.com/documentation/cdl/en/sqlproc/65065/HTML/default/viewer.htm#titlepage.htm

Last update: Kraus Jaroslav, Ing., Ph.D. (09.11.2014)
Syllabus -

Introduction into relational database
Database objects
Working with data in RDBMS
Introduction into SAS/SQL
Structured Query Language, SAS Functions
Basic Queries
Overview of the SQL Procedure, Specifying Columns, Summarizing Data, Subqueries
Combining Tables
Joins, Complex Joins, Set Operators
Creating and Modifying Tables and Views
Creating Tables, Creating Views, Creating Indexes
Additional SQL Features
Setting PROC SQL Options, Dictionary Tables and Views

The course is ended with written exam.

Last update: Kraus Jaroslav, Ing., Ph.D. (10.11.2014)