Database Introduction
This two-day instructor-led course is focused on beginners in database area. It provides the knowledge needed for the design and modelling of databases, independent on database platform. Graduates will get acquainted with the procedure of relational database design and analysis, normalization, by designing ER database diagrams, an implementation of databases and SQL basics.
Accredited course for Continuing Education of Pedagogical Staff
Course length: 2 days (8:30 - 16:00)
List price: 8 900 CZK (without VAT)
This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.
-
Students will be able to
- Database design concepts
- Design the relational and analytical database
- Database diagrams modelling and use common ER database tools
- Perform normalization
- Implement the database model into a physical database model
- Basics of SQL
-
Course requirements
- No prerequisites
-
This course is intended for
- Developers and database designers
- Database administrators
-
Literature
All participants will get OKsystem materials.
-
Hardware
Classrooms are equipped with performing computers with Internet access, including wireless access.
-
Syllabus
Chapter 1: Basic concepts
Chapter 2: Relation database design
- Database design
- ER Diagramms
- Normalization
- Database models
- Implementation
Chapter 3: Analytics database design
- Basic concepts
- Design
- Implementation
Chapter 4: SQL Language
- DDL syntax
- DML syntax
Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.