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.
Code
DB-FND
Course length
2
days
(8:30 – 16:00)
Form
In our classroom or online
Dates
List price: 8 900 CZK (without VAT)
Are you interested in scheduling a term? Need some advice?
Do not hesitate to contact us. We are at your disposal and will be happy to help you.
This course is intended for
- Developers and database designers
- Database administrators
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
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
Hardware
Classrooms are equipped with performing computers with Internet access, including wireless access.
Literature
All participants will get OKsystem materials.
Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.
Similar courses
Take a look at some similar courses from our wide range.
Fundamentals of SQL Language for Users SQL-Jazyk 0
Writing Queries Using SQL SQL-Jazyk 1
Developing SQL Databases DB-DEV
Why OKškolení?
What are the main advantages of our training centre?
36+ years in business
We have been on the market for more than 36 years and have a wealth of experience in this field.
We are a training center with a rich history and tradition.
Experienced tutors
The basis of any quality education is good and experienced lecturers and this is something that we at OKškolení take particular pride in. Our top lecturers are waiting for you.
Modern classrooms
All classrooms are spacious, air-conditioned, barrier-free and equipped with high-standard computers, with Wi-Fi connection.
Bonus program
Protect your investments into education, loyalty program, advantageous offers, refreshments, grants...
Contact us
Do not hesitate to contact us with any questions you may have.
Do you need to know more about us or would you prefer to contact us using the form?
