Skip to main content

Posts

Showing posts from February, 2024

Learn Database and SQL concept in Short

What is Databases? Database is any collection of related information. It containt any type of data including word,Images,videos, numbers and files. What is Database Management Systems(DBMS)? A special softwware program that helps users create and maintain a database. make it easy to manage large amounts of information, handle secuirity, backup,importing and exporting data,concurrency. Some Main Types of Databases: 1. Relational Databases:  It uses SQL language for performing operations. organized data into one or more tables. each table has columns and rows, A unique Key identifies each row. 2.  NoN Relational Databases: It uses NoSQL language for performing operations. organized data in anything but a traditional table. Key-value stores,Documents(JSON,XML,etc),Graphs,Flexible Table. 3. Cloud Databases: A cloud database is used where data requires a virtual environment for storing and executing over the cloud platforms and there are so many cloud computing services for accessi...