Register now or log in to join your professional community.
A database is a collection of information that is organized so that it can be easily accessed, managed and updated.
MySQL, MS SQL and No SQL are the queries language used to build and manage, and design these databases.
Database is the collection of information saved into digital form or in Hard Disc.
Before there was only SQL Based databases which were based on Relations between tables. Such RDBMD mySQL, Oracle, and SQLServer all using same technology of SQL. Why now days new concept come changed SQL logic, remove relational concept and data is not storing in tablular form.
When you you application is real time and low budget then ofcourse noSQL dbs is perfect because noSQL concept gives relational free execution, flexilibity and objected oriencted. You dont need to develop detailed database model.
While mySQL,Oracle, SQL etc. server are based on old concept of database among these mySQL is very famous for its open source nature and used most of the low budget project.
A database is a way to store important data on a computer system so that it can be manipulated and retrieved when needed.
MySql, MSSQL, and NoSQL are databas management systems that are responsible for storing, manipulating and retrieving those data, they are an interface between the data user (human or a software) and the underlying data on the hardware system.
sir Data bases are collections of large amount of Datas that can be accessed updated and managed any time . all the Datas are stored as a table (like rows and collums). data base management systems are programs used to analyze databases.
My SQL, MS SQL, AND NO SQL are database management systems which are used to create modify and manage databases which are packages which helps the user to analyze datas in the databases. It helps to store Collection of Datas and helps to provide relation ship with datas using RDBMS.
Database ensure security
My SQL are open sourced Database management system which helps to access and manage database.
MS SQL Is also a Database management system developed my microsoft for the operation and management of Relational DataBase
No SQL are Dbms that handles Big datasets
Database is a collection of information structrured and store in a way that makes it easy and fast to manupilate. Before databases, programmers used to use files to store data, but when the thing growup and the data become huge and complexe the DBMSs (Database management system) was born.
So MySQL, MsSQL etc.. are not the actual Database but the systems that manupilate it, and they have more roles such as managing previledges and roles etc..
SQL is the formel language used by us (human beens) to speak to DBMS to order it to manipulate data.
A database is a collection of information that is organized so that it can be easily accessed, managed and updated. Information stored in the database is in the form of tables and columns.
MySQL database is open source RDBMS. MySQL is the world's most used RDBMS, and runs as a server providing multi-user access to a number of databases. MySQL is currently produced and managed by the Oracle Corporation.
MSSQL is Microsoft SQL Server RDBMS. It's one of the three market-leading database technologies. SQL Server is tied to Transact-SQL (T-SQL), an implementation of SQL from Microsoft that adds a set of proprietary programming extensions to the standard language.
NoSQL Database is an alternative to traditional relational databases. NoSQL databases are especially useful for working with large sets of distributed data. It stores the data in key-value pair. NoSQL provides relational free execution, flexibility and object oriented
Depending upon your needs, complexity, data volume, performance, scalability and cost you make your choice. Each database has it pros and cons, you may validate your business needs against those to arrive at the decision of selecting the most appropriate database.
Databases are as the name present, a lot of data organized into and grouped in a form of tables, this is the logical meaning.
Physically it is consist of several tablespaces, files that can be processed, read or edited using the SQL (Structured query language).
SQL is a query language used to access DB tables for viewing editing and deleting.
MS SQL is the Microsoft SQL.
Oracle for instance has its own developed PL/SQL (Procedural Language/Structured Query Language) which is procedure based language, more powerful with more features
Databases are essential for almost every business to be successful, it give the organization -regardless of its industry- the ease and flexibility to store and process the information that flow in/out every day.
I tried to make the answer as short as possible
Regards
the database is the container of information where you can store data and represent them in tables.
My SQL is the language using to write the codes for the database
MS SQL is the build up functions developed by Microsoft that using for dealing with data.
all about database will be used in case of developing a program, software or a website. in case of being a user you won't need it.
DB:collection of data which includes tables
SQL is a language, MySQL is a database
SQL - Structured Query Language. It is declarative computer language aimed at querying relational databases.
MySQL is a relational database - a piece of software optimized for data storage and retrieval. There are many such databases - Oracle, Microsoft SQL Server, SQLite and many others are examples of such.
NoSQL
NoSQL encompasses a wide variety of different database technologies that were developed in response to the demands presented in building modern applications
NoSQL databases are especially useful for working with large sets of distributed data.
A database as related to SQL (Structured Query Language), is a set of tables that store information in form of rows and columns about a specific entity (thing). The tables can be related to each other by keys (Product ID, Category ID etc). SQL is structured Query Language. It is a language for searching (Querying) the tables in the database, such as when you go to hospital, they search by your health ID or your name to find your record. MS SQL is Microsoft's database software (aka RDBMS=Relational Database Management System), My SQL is an alternative open source product.
You need them when you want to create some software that will be dealing with storing and retrieving structured data (in form of tables).
SQL : is a programming language used by database architects to design relational databases
NoSQL : Non-Relational & Distributed data
MySQL : the most popular open source database , excellent for CMS sites and blogs
