Certificate in Database Management

Overview:

The need for systematic, careful storage of massive volumes of a vast array of data, and efficient data retrieval from internet, intranet and extranet databases, and the increasingly sophisticated infrastructure of today’s organizations and institutions have led to a heavy dependence on new and improved storage technology. However, in addition to being versatile, modern database servers can be complex and relatively expensive and require expertise to run.

Mentortech’s Database Management Certificate Programme provides one main track for general information on Relational Database Management System and SQL (common language for all modern database system, necessary for database administrators as well as programmers). Participants are introduced to the logical and physical aspects of database design. Various indexing technologies and RAID will also be extensively covered. There are also elective tracks for Microsoft, Oracle and MySQL for participants requiring product base information. In particular administration aspects, database security and performance tuning aspects will be covered. Participants are expected to register for at least two modules from any tracks lasting a total of at least 6 days (36 hours) to qualify for the certificate.


SQL Concepts and Core Technologies:

D101 SQL Programming - 3 days (18 hours)
D102: Relational Database Concept and Design - 3 days (18 hours)

Microsoft Technologies:

M215a: Microsoft SQL 2000 Server Programming, 4 days (24 hours)
M215b: Microsoft SQL 2000 Server Administration, 4 days (24 hours)
M215c: Using Transact-SQL for Microsoft SQL Server 2000, 2 days (12 hours)

Free and Easy – MySQL:

J223a: MySQL Programming and Administration - 5 days (30 hours)

Oracle:

D202: Oracle for Database Administrator - 3 days (18 hours)
D203: Building Oracle8i Applications with Developer and PL/SQL – 3 days (18 hours)