Reference no: EM131708077

"Advanced SQL and PL / SQL" Please respond to the following:

Extracting and interpreting data can be very valuable to an organization. Describe the importance of using sub queries in a database system. Provide at least two business case scenarios to support your response.

A good IT professional is able to be versatile in SQL programming styles. Identify at least two possible advantages of utilizing PL / SQL instead of standard SQL Syntax. Explain whether either syntax provides enhanced code processing capabilities with examples. Note: The Strayer Oracle Server may be used to test and compile the SQL Queries developed.

Classmate:

Extracting and interpreting data can be very valuable to an organization. Describe the importance of using sub queries in a database system. Provide at least two business case scenarios to support your response.

Sub queries are multi-layered queries where one queue is located in (and restricts the results of) another queue (namely in its WHERE section). Such cascade of queries can consecutively filter and limit the query results in order to reach required degree of precision - where results of one query are used as data for the embedded sub query.

Such capabilities are useful for business tasks of gathering employee information which was originally located across different tables responsible for different parameters each, as well as from selecting precise pieces of data all at once from multiple, separate tables.

A good IT professional is able to be versatile in SQL programming styles. Identify at least two possible advantages of utilizing PL / SQL instead of standard SQL Syntax. Explain whether either syntax provides enhanced code processing capabilities with examples.

PL/SQL is an interesting addition (or should we say upgrade) to SQL, which adds extra capabilities, such as the ability to use object-oriented programming constructs (such as functions, procedures, conditionals, and loops) alongside default SQL statements and queries. PL/SQL is a fully portable language, and the degree of integration between PL/SQL and standard SQL allows to directly use the data types without the need of conversion.

According to Paul, the optimized use of data units allows to save database roundtrip, which provides PL/SQL with increased efficiency and productivity. Additionally, data types such as VARCHAR2 and NUMBER can be used with PL/SQL (2011). Overall, despite keeping integration with SQL, PL/SQL is also considered to be more flexible and more secure.