Prev Next

DATABASE ADMINISTRATION AND DEVELOPMENT

 

program-me  is  tailored to  provide the relevant skills for database administrators, developers  and programmers  by providing the practical skills required for  Developing, analyzing and structuring database environments and implementations .

Areas of deployments:

  • Database Administration
  • System administration
  • Report Generation and Analysis
  • data mining
  • Database programming

 

COURSE STRUCTURE

 

STAGE I

UNIT: Introduction to databases

-          History of databases

-          applications

-          normalization

-          data mining

-          database administration

-          models

-        dbms systems

 

UNIT: Structured query language (SQL)

-          Data definition statements

-          Data manipulation statements

-          Utility statements

-          Transactional and Locking statements

-          Administration statements

-          Replication statements

-          Prepared statements

UNIT: Implementations

-          Ms Sql Server

-          MySql

EXAM

STAGE II

UNIT: Administration Environments

-          Oracle MySql tools

-          MS Sql Server tools

-          Php MyAdmin

UNIT: Oracle Database

-          Environments

-          Administration

-          Programming

-          Security

UNIT: Database Visual Programming

-          Implementation using Visual Basic

-          Implementation using Java

-          Implementation using php

EXAM

STAGE III

UNIT: Database Report analysis

-          Language default reporting tooling

-          Crystal reports

-          Jasper reports

UNIT: Custom Reporting

-          Cascading style sheets

-          Formatting JSon & xml

-          Xsl Transformations(Xslt, Xpath, XQuery and Xsl-Fo)

UNIT: PDF automation and Transformation

EXAM

 

Recommended:

Aim

- Skills/Practical based

Delivery

- Presentations practical exercise

Duration:

- 6 - 12 months

- OR 140 - 240 contact Hours