Booking options
£25
Course Images
Introduction to Database Design
By iStudy UK
- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
1 hour 40 minutes
All levels
Description
This Introduction to Database Design course teaches the basis of relational database design and explains how to make a good database design and become an expert on it.
Designing a database is quite simple, but you've to understand a few rules before jump onto it. It is essential to know about these rules, otherwise, you will tend to make errors. If you find it hard to deal with database, scripts and all the technical parts, then this comprehensive course is just for you.
The course includes the followings:
Creating database and database users
Introduction of data, different data types, foreign key constraints, and other relevant concepts used to create the best database
Importing database tables
Explore all types of relationships
Designing all types of relationships within a database.
Learn three common forms of database normalisation
Application of database for the business purpose
And much more...
What Will I Learn?
What is a database
Understand different types of databases
Understand normalization
Assign relationships
Eliminate repetition
Relate tables with IDs
Design rules
Requirements
Basic Microsoft Windows training or equivalent experience
Who is the target audience?
Students just getting started with designing databases and those who have been designing databases but looking for tips on more effective design
Introduction | |||
Introduction | FREE | 00:03:00 | |
Database Basics | |||
Overview | 00:01:00 | ||
What is a Database? | 00:03:00 | ||
Different Types of Databases | 00:12:00 | ||
The Process of Database Design | 00:08:00 | ||
Normalizing | |||
Overview - Normalizing | 00:01:00 | ||
What is Normalization? | 00:02:00 | ||
Basic Steps to Normalization | 00:05:00 | ||
A. Brainstorm | 00:01:00 | ||
B. Organize | 00:03:00 | ||
C. Eliminate Repetition | 00:12:00 | ||
D. Assign Relationships | 00:01:00 | ||
D1. One to One Relationship | 00:06:00 | ||
D2. One to Many Relationship | 00:04:00 | ||
D3. Many to Many Relationship | 00:06:00 | ||
Relating Tables with IDs | 00:02:00 | ||
Examples of Bad Design | 00:15:00 | ||
Examples of Good Design | 00:06:00 | ||
Design Rules | 00:05:00 | ||
Conclusion | |||
Conclusion | 00:04:00 | ||
Course Certification |
About The Provider
We understand more than anyone how important it is for yo...
Reviews
There are no reviews for Introduction to Database Design yet.Why not be the first one to review this course?