ORACLE DATABASE ADMINISTRATION LEADING TO OCA and OCP
COURSE FEE
Module 1 Duration 8 Weeks COST/FEES N50,000
MODULE 2 Duration 8 Weeks COST/FEES N50,000
MODULE 1 & 2 Duration 4 Months COST/FEES N90,000
Venue : IMT 2, Medical road Ikeja OPP SLOT 08039576767
INSTALMENTAL PAYMENT ALLOWED
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-SQLserver, 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.
Financial Restoration Through the help of benjamin lee. Email: 247officedept@gmail.com that's his Email and this is his whatsapp number +1-989-394-3740 . I'mLeonardo Hugo a agronist who was able to revive his dying Livestock Feed Manufacturing through the help of a GodSent lender known as Benjamin Briel Lee the Loan Officer. I want you to know that his Service is the right place for you to resolve all your financial problem because am a living testimony and I can't just keep this to myself when others are looking for a way to be financially lifted. I want you all to contact this God sent lender using the details as stated in other to be a partaker of this great opportunity and also they work with good/reputable bank that wire money transfer without delay into my account.
ReplyDelete