Basics Of Database Design & Development

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

What you'll learn
Can make better database using standard principles
Prepare better database from scratch
Feel comfortable to write database design in resume
Requirements
No prior knowledge on Database required.
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 


Overview

Section 1: Basics of Database Design

Lecture 1 Introduction and Database Overview

Lecture 2 Understanding SQL Types of Commands

Lecture 3 Tables, Views and Stored Procedures

Lecture 4 Database Constraints

Lecture 5 Database Normalization

Lecture 6 ER Diagram

Lecture 7 Relational Database Management System

Lecture 8 NoSQL

Lecture 9 RDBMS vs. NoSQL

Section 2: Bonus Section: Learning MySQL Development

Lecture 10 Introduction to MySQL

Lecture 11 Data types in MySQL Part - 1

Lecture 12 Data types in MySQL Part - 2

Lecture 13 XAMPP Installation

Lecture 14 MySQL Workbench Installation

Lecture 15 Creating with PHPMyAdmin

Lecture 16 Creating Database & Table through MySQL Workbench

Lecture 17 Design and Accounts

Lecture 18 Import and Export

Lecture 19 Introduction to MySQL Queries and SELECT Clause

Lecture 20 Inserts Updates and Deletes

Lecture 21 Storage Engines

Lecture 22 Mastering Table Joining: Part 1

Lecture 23 Mastering Table Joining: Part 2

Lecture 24 Working with Math and Strings: Part 1

Lecture 25 Working with Math and Strings: Part 2

Lecture 26 Group By: Part 1

Lecture 27 Group By: Part 2

Section 3: Bonus Section: Working with MongoDB (NoSQL Database)

Lecture 28 MongoDB Installation

Lecture 29 Basic Queries: Part 1

Lecture 30 Basic Queries: Part 2

Lecture 31 Advanced Queries: Part 1

Lecture 32 Advanced Queries: Part 2

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