Subjects

Your browser does not support JavaScript, or its support is disabled. Some features may not be available.

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:

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

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.