Introduction to Database Design
This course teaches the basis of relational database design and explains how to make a good database design and become …
GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49 PER YEAR. FIND OUT MORE
Course 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
5 Sections 20 lectures 1 hours 40 mins in total
-
Introduction 00:03:00
-
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
-
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 00:04:00
Course Reviews
No Reviews found for this course.
After successfully completing the course, you will be able to get the and internationally accepted certificate to share your achievement with potential employers or include it in your CV.
SAVE Upto 94% - Ends Soon!
or
All courses now £49
Related Courses
5 hours, 47 minutes
15
