![]() |
100% Guaranteed or Your Money Back! | ![]() |
**NOTE** All Online Course Tutorials require Internet Explorer 5.0 or higher and the Macromedia Flash 4.0 or higher plugin installed as they will not work with AOL, Netscape or Mozilla browsers.**
Oracle 9i SQL 1Z0-007 Online Course Tutorial Details
Total Lessons: 11
Total Time: 24 hour(s)
Subscription Term: 12 month(s)
Summary:
This series is designed to help those who have some experience with relational databases to prepare for the Oracle9i 1Z0-007 exam.
Features and Benefits of our Tutorial:
* Exercises that allow users to practice the application
* A file containing the text of the exercises
* Activities that allow users to apply course concepts in an interactive questioning environment
* Simulations that allow users to practice course skills, even if they don't have access to the application
* A glossary
* A Skill Assessment
Lesson 1 Introduction to SQL - 3 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 2 Intermediate Queries - 2 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 3 Queries with Single-Row Functions - 2 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 4 Combining Tables - 2 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 5 Grouping and Summarizing Data - 1 hour
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 6 Advanced Queries and Views - 2 hours
Objectives: After completing this lesson, students will be able to:
* List the types of subqueries
* Use subqueries in Oracle SQL commands
* Add and drop views
* Change views
* Modify data using views
Lesson 7 Working with Data - 2 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 8 Creating Tables and Constraints - 2 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 9 Database Objects and User Security - 3 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 10 SQL*Plus And iSQL*Plus Reporting and PL/SQL - 3 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 11 Practice Exam - 3 hours
Objectives: After completing this lesson, students will be able to:
*Practice for and evaluate your current skill level for the Oracle9i SQL 1Z0-007 Exam
Oracle 9i SQL 1Z0-007 Online Course Tutorial Details
Total Lessons: 11
Total Time: 24 hour(s)
Subscription Term: 12 month(s)
Summary:
This series is designed to help those who have some experience with relational databases to prepare for the Oracle9i 1Z0-007 exam.
Features and Benefits of our Tutorial:
* Exercises that allow users to practice the application
* A file containing the text of the exercises
* Activities that allow users to apply course concepts in an interactive questioning environment
* Simulations that allow users to practice course skills, even if they don't have access to the application
* A glossary
* A Skill Assessment
Lesson 1 Introduction to SQL - 3 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 2 Intermediate Queries - 2 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 3 Queries with Single-Row Functions - 2 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 4 Combining Tables - 2 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 5 Grouping and Summarizing Data - 1 hour
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 6 Advanced Queries and Views - 2 hours
Objectives: After completing this lesson, students will be able to:
* List the types of subqueries
* Use subqueries in Oracle SQL commands
* Add and drop views
* Change views
* Modify data using views
Lesson 7 Working with Data - 2 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 8 Creating Tables and Constraints - 2 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 9 Database Objects and User Security - 3 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 10 SQL*Plus And iSQL*Plus Reporting and PL/SQL - 3 hours
Objectives: After completing this lesson, students will be able to:
* 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
Lesson 11 Practice Exam - 3 hours
Objectives: After completing this lesson, students will be able to:
*Practice for and evaluate your current skill level for the Oracle9i SQL 1Z0-007 Exam
| Now Accepting |
![]() |
![]() |
![]() | |
| Avaya | |
| Avaya | |
| Check Point | |
| CCSA NGX | |
| CCSE NGX | |
| CCMSE | |
| CCSPA | |
| Cisco | |
| CCDA | |
| CCDP | |
| CCIP | |
| CCNA | |
| CCIE LAB | |
| CCSP | |
| CCNP | |
| CCVP | |
| Citrix | |
| CCEA XP | |
| CCEA 4.0 | |
| CompTIA | |
| A+ | |
| Security+ | |
| CTT+ | |
| Network+ | |
| Server+ | |
| Linux+ | |
| Project+ | |
| RFID+ | |
| CWNA | |
| CWNA | |
| CWSP | |
| ISC | |
| CISSP | |
| SSCP | |
| Juniper | |
| JNCIA | |
| JNCIS | |
| Microsoft | |
| MCDBA | |
| MCP | |
| MCSD .NET | |
| MCSE | |
| MCAD .NET | |
| MCSA 2003 | |
| MCSE 2003 | |
| MCSE 2003 Security | |
| MCDST | |
| MCSE 2003 Messaging | |
| MCITP | |
| MCPD | |
| MCTS | |
| Nortel | |
| NCDE | |
| NCDS | |
| NCSE | |
| NCSS | |
| Oracle | |
| Oracle 9i DBA | |
| 10g DBA | |
| PMI | |
| Project Management Professional | |
| Red Hat | |
| RHCE | |
| Sun | |
| Solaris 9 SCSA | |
| SCJP | |
| Solaris 10 SCSA | |
| SUN SCJD | |
| VMware | |
| VMware VCP | |
| * Training |
| * Courses |
| * Jobs |
| * Software Directories |
![]() |
||||||
| ||||||
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |

![]() |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() Follow Us On Facebook |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||


















