2KO South Africa offers
the following Oracle 11g SQL Fundamentals course in Cape
Town. 2KO presents Oracle certification courses in Cape
Town by means of full time instructor-led training; as
well as internet-accessible online training , which are
aimed at International IT Certification exams. 2KO International (Coalition Trading) offers computer training throughout Africa, and is a leading supplier of IT certification and online IT courses, enabling 2KO students the opportunity to study courses online world-wide, to ensure the best Oracle training.
Oracle 11g SQL Fundamentals
This course introduces students to the fundamentals of
SQL using Oracle Database 11g database technology. In
this course students learn the concepts of relational
databases and the powerful SQL programming language.
This course provides the essential SQL skills that allow
developers to write queries against single and multiple
tables, manipulate data in tables, and create database
The students also learn to use single row functions to
customize output, use conversion functions and
conditional expressions and use group functions to
report aggregated data. Demonstrations and hands-on
practice reinforce the fundamental concepts.
In this course, students use Oracle SQL Developer as the
main tool and SQL*Plus is introduced as an optional
tool. This course counts towards the Hands-on course
requirement for the Oracle Database 11g Administrator
Certification. Only instructor-led in class or
instructor-led online formats of this course will meet
the Certification Hands-on Requirement. Self Study
CD-Rom and knowledge Centre courses DO NOT meet the
Who should do this course?
Anyone who would like to get to grips with Oracle
Students who like to work in an Oracle environment or
become a DBA
Students wishing to get Oracle certification
NB: This course can be tailored for application
designers and developers, database administrators, and
business users and non-technical end users.
Course pre-requisites Computer literacy and data structure
Duration 5 Days
ORACLE COURSES ARE SUBJECT TO A MINIMUM OF 3 DELEGATES
ATTENDING THE COURSE
What books do I get with this course?
You will receive a course text book which you can take
away with you to keep after the course.
How long will it take me to get certified?
We recommend that students take at least one to two weeks
for exam preparation for every module they do. It is unusual for
students to be able to take the exam in the same week they do the
Does the price include the official exam?
No, the exam is not included in the price. Exam prices
vary from centre to centre.
All 2KO Africa training centres are test centres as well. The exam
is a multiple test, on computer at an authorized testy centre. The
results are made known immediately. If you fail the test, you must
book it again at a future date and will pay again.