DBMS languages

 DBMS (Database Management System), which is a concept and a set of rules that all or major Database Systems follows. Some Database systems follows most of these rules, and some follows only only certain rules.

DBMS products like SQL Server, Oracle, MySQL, IBM DB2, etc uses SQL as a standard language. SQL language used in these tools is very common and have similar syntaxes.

A database-management system (DBMS) is a computer-software application that interacts with end-users, other applications, and the database itself to capture and analyze data. A generalpurpose DBMS allows the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL, EnterpriseDB, MongoDB, MariaDB, Microsoft SQL Server, Oracle, Sybase, SAP HANA, MemSQL, SQLite and IBM DB2.

A database is not generally portable across different DBMSs, but different DBMSs can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one DBMS. Computer scientists may classify database-management systems according to the database models that they support; the most popular database systems since the 1980s have all supported the relational model - generally associated with the SQL language. Sometimes a DBMS is loosely referred to as a "database".   

Subcribe on Youtube - IGNOU SERVICE

For PDF copy of Solved Assignment

WhatsApp Us - 9113311883(Paid)