Learn Complete Database Design With MySQL Database Project.
4.5 (23 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
126 students enrolled

Learn Complete Database Design With MySQL Database Project.

Learn to master Complete Database Design Step-By-Step using MySQL DBMS . Build your First Professional Level Database
4.5 (23 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
126 students enrolled
Created by Sanjay Sathe
Last updated 9/2018
English
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Student will be able to confidently Design ( Plan ) and Build a professional level Database using MySQL RDBMS.
  • Student will understand important fundamental concepts and pratical knowledge in Database Design and Development.
  • Student will achieve expertise in Data Modelling Techniques .
  • Student will gain in depth understanding of all important theoretical database design fundamental concepts and pratical knowledge.
Course content
Expand all 40 lectures 04:56:42
+ Database Fundamentals
6 lectures 33:59

This is the first lecture in the first Database Fundamentals section . In this lecture we will discuss the meaning of term data with reference to the database management system . How the term data is defined in the context of  DBMS -  Database Management System .

Preview 06:40

In this lecture we will  define the term data processing  in the context of  DBMS . We will also discuss the data processing process  and how  raw data  is converted to information .

What is a Data Processing ?
03:45

In this lecture we will define the term database . We will also discuss different features of database , how database are organized , Logical and Physical structure of the databases .

Preview 06:44

In this lecture we will discuss the history of evolution of databases over last few decades .  We will discuss how database have evolved , different types of  database models and  the latest trends in database design .

History Of Database Evoluation
05:37

In this lecture we will discuss the first part of  database models . This lecture includes different types of database models such as Hierarchical , Network , Relational , Object Oriented  and  other important database models , the logical structure of  various database models and  important features .

Types Of Database Models PART - 1
04:59

In this lecture we will discuss the second  part of  database models . This lecture includes different types of database models such as Hierarchical , Network , Relational , Object Oriented  and  other important database models , the logical structure of  various database models and  important features .

Types Of Database Models PART - 2
06:14
+ DBMS - Database Management Systems.
4 lectures 26:14

In this lecture we will discuss introduction to  DBMS  -  Database Management System . We will also discuss  important functions of DBMS , some important fundamental concepts in DBMS .

Preview 06:20

In this lecture we will discuss  computer network  and  DBMS Architecture .This lecture  includes  introduction to client server architecture , different types of client server architecture such as single tier , two tier and three tier client server architecture , DBMS  architecture and  DBMS components .

Computer Network And DBMS Architecture.
06:59

In this lecture we will discuss DBMS  Environment Components . This lecture  software and hardware components , Roles and  functions of  different types DBMS  users

Database System Environment Components.
06:40

In this lecture we will discuss advantages of  DBMS -  Database Management system . We will also discuss in detail each of this advantage and its significance for  DBMS  users .

Advantages of DBMS - Database Management System.
06:15
+ Data Modelling And Database Design .
4 lectures 28:02

In this lecture we will discuss an important topic that is  Data Modelling . This lecture include what is data modelling , significance of  data modelling in database design and development , different types of data models  , its contents  and  how these data modelling techniques are used in database design process . 

What is a Data Modelling ?
05:20

In this lecture we will discuss an important topic that is  different types Data Models . This lecture include the application and details of different types  data models such as Conceptual Data Model   , Logical Data Model  and Physical Data Model .

Different Types Of Data Models .
08:11

In this lecture we will discuss an important topic that is  different  Data Modelling Techniques . This lecture include the application and details of different types  data Modelling Techniques .

Data Modelling Techniques.
06:47

In this lecture we will discuss an important topic that is Database  Design Principles  and  Process . In this lecture we will how  database design professionals progress through the different stages in database design . We will discuss in detail each of these step  and  step-By-Step  explanation  with an example .

Database Design Principles And Process .
07:44
+ ERD - Entity Relationship Diagram.
4 lectures 28:45

In this lecture we will discuss  ERD - Entity Relationship Diagram  which an important data modelling tool  used by database designers to create conceptual data model to capture the user data requirements .

What is an ERD - Entity Relationship Diagram ?
05:24

In this lecture we will discuss  the first part of ERD - Entity Relationship Diagram  which an important data modelling tool  used by database designers to create conceptual data model to capture the user data requirements . This lecture includes details of different components used for creating Entity Relationship Diagram .

The Components Of ER Diagram PART - 1
07:19

In this lecture we will discuss  the Second Part  of  ERD - Entity Relationship Diagram  which an important data modelling tool  used by database designers to create conceptual data model to capture the user data requirements . This lecture includes details of different components used for creating Entity Relationship Diagram .

The Components Of ER Diagram PART - 2
07:12

In this lecture we will discuss  the Third Part  of  ERD - Entity Relationship Diagram  which an important data modelling tool  used by database designers to create conceptual data model to capture the user data requirements . This lecture includes details of different components used for creating Entity Relationship Diagram .

The Components Of ER Diagram PART - 3
08:50
+ RDBMS - Relational Database Management Systems .
6 lectures 42:38

In this lecture , we will discuss introduction  to  RDBMS  -  Relational Database Management System . Relational databases are extensively used  such as Oracle , MySQL and MS SQL Sever . We will also discuss  in detail the Relational Database Model , its features  and other important related topics .

Introduction to Relational Database Model.
05:52

In this lecture , we will discuss introduction  to  RDBMS  -  Relational Database Management System .  We will also discuss  in detail Twelve Rules proposed by Dr E F Codd  who  was an  inventor of  Relational Database Model , its features  and other important related topics .

Relational Database - E F Codds 12 Rules .
07:07

In this lecture , we will discuss advantages offered by  RDBMS  -  Relational Database Management System . Relational databases are extensively used  because of  various advantages . We will also discuss  in detail each of these advantages of  Relational Database Model , its features  and other important related topics .

Advantages Of Relational Database Model.
06:00

In this lecture , we will discuss the First Part Of  Relational Database Terminology in which we will discuss , definitions and meaning of various terminology used in the design and development of    Relational Databases  .  We will also discuss  in detail  all important terms used in the Relational Database Model , its features  and other important related topics  such as  Functional Dependencies , Relational Table Structure  .

Relational Database Terminalogy - Entity & Relations : PART - 1
06:03

In this lecture , we will discuss the Second Part Of  Relational Database Terminology in which we will discuss , definitions and meaning of various terminology used in the design and development of    Relational Databases  .  We will also discuss  in detail  all important terms used in the Relational Database Model such as different types of Relationships , Database keys , Primary  Key  and Foreign Key .

Relational Database Terminalogy - Database Keys : PART - 2
07:08

In this lecture , we will discuss the Third Part Of  Relational Database Terminology in which we will discuss , definitions and meaning of various terminology used in the design and development of    Relational Databases  .  We will also discuss  in detail  all important terms used in the Relational Database Model such as defining Relationships between the tables using  Database keys such as  Primary  Key  and Foreign Key .

Relational Database Terminalogy - Database Keys : PART - 3
10:28
+ Database Normalization
5 lectures 42:02

In this lecture , we will discuss the First Part of  Functional Dependencies which is the first step towards the process of  Database Normalization . This lecture includes what is a functional dependency , different types of functional dependencies and its importance in database normalization .

Functional Dependencies In Relational Database : PART - 1
05:43

In this lecture , we will discuss the Second Part of  Functional Dependencies which is the first step towards the process of  Database Normalization . This lecture includes what is a functional dependency , different types of functional dependencies and its importance in database normalization .

Functional Dependencies In Relational Database : PART - 2
07:46

In this lecture , we will discuss the concept of Data Redundancy  in Relational Tables which is the  main cause of  various Database Anomalies . This lecture we will take a closer look at the problem of  Data Redundancy  and  solution  to solve this problem  with Database Normalization .

Data Redundancy And Database Anomalies .
09:59

In this lecture , we will discuss the First Part of  Introduction to Database Normalization  which is one of the most important topic in Database Design Process . We will discuss in details various aspects of the process of  Database Normalization . This lecture includes different Database Normalization Standard  Forms such as 1NF , 2NF , 3NF and  Step-By-Step Process of Database Normalization .

Database Normalization : Part - 1
06:18

In this lecture , we will discuss the  Second Part  of   Database Normalization  which is one of the most important topic in Database Design Process . We will discuss in details various aspects of the process of  Database Normalization . This lecture includes different Database Normalization Standard  Forms such as 1NF , 2NF , 3NF and  Step-By-Step Process to  normalize the  Database Tables  to the level of   1NF 2NF and 3NF Standards  .

Database Normalization : Part - 2
12:16
+ PROJECT - Database Design And Development With MySQL
11 lectures 01:35:02

In this lecture we will take look at the Project Overview of the Database Design Project using MySQL RDBMS  which is an important part of this course . In this lecture we will discuss the database design project scope and contents . This database design project has been covered in ten lectures and in this overview  , we will briefly discuss each of these lectures.

Preview 04:50

In this lecture , we will discuss the First Part of  MySQL RDBMS  , which deals with an  Introduction to MySQL  RDBMS  Relational Database Management System .  We will be using MySQL  RDBMS  for building our project database based on the various data models that we have created during the project database design ( Planning ) stage . This lecture includes  different features of  MySQL  RDBMS .

Introduction to MySQL RDBMS : Part - 1
05:11

In this lecture , we will discuss the Second Part of  MySQL RDBMS  , which deals with an  Introduction to SQL  -  Structured Query Language  which  is  a  standard database communication language  also referred as ( DAL - Data Access Language )used by Database Developers And Database Programmers to communicate with the database to perform various database operations . SQL  is also internally used by RDBMS including MySQL  RDBMS.

Introduction to MySQL RDBMS : Part - 2
07:59

In this lecture , we will discuss the Third Part of  MySQL RDBMS  , which deals with the Advantages and Applications of  MySQL  RDBMS  Relational Database Management System .  We will be using MySQL  RDBMS  for building our project database based on the various data models that we have created during the project database design ( Planning ) stage . This lecture includes  different advantages and  various applications of  MySQL  RDBMS .

Introduction to MySQL RDBMS : Part - 3
07:13

In this lecture , we will  discuss  the Database Design Objectives for our Project  Database . Defining the Database Design Objectives is an important  Step for  specifying the User Requirement Specifications , based on which the Database System will be designed and developed . In this lecture we will clearly outline all  the Database Design Objectives for our  Project  Database.

Defining the MySQL Database Design Project - objectives And Scope
06:33

In this lecture , we will  identify various  Database Entities  for our Project  Database . Identifying the Database Entities And  corresponding Attributes for each Entity is an important  Step  for defining the database logical structure   based on which the Database designers  will  create  Conceptual , Logical  And Physical Data Models for our Project Database . In this lecture we will Identify  all  the Database  Entities  for our  Project  Database.

Defining the Project Database Entities And Attributes .
07:18

In this lecture , we will  discuss the Web Servers  And  Web Development Stack  . For developing our project database , we will be using MySQL RDBMS  which  Web Server  based  RDBMS and therefore we need  a  fully functional web server to develop  our project database using MySQL  RDBMS. We will discuss different options for Web Development Stack  such as  LAMP , XAMPP and WAMP  , which provides a  bundle of software  to be installed in your local computer to create  Server Side Runtime Environment .

Web Server And Web Development Stack
09:20

In this lecture , we will  discuss the process to  Download  And Install   WAMP -  Web Development Stack on your computer system . For developing our project database , we will be using MySQL RDBMS  which  Web Server  based  RDBMS and therefore we need  a  fully functional web server to develop  our project database using MySQL  RDBMS. We will using WAMP Web server Stack   , which provides a  bundle of software  to be installed on any computer with MS Windows Operating System  to create  Server Side Runtime Environment .

WAMP Server Stack Download And Installation .
12:15

In this lecture we will discuss the Step-By-Step process to create our project database using  MySQL RDBMS  which is a part of  WAMP - Web Server Stack  installed on your computer . We will discuss in detail the Step-By-Step process to create our project database using  phpmyAdmin  utility built in to the WAMP Stack which provides interface to perform various database operations such as creating  a new database  using MySQL RDBMS.

Creating A New Database in MySQL .
09:23

In this lecture  , we will discuss the Step-By-Step process for creating and adding Tables to  our project database using  MySQL RDBMS  which is a part of  WAMP - Web Server Stack  installed on your computer . We will discuss in detail the Step-By-Step process to create  and add Tables to our project database using  phpmyAdmin  utility built in to the WAMP Stack which provides interface to perform various database operations such as creating and adding   a New Table  using MySQL RDBMS. Each Database Entity which we have identified during design stage will be  represented by a Table . The table structure will be based on the various data models  that we have created during database Design stage .

Creating Tables in MySQL Database .
13:26

In this lecture  , we will discuss the Step-By-Step process for defining the Relationship between the various Tables present in our project database using  MySQL RDBMS  which is a part of  WAMP - Web Server Stack  installed on your computer . We will discuss in detail the Step-By-Step process to define the Relationships based on the functional dependencies that exists between the Tables . We will be using Designer View Option which provides Graphical interface for defining Table Relationships . The   phpmyAdmin  utility is built in to the WAMP Stack which provides interface to perform various database operations such as  defining table relationships using MySQL RDBMS. Each Database Entity which we have identified during design stage will be  represented by a Table . The table structure will be based on the various data models  that we have created during database Design stage .

Defining Relations Between Tables in MySQL Database
11:34
Requirements
  • You just need to have a computer with an internet connection . No special software is required.
Description

The Database is  vital component of  most software applications that are being designed  to handle large volumes of  data . The performance of these software applications significantly depends upon the  efficiency of the database which provide  database functionality to these applications . And therefore , the database design professionals are in great demand in the job market .

The  database projects can be broadly split in to two stages . The first stage is database design part ( Planning )  in which the database designers make use of  data modelling  techniques  to create the necessary data models which  are used as blue prints for actually building the database using  a specific DBMS .

It is absolutely important for database design professional to understand and master the database design part which includes various data modelling techniques and database normalization process . The database design professional  must develop professional expertise in both database design part and the particle knowledge base to build a robust well planned database .

This  course has been designed   for  both  absolute beginners  as well as experienced professionals  who wants to learn  both  the database design theory , important fundamental concepts  and  the practical knowledge in database design . This course will teach you  step-by-step  entire database design process in most simplified  manner to  effectively plan and build a professional level database  using MySQL  Relational Database Management System .

In  this course , we will work  together on a  database design project  using  MySQL Relational Database Management System . This  course is  packed  with  graphics  , images  which will  help you  easily  grasp the important  fundamental concepts in database  design  and development .

This  course  will be an important  resource  in  gaining  professional level expertise as  a database design professional .

Who this course is for:
  • Specially designed for both absolute beginners as well as experienced professionals . Students at all levels.
  • Student interested in becoming an expert in Database Design ( Data Modelling ) and Building Professional Level Databases using MySQL RDBMS.
  • Student interested in career as a Database Design Specialist .
  • Non IT background students who wants to start IT career.