Why Oracle (SQL,PL/SQL)?
PL/SQL is a combination of SQL along with the procedural features of programming languages.It was developed by Oracle Corporation in 1990's to enhance the capabilities of SQL. SQL is the standard database language and PL/SQL is strongly integrated with SQL. PL/SQL supports both static and dynamic SQL. Static SQL supports DML operations and TCL. In Dynamic SQL ,SQL allows embedding DDL statements in PL/SQL block PL/SQL saves time on design and debugging by strong features, such as exception handling. PL/SQL provides supports for developing Web applications and Server Pages. Pre-Requisites to Learn PL/SQL: You should have Basic understanding of Software basic concepts like What is database, source code, text editor and understanding on SQL and other programming language. Anyway in this course we will cover SQL concepts with understanding DBMS, RDBMS