Basics of Database Design & Development

Basics of Database Design & Development, available at $29.99, has an average rating of 4.29, with 33 lectures, based on 794 reviews, and has 151931 subscribers.

You will learn about Can make better database using standard principles Prepare better database from scratch Feel comfortable to write database design in resume This course is ideal for individuals who are Who wanna learn basic concepts of Database Design or Who wanna learn advanced concepts of Database Design It is particularly useful for Who wanna learn basic concepts of Database Design or Who wanna learn advanced concepts of Database Design.

Enroll now: Basics of Database Design & Development

Summary

Title: Basics of Database Design & Development

Price: $29.99

Average Rating: 4.29

Number of Lectures: 33

Number of Published Lectures: 32

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 32

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will Learn

Can make better database using standard principles
Prepare better database from scratch
Feel comfortable to write database design in resume

Who Should Attend

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

Target Audiences

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

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�

Course Curriculum

Chapter 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

Chapter 2: Bonus Section: Learning MySQL Development

Lecture 1: Introduction to MySQL

Lecture 2: Data types in MySQL Part – 1

Lecture 3: Data types in MySQL Part – 2

Lecture 4: XAMPP Installation

Lecture 5: MySQL Workbench Installation

Lecture 6: Creating with PHPMyAdmin

Lecture 7: Creating Database & Table through MySQL Workbench

Lecture 8: Design and Accounts

Lecture 9: Import and Export

Lecture 10: Introduction to MySQL Queries and SELECT Clause

Lecture 11: Inserts Updates and Deletes

Lecture 12: Storage Engines

Lecture 13: Mastering Table Joining: Part 1

Lecture 14: Mastering Table Joining: Part 2

Lecture 15: Working with Math and Strings: Part 1

Lecture 16: Working with Math and Strings: Part 2

Lecture 17: Group By: Part 1

Lecture 18: Group By: Part 2

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

Lecture 1: MongoDB Installation

Lecture 2: Basic Queries: Part 1

Lecture 3: Basic Queries: Part 2

Lecture 4: Advanced Queries: Part 1

Lecture 5: Advanced Queries: Part 2

Instructors

Creative Online School
Creative & Engaging Online Courses

Rating Distribution

1 stars: 25 votes
2 stars: 42 votes
3 stars: 159 votes
4 stars: 266 votes
5 stars: 302 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu