Oracle9i SQL 1Z0-007

Product type
Logo Elearn UK
Provider rating: starstarstarstarstar 10 Elearn UK has an average rating of 10 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Description

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

Syllabus

INTRODUCTION TO SQL

Provides an introduction to the Oracle9i relational database management system and basic database concepts.
  • Basic database concepts
  • SQL Plus command line
  • SQL Plus window
  • SQL Plus worksheet
  • iSQL Plus
  • Using the SELECT statement
  • Writing SQL commands
  • Writing queries

INTERMEDIATE QUERIES

Provides information about using the SELECT statement and using the WHERE and ORDER BY clauses in Oracle9i SQL.
  • Using the WHERE clause
  • Formatting query results
  • Using multiple filters
  • Dual and pseudocolumns
  • Using the ORDER BY clause
  • Sorting rules for…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, Database Management, PL/SQL, Programming (general), and IT Security.

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

Syllabus

INTRODUCTION TO SQL

Provides an introduction to the Oracle9i relational database management system and basic database concepts.
  • Basic database concepts
  • SQL Plus command line
  • SQL Plus window
  • SQL Plus worksheet
  • iSQL Plus
  • Using the SELECT statement
  • Writing SQL commands
  • Writing queries

INTERMEDIATE QUERIES

Provides information about using the SELECT statement and using the WHERE and ORDER BY clauses in Oracle9i SQL.
  • Using the WHERE clause
  • Formatting query results
  • Using multiple filters
  • Dual and pseudocolumns
  • Using the ORDER BY clause
  • Sorting rules for null values

QUERIES WITH SINGLE-ROW FUNCTIONS

Examines the types and uses of functions available for various data types in Oracle9i SQL.
  • String functions
  • Number functions
  • Date functions
  • Miscellaneous functions
  • Conversion functions
  • Combining functions

COMBINING TABLES

Examines joining tables in Oracle9i SQL using the ANSI format JOIN clause and the Oracle proprietary format.
  • Joining tables
  • Cross joins
  • Natural joins
  • The USING and the ON clause
  • Outer joins
  • Left outer joins
  • Right outer joins
  • Self joins
  • Other types of joins

GROUPING AND SUMMARIZING DATA

Examines the summarizing of query results into groups using the GROUP BY clause in Oracle9i SQL.
  • The GROUP BY clause and group functions
  • Aggregate functions
  • Grouping rows and sorting with GROUP BY
  • Restricting Data
  • Extending the GROUP BY clause

ADVANCED QUERIES AND VIEWS

Provides an in-depth look at using subqueries and views in Oracle9i SQL.
  • Subqueries
  • Types and uses of views
  • Simple, constraint and complex views
  • Changing and dropping views
  • Working with views
  • Inserting, updating and deleting in views

WORKING WITH DATA

Examines the four main commands used in SQL to add, modify, remove, and merge rows of data in database tables.
  • Datatypes
  • Data Manipulation Language
  • Using transactions
  • Adding and changing data
  • Deleting and merging data

CREATING TABLES AND CONSTRAINTS

Examines creating and changing tables and defining constraints on tables in Oracle9i SQL.
  • Creating tables
  • Relational and temporary tables
  • Adding comments
  • Changing table structures
  • Renaming, truncating and dropping tables
  • Constraints
  • Primary key, unique and foreign key constraints
  • Table level and check constraints
  • Adding, modifying and dropping constraints

DATABASE OBJECTS AND USER SECURITY

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.
  • Working with sequences
  • Working with synonyms
  • Understanding indexes
  • Working with indexes
  • Understanding users
  • Working with users
  • Granting privileges
  • Revoking privileges
  • Creating, granting, and revoking roles
  • Enabling, disabling, and dropping roles

SQP *PLUS AND ISQL* PLUS REPORTING AND PL/SQL

Examines how to use environment settings, variables, and special SQL Plus commands to generate professional looking reports in Oracle9i SQL.
  • SQL Plus reports
  • Environment settings
  • Using environment settings
  • Variables and scripts
  • Generating reports
  • Reporting features
  • Running reports
  • Top-N queries
  • PL/SQL
  • Retrieving data in PL/SQL
  • Dynamic SQL
  • Control structures
  • Iteration and repitition

PRACTICE EXAM

Provides questions to prepare users who plan to take exam 1Z0-007: Introduction to Oracle9i: SQL.
  • SQL Plus reports
  • Writing basic SQL select statements
  • Restricting and sorting data
  • Single-row functions
  • Displaying data from multiple tables
  • Aggregating data using group functions
  • Subqueries
  • Producing readable output with iSQL Plus
  • Manipulating data
  • Creating and managing tables
  • Including constraints
  • Creating views
  • Creating other database objects
  • Controlling user access

Qualifications

Qualification: Printable Transcript

On completion of this course you may print a transcript off as evidence of your progression throughout the course.

Requirements for Entry

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Study Options

If you do not have Internet access, or would prefer to study this course via the traditional paper/postal based study method, you can find more information on the course by clicking on the link below.

Study Hours

This is only an approximate figure and is dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material. Furthermore, at the end of each lesson there is a question paper that needs to be completed and returned to your tutor. You should allow at least 1 - 2 hours of study to complete each question paper.

The approximate amount of time required to complete the course is: 40 hrs.

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.