Basics of Database Design & Development

Understand basics of database design & development through step by step procedure

Rating: 4.0 out of 5

4.0  (549 ratings)

124,769 students

Created by Creative Online School

Last updated 10/2020

English

What you'll learn

1. Can make better database using standard principles
2. Prepare better database from scratch
3. Feel comfortable to write database design in resume

Course content

3 sections • 32 lectures • 2h 44m total length

Enroll now

Description

Database design is the process of producing a detailed data model of a database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design. Through this tutorial we will try to teach the basis components of database design and explains how to make a good database design.

Designing a database is in fact fairly easy, but there are a few rules to stick to. It is important to know what these rules are, but more importantly is to know why these rules exist, otherwise you will tend to make mistakes!

Contents of this course 

Introduction and Database Overview 

Understanding SQL Types of commands 

Tables, Views and Stored Procedures 

Database constraints 

Database Normalization 

ER Diagram 

Relational Database Management System 

NoSQL 

RDBMS vs. NoSQL 

Instructor : Creative Online School

Creative & Engaging Online Courses

Creative Online School

4.2 Instructor Rating

30,261 Reviews

1,257,642 Students

20 Courses

Creative online school offers a huge and ever growing range of high creative, quality and engaging learning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.