Contact for queries :
020 3900 4072

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

Course Curriculum

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
Order your Certificate 00:00:00

FAQs

This course is for anyone who's interested in this topic and wants to learn more about it. This course will also help you gain potential professional skills.

No prior qualifications are needed to take this course.

You can study this course from wherever and whenever you want. You can study at your own pace and from any device. Just log in to your account from any device and start learning!

Yes, there is a test at the end of the course. Once you’ve completed all the modules of the course, you will have to give a multiple-choice test. The questions will be based on the topics of the modules you studied. And of course, you can take the test at any time, from any device and from anywhere you want.

Don’t worry if you fail the test, you can retake it as many times as you want.

We make the payment process easy for you. You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. We use the latest SSL encryption for all transactions, so your order is safe and secure.

You don’t have to wait a minute after your payment has been received, you can begin immediately. You will create your login details during the checkout process and we will also send you an email confirming your login details.

After you complete the course, you’ll immediately receive a free printable PDF certificate.  Hard Copy certificate is also available, and you can get one for just £9! You may have to wait for 3 to 9 days to get the hard copy certificate.

Review

COURSE REVIEWS

Course Reviews

4.9

4.9
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

About

iStudy is a brand of Adams Academy Inc. Ltd. Company Number 10647280, England and Wales, VAT No. GB-267018794

11 Floor, 15 St Botolph Street, London EC3A 7BB
020 3900 4072
hello@istudy.org.uk

Last Tweets

Validate your certificate

Coming soon

top