Online
Database Management System (DBMS)
Course Objective: To study the process of processing distributed databases in a DBMS environment.
- Duration
- 50 hours
- Students
- 4
- Language
- Казахский
- Reviews
- 0.0 (0)
course_1/cover.jpg
Certificate
When you finish the course
// About the Course
About the Course
Course Objective: To study the process of processing distributed databases in a DBMS environment.
What you will learn
- 01 Design data warehouses and infological/datalogical DB models.
- 02 Use SQL commands (SELECT, INSERT, UPDATE, DELETE, JOIN) to work with data.
- 03 Ensure security (access rights, backup).
- 04 Create and present real project solutions (ER diagrams, implementation in DBMS).
Curriculum
3 modules-
video Fundamentals of Database Concepts
-
text Types and Structure of Databases
-
video Table, Field/Column, Record/Row, Keys
-
video Primary and Foreign Keys
-
video Relationships between tables
-
video Data Models: Hierarchical, Relational
-
video Comparing Model Types, Giving Examples
-
video Attributes and Relationships
-
video Normalization: 1NF, 2NF, 3NF
-
video Display attributes and tables in the ER diagram
-
video Introduction to SQL Language
-
video Writing/Composing SQL Queries
-
video Analysis of Project Requirements
-
video Creating a Structural Model
-
video Project Testing and Presentation
Student Requirements
- Algorithms and Data Structures
Course Experts
Student Reviews 0
No reviews yet. Be the first!
~/kaznu $ cscourse consult
Want to take this course?
Leave your number — a consultant will call you back, tell you about the courses and prices, and help you choose a direction.
- ✓Free consultation
- ✓We will call back within a business day
Relational databases
Database Management System (DBMS)