PostgreSQL 2021 MasterClass (Udemy.com)

From Database Design To WebApp Development - Part n1: Relational Database Design through a real-life example.

( 0 Reviews )

Created by: Mir CHAKIR

Produced in 2021

What you will learn

You will understand the core concepts of data modeling.
You will learn the major aspects and features of relational databases.
You will discover the wonderful world of relational databases through a real life example.
You will master the development of Entity-Relationship Diagrams (ERD) and Relational Models.
You will be able to perform all the steps required to create a well-designed relational database from business process analysis to database script generating.
You will be able to apply the process of normalization to get a high quality database schema.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Course Description

Welcome to the 1st Part of the course entitled: << PostgreSQL 2019 MasterClass - From Database Design to WebApp Development >>
What you will learn in this course:

You will discover the wonderful world of relational databases through a real life example.
You will understand the core concepts of data modeling.
You will learn the major aspects and features of relational databases.
You will be able to perform all the steps required to create a well-designed relational database from business process analysis to database script generation:
- How to develop an Entity-Relational diagram (ERD).
- How to map an ERD to a relational model.
- How to apply normalization process to the relational model.
- How to convert a relational model to a physical model.
- How to generate and complete the database SQL script.

In this course , the process of designing a relational database is taught step-by-step, such that anybody without any prerequisites will be able to perform this process in an easy way.

WHY SHOULD YOU LEARN HOW TO DESIGN A RELATIONAL DATABASE ?

To develop a software application, you need to use a storage structure to manage data. Obviously, you can use spreadsheets or flat files, but :

What if you want to enable concurrent access by many users of the software application ?
What if you want to grant different access rights to those users?
What if you want to add over a million of records and keep a high level of performance?
What if you want to implement data integrity check?
What if you want to prevent users from typing redundant data?

In order to address the limitations encountered by spreadsheets and flat files, you have to build a well-designed database.
Database design is a fundamental step for building nearly any software application (website, web application, desktop application and mobile application).
Apart from improving the performance, well-designed databases are more scalable, more consistent, easy to maintain, and cost effective in terms of disk storage space.

To further motivate you to learn databases in terms of career development, database administrator, database manager and database developer were ranked in the top 10 highest paying big data careers in United States on july 2017 ( according to Northeastern University).
Relational Database Management Systems are important for Big data. Most companies need to rely on the data stored in relational databases to create the highest level of value to the business with big data.
NoSQL databases used in big data are also sometimes called "Not only SQL" to emphasize that they may sit alongside relational database (SQL DB) in a polyglot persistence architecture.

Also, Relational Database Management Systems are more suitable for the Central Data Warehouse role than multidimensional databases, because they are supported by many third-party vendors, they are compatible with existing standards at the organization, and they are easier to maintain and administrate.
In addition, having no data size constraints, they are mandatory when the data warehouse seems to grow to hundreds of gigabytes or larger.

As you can see, mastering the concepts and techniques of Relational Database Management Systems is very important for those who work in the field of Information systems.
Even if you are interested to the newest techniques, you need to understand the basics of data modeling in general and the fundamentals of relational databases technology in particular. This will help you to combine some features of these new technologies with some features of the RDBMS and also to perform data migration processes.

Who this course is for:

Students who are new to the field of relational databases.
The initiated people who want to set up a relational database.

Time: 2h

Instructor Details

Mir CHAKIR

0.0 Rating
0 Reviews

I am Mir Chakir, a software engineer with a scientific background and a wide experience in data modeling techniques (ERD, Merise and UML).
I have been an oracle database administrator for more than 2 years before working as java/php programmer and systems analyst.
I have delivered many relational database and web development projects.
I led projects using HTML5, CSS3, JavaScript, PHP, Java, MySQL, PostgreSQL and WordPress.
I'm also familiar with data warehousing techniques.
I Trained many students on information system technologies.
I love to learn and implement new things. It will be my pleasure to share my knowledge with Udemy students.