Oracle is a relational database system that uses SQL in order to be accessed and interpreted by its users.
It is used by businesses worldwide to manage and store data for small and large networks. The Oracle database has its own network component to allow communications across networks. It is one of the most used and trusted database engines. Oracle can run on numerous platforms including Windows, UNIX, Linux and Mac OS. It uses a language called Procedural Language/SQL or PL/SQL, which is a dialect of SQL that makes this system more powerful and a bit more complex than that used in MS SQL.
MS SQL uses a relational database management system that allows for transaction processing, business intelligence and analytics applications for businesses in their IT departments. Microsoft SQL Server Express is free and is important for the development of servers that are smaller in size. It is equipped with tools that can help its users create, edit, and manage its data.
It is a client/server database engine which means that the query that is created only returns results from the serve to the clients. It also uses Transcript SQL or T-SQL, which is a simple version of the SQL language. Many common users of Microsoft choose Access over the SQL Server because it is deemed as more user friendly.Microsoft Access is created mostly for desktops, in which files must be downloaded and saved in order to be used. It uses a tool called RAD, or Rapid Application Development, that quickly build forms and reports that are are bound to the database. Although, Access can have performance issues if the database has data included that isn’t properly and previously saved onto the computer. Many common users of Microsoft choose Access over the SQL Server because it is deemed as more user friendly.
SQL Data is divided into 4 different statements, each of which contribute to how each database is created, manipulated, deleted, read, and written depending on what is needed or lacking.? DDL – DDL statements, also known as Data Definition Language statements, are used to edit a database and redesign how the database is able to store objects. Specifically, some DDL statements are:? CREATE – create an entirely new Table or Database? ALTER – alter pre-existing table data or descriptions? DROP – delete objects that are unnecessary to the database? DML – DML statements, also known as Data Manipulation Language statements, are used to change the information in a table.
create and modify the structure of database objects in database.? SELECT – select records? INSERT – insert new records? UPDATE – update already created records? DELETE – delete already created records? DCL- DCL statements, also known as Data Control Language statements, are used to control permissions that users have on objects and data within the database.? GRANT – permits users to read and make changes to database? REVOKE – takes away permissions to edit databases? TCL – TCL statements, also known as Transactional Control Language statements, are used to manage various types of transactions that take place within a database.? BEGIN – opens a transaction? COMMIT – commits a transaction? ROLLBACK – refunds, or takes back, a transaction if there is an error