Understand basics of database design & development through step by step procedure
☑ Can make better database using standard principles
☑ Prepare better database from scratch
☑ Feel comfortable to write database design in resume
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
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
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