RDBMS and MYSQL Complete Course (Notes) -Technology369kk

 DBMS

DataBase Managment Systems

What is Database?

• A database is a collection of information organized for easy creation, access, management and maintenance on databases.

In other words: 

Ans:

• A database is an organized collection of structured information, or data, typically stored electronically in a computer system.
• A database is usually controlled by a database management system (DBMS), which is software that allows users to create, access, and manipulate data. Most databases use structured query language (SQL) for writing and querying data. 

Example: 

• Telephone directory
• Customer data
• Product Inventory
• Visitors register
• Weather records

There are many different types of databases, such as relational, object-oriented, NoSQL, and cloud databases

Types of Data Models:  

1. Recorded based on the Logical Model 
1. Hierarchical Data Model
2. Network Data
3. Relational Data.
2. Object-Based on Logical Model 
1. Entity Relationship 

Introduction of Course: 

In this course we will learn in detail about RDBMS and MySQL in Hindi and English Language, Our RDBMS Tutorial will guide to learn with Units + Chapters, each chapter discussing in detail Theory with Practicals of every topic and implementations with some using commands and PRACTICAL  for beginners based and advanced level and at last cover a Project of  RDBM, So let's go start now.

Course Contents

Unit No 1 !!!  RDBMS

CHAPTER - 1 : RDBMS INTRODUCATION

CHAPTER - 2 : ER -DIAGRAM and NORMALIZATIONS'  

Unit No 2 !!!  MYSQL

CHAPTER - 1 :  MYSQL  INTRODUCTION

CHAPTER - 2 :  MYSQL COMMAND  

CHAPTER - 3 :  MYSQL OPERATORS 

CHAPTER - 2 :  MYSQL FUNCTIONS

CHAPTER - 2 :  MYSQL JOINS 

CHAPTER - 2 :  MYSQL LAB SESSIONS 

CHAPTER - 2 :  MYSQL EXAM QUESTIONS 

              

              VISIT :              MYALL PROJECT: