MySQL Oracle Course

MsAccess / Oracle / MySQL all are the part of RDBMS (Relational Database Management System) software. It aids costumers to handle a massive amount of data with high defined security and low access time.

Today, MySQL is the vey used open source relational database management system which is commonly known as RDBMS. Learn how to put advanced features and management tools to get the highest levels of MySQL scalability, safety and trust in your database management system.

Course Content:

• Introduction to DBMS
  • Database Types
  • Packages
  • Elements
  • Introduction to Oracle
  • Versions of Oracle
  • Edition of Oracle
• SQL
  • Elements (Datatypes, Operators, Clause)
  • Sublanguages (DDL, DML, DCL, TCL, DQL)
  • Joining & Set Operation
  • Functions (Pre Defined)
  • Sub Queries
  • Objects (View, Synonym, Index, Sequence)
• PL/SQL
  • Elements
  • Control Structure
  • Function & Procedure
  • Package
  • Exception Handling
  • Cursor & Trigger