SubjectsSubjects(version: 945)
Course, academic year 2023/2024
   Login via CAS
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.
Incompatibility : MD360P44
Is incompatible with: MD360P44
Opinion survey results   Examination dates   Schedule   
Annotation -
Last update: Ing. Jaroslav Kraus, Ph.D. (09.11.2014)
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.
Literature -
Last update: Ing. Jaroslav Kraus, Ph.D. (09.11.2014)

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:

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

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.

Charles University | Information system of Charles University |