• AddressDildar Nagar, GZP 232326
  • Email nimactdildarnagar@rediffmail.com
  • Contact+91 63066 78842, +91 9415864602
📚 Bharat Ratna Dr. APJ Abdul Kalam Library — The only library in this area with thousands of books, a complete knowledge hub for students and readers. 📚 Bharat Ratna Dr. APJ Abdul Kalam Library — The only library in this area with thousands of books, a complete knowledge hub for students and readers.

DDA - Diploma in Database Administration

  • Home
  • DDA - Diploma in Database Administration
DDA - Diploma in Database Administration
  • Fee: 4200
  • Timing: 2.5 Hours Per Day
  • Duration: 6 Months

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.