Database modeling - Complete practical project for beginners

First step towards Data Science. Professional and easy approach for biginners to create their first database project.

4.40 (13 reviews)
Udemy
platform
English
language
Databases
category
instructor
76
students
3 hours
content
Apr 2020
last update
$44.99
regular price

What you will learn

Create Modern Point of Sales database design without coding

Practical codeless approach of Database modeling and design

Forward Engineering from case study or requirements from the client to implementation

Reverse Engineering on existing database

Convert your ERD into deliverable codes

Tips and tricks for productivity

Changing existing database design effectively

Description

This course has been designed to give you knowledge of how database-driven projects are built. I am focusing on practical implementations rather than theory or exams. Moreover, this course will give insights that how you can make your data model perfect so that it could fit in the next levels which are Data warehouse and Data mining.

Content

Introduction

Welcome from instructor
Practical flow of Course
Tools and technology used
What you will be able to do after completing this course

Introduction to Datamodeling

What is Data modeling?
The importance and benefits of Good data model
Difference between Data, Database and Database modeling

Setting up Enviroment

Installing Oracle SQL developer data modeler
Setting up preferences
Installation of Toad Data modeler

Project development.

Project requirements. Presentation
Entity – Conceptual and Practical perspective
Fetching entities from Requirements using Paperwork
Requirement Document
Creating your first Entity in Database
Breif intoroduction of Attribute
Creating Attributes in DM
Saving and Opening saved Project
Defining Primary key, Unique key
Drawing Entities Phase 1
Planning of Attributes Phase 1
Creating attributes in DM of Entities from Phase 1
Relationships in Database modeling
Creating One to Many Relationships
What is Many to Many relationship
Drawing Many to Many Relationships.
Finishing ERD - Ehnancements From Requirments
Tip: Adding common columns in all the tables

Deployment of Project on database side- Forward Engineering

What is Forward Engineering
Converting ERD to SQL script in target Database
Verification of Database objects
Comprehensive Database model reporting
Concluding Forward Engineering

modifications of deployed Model - Reverse Engineering

What is Reverse Engineering
Example of Reverse Engineering
Modify Deployed Database model

Conclusion

Conclusion

Screenshots

Database modeling - Complete practical project for beginners - Screenshot_01Database modeling - Complete practical project for beginners - Screenshot_02Database modeling - Complete practical project for beginners - Screenshot_03Database modeling - Complete practical project for beginners - Screenshot_04

Charts

Price

Database modeling - Complete practical project for beginners - Price chart

Rating

Database modeling - Complete practical project for beginners - Ratings chart

Enrollment distribution

Database modeling - Complete practical project for beginners - Distribution chart

Related Topics

993906
udemy ID
10/25/2016
course created date
5/14/2020
course indexed date
Bot
course submited by