Syntax Differences between SQL and Other DBMS Research - 550 Words

Syntax Differences between SQL and Other DBMS Research (Coursework Sample) Content: Syntax Differences between SQL and Other DBMS NameInstitutionInstructorCourseDateIntroductionStructured 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 wordsReserved 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 wordsOne should try to avoid spaces as much as possible and to handle spaces in word, one can use underscore.Case sensitivity and its importantItà ¢Ã¢â€š ¬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 systemsDifferent databases use different syntax and not all databases use the same SQL syntax for example in spe cifying 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 exampleMS Access /SQL Server SyntaxSELECT TOP number|percent columnname(s)FROM table_name;MySQL syntaxSELECT column_name(s)FROM table_nameLIMIT number;Oracle syntaxSELECT column_name(s)FROM table_nameWHERE ROWNUM = number;For example to return the first eight rows of a query from a table called employeesMySQL Oracle MS Access /SQL ServerSELECT *SELECT *SELECT TOP 8FROM employeesFROM employeesFROM employees;LIMIT 8;...