Oracle Database 11g Database Fundamentals
Code: ORACLEFun
Awarding Body: Oracle
Duration: 7 weeks - 2 nights per week
Award Type
Special Purpose
Award title
Certificate in Oracle Database 11g Fundamentals
NFQ level of award
6
Minimum entry requirements
Certificate in Introduction to Oracle or equivalent experience with Oracle
Schedule
Monday & Wednesday
Fee
€1,195
Starts
Oct, Jan, Apr
SPECIAL OFFER!
Combine the Oracle Database Fundamentals Course with Oracle Database Administration
for the competitive price of €2400
Oracle Database 11g SQL Fundamentals
- This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g.
- Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.
- Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.
Pricing
- Students have the option of combining the Oracle Database Fundamentals Course with Oracle Database Administration for the competitive price of €2400. Class sizes are small and our tutors are highly qualified experts in their field.
Company Comments this year
- "The tutor is very fast and keeps you on your toes but she is very enthusiastic about what she is teaching so I think it is rubbing off on me, she also makes it sound interesting. I'm looking forward to tonight's class and I don't ever remember feeling like that back in college, hopefully it lasts!"
Exam Topics
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data from Multiple Tables
- Using Subqueries to Solve Queries
- Using the Set Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
Oracle Certification Path
