Learn Complete Database Design With MySQL Database Project.

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 .

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 .

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

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 .

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 . 

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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  .

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 .

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 .

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 .

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 .

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 .

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 .

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  .

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.

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 .

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.

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 .

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.

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.

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 .

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 .

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.

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 .

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 .