Basics of Database Design & Development



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

Topics for this course

27 Lessons

Section 1: Mastering Database Design

1. Introduction and Database Overview3:41
2. Understanding SQL Types of Commands11:02
3. Tables, Views and Stored Procedures6:45
4. Database Constraints12:00
5. Database Normalization11:52
6. ER Diagram4:14
7. Relational Database Management System3:22
8. NoSQL4:22
9. RDBMS vs. NoSQL4:05

Section 2: Learning MySQL Development

About the instructors

Jerad Hill

0 ratings (0 )
41 Courses
7 students


Course Details

  • Level: Beginner
  • Categories: Development
  • Total Lessons: 27
  • Total Enrolled: 1
  • Last Update:


  • No prior knowledge on Database required.

Target Audience

  • Who wanna learn basic concepts of Database Design
  • Who wanna learn advanced concepts of Database Design