SQL- Advanced

SQL advanced is leading now a days. SQL is a platform independent and is being used in almost all the databases.

As you know some of the powerful data bases leading the world are:

(Source IOUG)- Leading databases for Internal and External access.

Oracle 9i              86% 69%
 Microsoft SQL Server  57% 34%
 Oracle 10g            54% 32%
 Oracle 8i             50% 23%
 Microsoft Access      26% 5%
 IBM DB2              18% 5%
 MySQL                16% 11%
 Oracle 8             13% 4%
 Sybase                11% 4%

I benefiited,  you too can benefit just grab this book at discount price.

There may be many other legacy databases like: IMSDB, ADSO, Terradata, Tandem etc. However,all the leading bases are relational, so, SQL is acting as a key role.

So, if you want to success in your future career, you must be strong on SQL.

What are the advanced concepts?

  • Procedures
  • Functions
  • Triggers

I will describe in my next posts about all the SQL advanced topics.

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.