Welcome to the e-Learning Oracle 9i SQL 1Z0-007 course powered by XYZ.co.uk. Classroom versions of this course are also available. If you would like us to host a e-Learning Oracle 9i SQL 1Z0-007 course at your premises, at a location, date and time of your choosing – then please complete this form.

e-Learning Oracle 9i SQL 1Z0-007

At eLearning.co.uk all of our courses are delivered online. This gives you the opportunity to study at your own pace and within your own time. Online learning allows you to study in the evenings, weekends, or even the odd hour during the day! With each course you will have full tutor and technical support available via the telephone and by e-mail – so you are not on your own by any means. This e-Learning Oracle 9i SQL 1Z0-007 course will award you with the same certification as the classroom version of this course – usually for a cheaper cost and with the additional benefit of flexible study times!

Once you’ve decided to go ahead and enrol on this e-Learning Oracle 9i SQL 1Z0-007 course, you will receive an e-mail shortly after containing your user name and password, receipt of payment and full course joining instructions. Use this with the link/url provided in the e-mail and you can log into the online training system and begin learning right away. This e-Learning Oracle 9i SQL 1Z0-007 online learning course will use various interactive features and different types of media to enable you to stay engaged whilst learning. The course has been designed to be simple to follow and solely with the user in mind – so don’t worry about the technical side of things.

If you want to learn a little more about e-Learning in general, watch the video below. If you want to know more about your chosen course, please scroll down.

This Oracle9i SQL 1Z0-007 training is designed to help those who have some experience with relational databases to prepare for the Oracle9i 1Z0-007 exam.

This online training is for anyone who is interested in learning more about Oracle9i SQL.

About the course

• This course provides an introduction to the Oracle9i relational database management system and basic database concepts. Understand basic database concepts List new SQL features in Oracle9i Use the four available SQL Plus tools Enter and execute basic queries using the SELECT command

Intermediate Queries - Duration 2 Hour(s)

• This course provides information about using the SELECT statement and using the WHERE and ORDER BY clauses in Oracle9i SQL. Use the WHERE clause to filter out rows from query results Format query results Use multiple filters in a query Query the DUAL table Sort query results using the ORDER BY clause Handle null values in query results

Queries with Single-Row Functions - Duration 2 Hour(s)

• This course examines the types and uses of functions available for various data types in Oracle9i SQL. Describe the most commonly-used functions available in SQL Use character, number, and date functions in SELECT statements Use conversion functions Find online documentation for more information about functions as needed

Combining Tables - Duration 2 Hour(s)

• This course examines joining tables in Oracle9i SQL using the ANSI format JOIN clause and the Oracle proprietary format. Write SELECT statements to access data from more than one table using equality and non-equality joins View data that generally does not meet a join condition by using outer joins Join a table to itself using a self join Create various types of join queries Identify the differences between Oracle proprietary format and ANSI format for joining tables

Grouping and Summarising Data - Duration 1 Hour(s)

• This course examines the summarising of query results into groups using the GROUP BY clause in Oracle9i SQL. Explain how group functions work Use aggregate functions Use DISTINCT and ALL clauses Group and sort rows using the GROUP BY clause Use the HAVING clause to restrict data Use the ROLLUP, CUBE, and GROUPING SETS clauses

Advanced Queries and Views - Duration 2 Hour(s)

• This course provides an in-depth look at using subqueries and views in Oracle9i SQL. List the types of subqueries Use subqueries in Oracle SQL commands Add and drop views Change views Modify data using views

Working with Data - Duration 2 Hour(s)

• This course examines the four main commands used in SQL to add, modify, remove, and merge rows of data in database tables. Distinguish between Oracle9i and user-defined datatypes Use the four Oracle9i DML commands INSERT, UPDATE, DELETE, and MERGE Understand transactions and the commands used to manipulate their behaviour

Creating Tables and Constraints - Duration 2 Hour(s)

• This course examines creating and changing tables and defining constraints on tables in Oracle9i SQL. Create, modify, rebuild, and remove tables Use the TRUNCATE command Create, modify and drop constraints Use primary key constraints Use foreign key constraints Add comments to SQL scripts and schema objects

Database Objects and User Security - Duration 4 Hour(s)

• This course examines how to create database objects including sequences, synonyms, and indexes in Oracle9i SQL. It also covers sharing table data with other users through privileges and roles. Create, modify, and delete sequences Create, modify, and delete synonyms Create, modify, and delete indexes Create, modify, and delete users Grant and revoke system and object privileges Create, grant, revoke, enable, disable, and delete roles

SQL*Plus And iSQL*Plus Reporting and PL/SQL - Duration 3 Hour(s)

• This course examines how to use environment settings, variables, and special SQL Plus commands to generate professional looking reports in Oracle9i SQL. Create a well formatted report with SQL Plus Know when and how to use variables Use iSQL Plus Use Top-N Analysis Identify the basic concepts of PL/SQL

Exam Preparation - Duration 1 Hour(s)

• This section tests your knowledge with mock exam questions and answers

Qualification

Oracle 9i SQL 1Z0-007

Course study options

Course Study Format
This course is delivered through online method. The course is available for you to complete at your convenience over a 12 month period.

IT Training Course Tutor Support
Home study courses include step by step online training and keyword search facilities.
Our Interactive online IT Training courses will take you step by step though your chosen eLearning courseware using show and ask training methods.

Study Hours
This is only an approximate figure and is dependent upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material.

Technical Requirements

• Windows: Windows 98, 2000, XP, Vista, Windows 7 – Acrobat Reader 4.0 and above
  OR
  Macintosh: Mac OS X, Mac OS 9.2 – Acrobat Reader 4.0 and above
• An up to date internet browser such as Internet Explorer, Mozilla Firefox, or Safari.
• Internet connection (broadband recommended.)

Cost - Per Person

Make An Enquiry Or Book This Training Here