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)
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
Charts
Price
Rating
Enrollment distribution
Related Topics
993906
udemy ID
10/25/2016
course created date
5/14/2020
course indexed date
Bot
course submited by