Basics of Database Design & Development

Basics of Database Design & Development

Basics of Database Design & Development

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

Language: english

Note: 4.1/5 (616 notes) 131,800 students

Instructor(s): Creative Online School

Last update: 2020-10-27

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 


 

Who this course is for

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

 

Course content

  • Basics of 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
  • Bonus Section: 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
  • Bonus Section: Working with MongoDB (NoSQL Database)
    • MongoDB Installation
    • Basic Queries: Part 1
    • Basic Queries: Part 2
    • Advanced Queries: Part 1
    • Advanced Queries: Part 2

 

Basics of Database Design & DevelopmentBasics of Database Design & Development

Time remaining or 28 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate