Oracle9i SQL 1Z0-007
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 SQLProvides 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…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Syllabus
INTRODUCTION TO SQLProvides 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.
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.