Prerequisites
There are no prerequisites for this course.
Audience
Anyone can take this course who wants to learn about databases or RDMS.
Relational Databases & Data Modelling Training Course Overview
A relational database management system (RDMS) is a collection of programs and capabilities enabling delegates to create, update, administer and interact with a relational database. RDBMS (relational database) stores data in the form of tables and every table in a relational database comprises rows and columns. In computer science terminology, rows are called tuples and columns are called attributes, and the tables themselves called relation. RDBMS provides a dependable method to store and retrieve large amounts of data.
This course provides knowledge of the structure of the Relational Database Management System (RDBMS) and Data Modelling using entity and relationship diagrams and data normalisation, also in designing relational databases using the normalised entity model. Data modelling and data normalisation are essential topics to be covered in this course.
In this course, delegates will learn about database approach, database management systems and the logic of database architectures. They will also gain an understanding of entity modelling, constraints and assumptions. This course will teach delegates about normalisation’s first form, second form, and third form. They will also learn about logical data structure, relational schema, and database constraints. This course describes the concept of views and de-normalisation techniques. In addition, they will learn about simple queries in structured query language (SQL).