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

What you will learn

Can make better database using standard principles

Prepare better database from scratch

Feel comfortable to write database design in resume

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

English

Language

Content

Mastering Database Design

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

Learning MySQL Development

Introduction to MySQL


Get Instant Notification of New Courses on our Telegram channel.


Data types in MySQL Part – 1

Data types in MySQL Part – 2

XAMPP Installation

MySQL Workbench Installation

Creating with PHPMyAdmin

Creating Database & Table through MySQL Workbench

Design and Accounts

Import and Export

Introduction to MySQL Queries and SELECT Clause

Inserts Updates and Deletes

Storage Engines

Mastering Table Joining: Part 1

Mastering Table Joining: Part 2

Working with Math and Strings: Part 1

Working with Math and Strings: Part 2

Group By: Part 1

Group By: Part 2