Skip to main content

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




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: 






Labels:

Comments

Post a Comment

Popular posts from this blog

Assignment of ITA/ Information Technology and Application BCA- Technology369kk

Q1. What is  computer Explain basic computer architecture and Difference components.  2. Discuss the use of memory in computer system, Explain memory hierarchy  in details. 3. What is software? Explain difference types of software with explain. 4. Write short notes on the given:- (I) Internet. (II) LAN (Local area network ) (III) Search engine (IV) Web browser  Q 1.What is computer Explain basic computer architecture, Difference components of computer.   Computer :- Computer is defined as an electronic device that takes input data and instructions from the user and after processing them, it generates useful and desired output quickly.   A computer is designed to execute applications and provides a variety of solutions through integrated hardware and software components.                            It is fast and automatic device. It works with the help of programs and represents the d...
2 comments
Read more

C++ and Java Practical All Questions Answers - BCA -Technology369kk

C++ and Java  In this post see most important questions for practical questions given by college all questions with answers . Guys I want to say that this is only for suggested post for your practical please request to you change same alphabets, words or anything  methods name and variables name because if you write all words same then this is copy paste for another peoples.  Used Topics:  Keywords, Variables, Condition Statements, Function , Array, Structure, Pointer.                           In OOPs, Class and Objects, Constructor, Poly morph, Encapsulation, Access Specifiers,                               Inheritance etc.  So, Without Time Lose Come to the Points, let's go start Now:        *************************************************************************  C++ 12 ...
Post a Comment
Read more

Assignment of PMO (Principal of Management and Organization) - Technology369kk

 ** Assignment Of PMO ** Agenda: -  4 Questions discuss in this post. Question 1. Write a d etails note on selection why it Called. negative process.  Question 2. Write a details note on 'span of control. Question 3. Planning is an essential process, do you agree ? Discuss  Question 4. Write a note on management function. Q 1. Write a d etails note on selection why it called negative process.  Ans :-  Selection is the process of choosing the most suitable candidates out of the several candidates available.          Selection is a negative process because there may be more rejected then those selected in most of the candidates that is called selection is a negative process. → Selection process has the following steps:-  [ A .] Screening of applicants - Based on the screening of applicants only those candidates. It Called further process of selection. Who are found eligible for the job Standards of the the organization. [ B .] S...
3 comments
Read more