Udemy

Platform

English

Language

Databases

Category

Basics of Database Design & Development

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

4.08 (371 reviews)

Students

3 horas en

Content

Oct 2020

Last Update
Regular Price

EXCLUSIVE SKILLSHARE OFFER
Exclusive  SkillShare  Offer
Unlimited access to 30 000 Premium SkillShare courses
30-DAY FREE TRIAL

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 



Screenshots

Basics of Database Design & Development
Basics of Database Design & Development
Basics of Database Design & Development
Basics of Database Design & Development

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

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


Reviews

B
Brandon19 May 2021

Section 2 was great with explaining and showing how to utilize SQL. Section1 and Section3 was a section where the instructor was inputting commands back to back in each video at a fast pace and then going onto the next subject. Section 2 was great though

A
Atef26 April 2021

For a beginner this is hard to follow. My self is an expert on DB design and I am taking this course to refresh some basic concepts. However, I do believe for a beginner who’s taking this course it would be better to show how to install the DB

G
Gattimi15 February 2021

The course is very helpful. Even though the Section 1 does not cover any coding, the next sessions have them clearly explained. The Only problem is that the section2 and section3 are incomplete. Waiting for the update.

U
Upendra21 January 2021

I have learn that what the database is and how the database works with a structure of server . Also learn the types of commands that we are gonna be used in database systems . Types of tables, views and stored procedures are to be learned.

E
Elmin9 December 2020

Dieser Kurs besteht aus drei Teilen aus anderen Kursen. Nicht kohärent aufbereitet, keine Einführung, keine Verabschiedung und der erste Teil des Kurses war generell sinnlos. Der zweite und dritte Teil sind gut aufbereitet und gesprochen. Diese bieten einen guten aber sehr kurzen Einblick in die Materie. Vorallem der dritte Teil referenziert im Letzten Video auf ein nächstes :D Bitte diesen Kurs auch als das anbieten was es ist. Ein kurzer Einblick und mehr nicht. War zum Glück kostenlos. Aber kostenlos muss nicht billig sein.

K
Karen26 July 2020

The first module was instructed in a less sufficient manner, the second module was more comprehensive and understandable.

S
Shaik25 July 2020

i learned each and everything in detail with clearcut examples ...finally i am very satisfied with this course..thank you..

M
Megan8 January 2020

The first thing I wanted to note is that the second and third sections of the intro lesson are switched, which was confusing. Also, I worried at first because he jumped into a SQL database already made without context such as "I'm using this database to help you visualize the terms I'm discussing, no need to worry about making this database". Lastly, his misspelling of words is rather frequent and it started to interfere with the lesson flow. However, I'm going to stick with the course and see if the flow and feel of the course improves. The second part of the lesson, learning to create a database, goes much better. I would have liked this course first, or a mention in the first part that creating a database will be covered in the second part.

M
Manupendra11 March 2018

This course is helpful for those who students want to revise there concepts of database and summarizes bits and bytes of database.


Coupons

DateDiscountStatus
7/24/2020100% OFFExpired
10/25/2020100% OFFExpired
11/2/2020100% OFFExpired
11/19/2020100% OFFExpired
12/8/2020100% OFFExpired
1/8/2021100% OFFExpired
2/4/2021100% OFFExpired
3/9/2021100% OFFExpired
4/9/2021100% OFFExpired
5/9/2021100% OFFExpired
6/9/2021100% OFFExpired

1586184

Udemy ID

3/8/2018

Course created date

7/25/2019

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram