Basics of Database Design & Development
Understand basics of database design & development through step by step procedure
- Description
- Curriculum
- FAQ
- Reviews
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
Bonus Section: Learning MySQL Development
Bonus Section: Working with MongoDB (NoSQL Database)
-
10
Introduction to MySQL -
11
Data types in MySQL Part - 1
-
12
Data types in MySQL Part - 2
-
13
XAMPP Installation
-
14
MySQL Workbench Installation
-
15
Creating with PHPMyAdmin
-
16
Creating Database & Table through MySQL Workbench
-
17
Design and Accounts
-
18
Import and Export
-
19
Introduction to MySQL Queries and SELECT Clause
-
20
Inserts Updates and Deletes
-
21
Storage Engines
-
22
Mastering Table Joining: Part 1
-
23
Mastering Table Joining: Part 2
-
24
Working with Math and Strings: Part 1
-
25
Working with Math and Strings: Part 2
-
26
Group By: Part 1
-
27
Group By: Part 2
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!
Stars 5
246
Stars 4
220
Stars 3
130
Stars 2
37
Stars 1
19
Course details
Lectures
7
Quizzes
3
Video
3 hours
Certificate of Completion
Full lifetime access
Access on mobile and TV
Popular courses
