|
|
|
Oracle9i SQL 1Z0-007 Training Online
 |
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. |
|
| |
Product Duration: 12 Months Unlimited Access |
Price |
Add to Cart |
| |
Oracle9i SQL 1Z0-007 Training
This online training is for anyone who is interested in learning more about Oracle9i SQL.
|
£199.99
|
|
|
| Oracle9i SQL 1Z0-007 Course Lessons: |
Oracle9i SQL 1Z0-007: Introduction
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
|
|
Oracle9i SQL 1Z0-007: Intermediate Queries
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
|
|
Oracle9i SQL 1Z0-007: Queries with Single-Row Functions
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
|
|
Oracle9i SQL 1Z0-007: Combining Tables
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 nonequality 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
|
|
Oracle9i SQL 1Z0-007: Grouping and Summarising Data
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
|
|
Oracle9i SQL 1Z0-007: Advanced Queries and Views
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
|
|
Oracle9i SQL 1Z0-007: Working with Data
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 behavior
|
|
Oracle9i SQL 1Z0-007: Creating Tables and Constraints
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 contraints
Add comments to SQL scripts and schema objects
|
|
Oracle9i SQL 1Z0-007: Database Objects and User Security
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
|
|
Oracle9i SQL 1Z0-007: SQL*Plus And iSQL*Plus Reporting and PL/SQL
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
|
|
Oracle9i SQL 1Z0-007: Exam Preparation
This section tests your knowledge with mock exam questions and answers
|
|
|
If you have a question about our Oracle9i SQL 1Z0-007training or any other careers or training courses
just phone us on 0871 222 8790 (Hotline Available NOW 24 hours a day, 7 days a week!) or fill in the simple form below and we will contact you shortly.
|
Telephone: 0871 222 8790 (Hotline Available NOW 24 hours a day, 7 days a week!)
Alternate Number: 01279 814 876
Fax: 01279 816 093
E-Mail: info@e-careers.co.uk
Address:
10 Riverside Business Park,
Stony Common Road,
Stansted Mountfitchet,
Essex,
CM24 8PL
|
What do I get?
Within 30 minutes of placing your order you will receive a username and password and a link to access all of the following:
Interactive simulations
Feel like you are actually using the software you are being trained about in the added security of our learning environment.
Skills Assessments
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn
Printable reference guides and exercises
Every chapter has its own hands on exercises for you to carry out to help you gain essential experience. You also have automatic glossary and search features to help you use the course as a 'quick reference' guide
Full telephone and email support with no premium rate charges
Our friendly support team is here on hand 9.30am-4.30pm to help you out if you get stuck
Free upgrades for 12 months
For the duration of your 12 months license you will receive any updates we make to your course free of charge. Sign up for our complete package and you will be able to receive all the new courses we add free of charge.
Best price in UK guaranteed
We are so confident that you will not find another online training service of the same quality and price that we will beat any legitimate quote on a like for like basis by 10%.
|
