Syntax Differences between SQL and Other DBMS Research (Coursework Sample)

Syntax Differences between SQL and Other DBMS NameInstitutionInstructorCourseDate
Introduction
Structured Query Language (SQL) punctuation refers to rules, guidelines, syntax and standard procures that are followed by the SQL in accessing, defining, and manipulating of the database. This paper discusses the SQL reserved words, how to handle spaces in SQL, case-sensitivity, and the SQL syntax differences between different Database Management systems.
Reserved words
Reserved words are part of grammar of the Transect- Structured Query Language (SQL), used by SQL server to understand and parse SQL batches and statements. They are also used for defining, accessing and manipulating of databases. For example CREATE, DROP, ALTER, and UPDATE.
What to use to handle spaces in words
One should try to avoid spaces as much as possible and to handle spaces in word, one can use underscore.
Case sensitivity and its important
It’s a function of database collation setting that if it’s case-sensitive in the SQL server then the table names must be case-sensitive and vice vasa. But SQL is not case sensitive. For example in SQL, select is the same as SELECT. Case sensitivity is important since in most cases words differ in meaning based on lowercase and uppercase letters.
SQL punctuation differences between DBMS like MYSQL, Access, and Oracle are very many, for example MySQL stored procedures has very basic features, limited scalability, and during run time are interpreted in session threads while Oracle has advanced features that are compiled or interpreted and is extremely scalable. DBMS in each database has different punctuations and they offer different choices for data type definition for example Boolean data type in Access (Yes/No), SQL server (bit), MySQL not applicable, and Oracle (Byte).
How SQL syntax differs between database management systems
Different databases use different syntax and not all databases use the same SQL syntax for example in specifying the number of records to return, we use SELECT TOP in SQL server and MS access. But in Oracle and MySQL the syntax is different. For example
MS Access /SQL Server Syntax
SELECT TOP number|percent columnname(s)FROM table_name;
MySQL syntax
SELECT column_name(s)FROM table_nameLIMIT number;
Oracle syntax
SELECT column_name(s)FROM table_nameWHERE ROWNUM <= number;
For example to return the first eight rows of a query from a table called employees
MySQL Oracle MS Access /SQL Server
SELECT *SELECT *SELECT TOP 8FROM employeesFROM employeesFROM employees;LIMIT 8;...