COURSE OVERVIEW
This course is designed to help a student prepare for a career as a database administrator in both web and non-web\base across multiple database. database management systems (DBMS) such as careers. ORACLE, MYSQL, MS-SQL server, POSTGRE-SQL, SQLite etc. Students are expose to the skills of programming and logic with a special reference to data relationship and transactional models to enable them gain mastery over the manipulation of data stored in a digital program in every kind of data processing system. Students will be taught how to use these skill to setup a business for themselves on the web or in any related discipline of their choice following their project.

SYLLABUS

Module 1: SQL 1&2
• Database, relational databases, data access
• Transaction, connection Basic select statements
• Arithmetic operations, restricting ROWS (Sorting), District keys, Column Aliases, Concatenation operation, alteration quote, comparison operations
• clause & variables
• functions, conditional operators
• Coalesce case, join statements, sub-queries, cross join
• Using DDL , DML ,DCL , User administration
• Privileges, external tables, Oracle –LOADER, DATA-PUMP
• Manipulating Large Data, multiple insert, using Flashback, using Rollback, commit

Module 2: ADMINISTRATION 1 & 2
• Server, Database Server & storage Architecture
• Processes (user & server process, creating database catalog
• Physical and logical storage
• Tables spaces, cloning database
• Listener control,Oracle Net service
• ASM Concept
• Recovery & Backup
• Back up concept II
• Recovery settings ,initialization & catalog
• RMAN Concept
• Performance Maintenance
• Database Backups,
• Database Recovery

PRE-REQUISTE
The course can be taken by a new student to the skills of computer science & database processing. Enrollment is restricted to people with the ability to read & write in basic English Language and it is ideal for anyone who is to be employed as database analysts & also website professionals, statisticians, project & inventory mangers & surveyors, scientist & system engineers. Every training is classified as a one-on-one hand on practical. Students must be ready to study individually or in group sharing tools & work theory.

COURSE FEE
Module 1 Duration 8 Weeks COST/FEES N40,000

MODULE 2 Duration 8 Weeks COST/FEES N40,000

MODULE 1 & 2 Duration 4 Months COST/FEES N70,000

VENUE : IMT COMPUTERS NIG LTD
2, MEDICAL ROAD IKEJA LAGOS
08039576767 08110604960
www.imtcomputer.net