COURSE DETAILS
In this global world nothing can be thought without computers and for connecting them we need large and dedicated network based on different Operating System. Diploma in Systems & Database Administration (DSDA) programme is a six months(24 weeks) programme designed to fulfill the requirement of skilled manpower in the field of Networking, Database Administration and related technologies especially for installation, configuration & administration of different OS & Servers.

ELIGIBILITY CRITERIA
Students who have passed 10th standard are eligible to pursue this course. 

SYLLABUS
To get a better idea about the course structure, let us go through a list of important subjects present in this program. Note: Only the important subjects have been mentioned. Topics covered in our Oracle course:

• Introduction to Oracle programming Introduction to Oracle firm and its way of working, Oracle products and their components, and Oracle's relationship database management system (RDBMS).
• Oracle RDBMS SQL *Plus – which is the most basic database utility product by SQL having a simple command line interface; Comparison between SQL, PL/SQL and SQL *Plus; and working in the SQL*Plus environment .
• DataTypes in Oracle In this chapter, all the Oracle supporting Data types and Data conversion methods will be covered in detail with their definition.
• Data Retrieval Using SQL Select queries, Single row functions and Multi table Queries.
• Data Manipulation Language Altering or Modifying tables in detail.
• Transaction processing How a Transaction processing begins and ends in detail.
• Oracle Definition Language Creating and managing tables as well as indexing and clustering of the tables.
• Oracle Database Objects Indexes, Views, Synonyms and Sequences in detail.
• PL/SQL Introduction of PL/SQL, Control structures of PL/SQL and Composite data types in PL/SQL.
• Explicit cursors Various types of cursors, Parameterized Cursors and Cursor Variables in detail.
• Packages and Database Triggers Package's specification, body, scope, initialization; and Creating Triggers, Types of triggers, etc.
• Exception Handling At last in our Oracle course, we will go through Predefined exceptions, User defined exceptions, Handling exception and RAISE_APPLICATION_ ERROR Procedure in detail.