Download appDownload App

Database Design Fundamentals

Today, every web developer must have knowledge of all the different aspects of web development. One such aspect is database designing whose need has tremendously increased in the last few years. Be it...

  • All levels
  • English

Course Description

Today, every web developer must have knowledge of all the different aspects of web development. One such aspect is database designing whose need has tremendously increased in the last few years. Be it a university or a hospital; everyone needs a database of their own, making it a challenge for all the developer having sundry of skills but database design. Here, we bring you a Database tutorial...

Today, every web developer must have knowledge of all the different aspects of web development. One such aspect is database designing whose need has tremendously increased in the last few years. Be it a university or a hospital; everyone needs a database of their own, making it a challenge for all the developer having sundry of skills but database design. Here, we bring you a Database tutorial focusing on the fundamentals of database designing by using MySQL and MongoDB. These are the two widely used open source platforms for database designing by the experts.

What you’ll learn
  • 1. Details covering database systems and installation of My SQL.
  • 2. Basics of My SQL including the creation of a database or a table, My SQL data types, retrieving data from a database and, updating or deleting the data.
  • 3. In-depth details about database design
  • 4. Building an E-commerce project from scratch
  • 5. Basics of MongoDB and No SQL Basics including the difference between Relational and Non Relational Databases, installation of MongoDB on both Windows and Ubuntu system, creating the collections, inserting/updating/deleting the records and many more.
  • 6. Another project focusing on a learning management system.

Covering Topics

1
Section 1 : Introduction
2
Section 2 : MySQL Basics
3
Section 3 : DataBase Design
4
Section 4 : E-commerce Project
5
Section 5 : MongoDB and NoSQL Basics
6
Section 6 : Learing System Project

Curriculum

      Section 1 : Introduction
1
Presentation Preview
2
Whats a Database
3
Database Systems
4
Installing Mysql on Windows
5
Installing on Ubuntu System Preview
      Section 2 : MySQL Basics
6
Creating your First Database
7
Creating your First Table
8
Mysql Data Types
9
Saving Data in Tables
10
Getting Data From a Database
11
Where
12
Update Preview
13
Delete
14
Count
      Section 3 : DataBase Design
15
What is Database Design
16
First Normal Form
17
The Power of Diagrams
18
Card Inality Obligation and Relationships
19
Primary Key
20
Creating Users Table
21
Creating Phone Table
22
Testing the Project
23
Basic Join
      Section 4 : E-commerce Project
24
Ecommerce Database Design Project Diagram Preview
25
Creating the Users and Addresses Table
26
Creating the Product Table
27
Finishing the Project
      Section 5 : MongoDB and NoSQL Basics
28
Relational vs Non Relational Database
29
What is Mongodb
30
Installing Mongodb on Windwos
31
Installing Mongodb on Ubuntu System
32
Databases on Mongodb
33
Creating Collections
34
Inserting Data
35
listing All Records
36
Advanced Find
37
Limit and Sort
38
Deleting Records
39
Updating Records
40
Mongodb Relationship
      Section 6 : Learing System Project
41
Elearning Database Project
42
Users Collection
43
Courses Collection
44
Questions Collection

Frequently Asked Questions

It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.

A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.

A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.

We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.