Provided by: 123-CBT Computer Based Training SQL and PL SQL DML and DDL Click here for more information or to take this course

---

---

Training Provided by 123-CBT Computer Based Training

Course Overview

This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course, Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment, this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify these data objects. Learners also learn how to insert, update and delete data using SQL's Data Manipulation Language, and learn to control database transactions. Finally, the course teaches how to control both user and object level security in an Oracle database.

Learn To:

• Create tables and integrity constraints.
• Manipulate data using DML.
• Alter tables and constraints.
• Create sequences.
• Create views.
• Create indexes.
• Manage system privileges.

Content Emphasis

Skills-Based

Audience

Application Developers, Database Administrators, Designer/Developers, System Analysts, and Technical Support Professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. In addition, participants should have taken the first two courses in this series, Oracle SQL: Basic SELECT Statements (course 61110) and Oracle SQL: Data Retrieval Techniques (61111). This course will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer, Release 2.

Total Learning Time

6 - 8 Hour(s)

Course Contents

Unit 1: Creating Tables and Constraints

• Identify the main database objects and their structures.
• Reference the tables of another user when appropriate permission has been granted.
• Name database objects according the Oracle naming conventions and guidelines.
• Identify the syntax of the CREATE TABLE statement.
• Identify the use of constraints as a means of enforcing data integrity.
• Prohibit null values using the NOT NULL constraint.
• Define a unique constraint for a column to ensure that two rows do not contain the same value.
• Define a PRIMARY KEY constraint using the CREATE TABLE statement.
• Create a referential integrity constraint for a foreign key column.
• Define a check constraint to ensure that appropriate values are stored in the table.
• Create a table within the SQL*Plus environment.
• Create a table using the rows from an existing table.
• Display the structure of a table, using the DESCRIBE command.

Unit 2: Manipulating Data

• Identify the DML functions and the transaction control commands.
• Insert new rows in a table.
• Insert specific date, time, and user values in a table.
• Insert rows from one table into another table.
• Update a row without violating the integrity constraints for that table.
• Update an entire column in a database table.
• Delete rows from a table.
• Identify the actions that start and end a transaction.
• Execute the COMMIT, SAVEPOINT, and ROLLBACK statements.
• Roll back pending data changes.
• Rollback pending changes to a specified savepoint.

Unit 3: Altering Tables and Constraints

• Add a new column to an Oracle database table by using the ALTER TABLE statement.
• Modify the columns of an Orac

  ---

  Training Avaliability and Delivery

  This is primarily online training This is an online eLearning or CBT training program This program may be available on CD Contact 123-CBT Computer Based Training for more information

  Training Presented in: English

  ---

  Related Keywords:  oracle   designer   sql   dml   ddl 

  ---

  Training Program Details

  ---

  --

  ---

  About 123-CBT Computer Based Training - Training Provider

  123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6.10 - Access 2003 - Acrobat 6.0 - ASP - ASP.NET - C - Captivate 1.0 - Crystal Reports 8.5 - Crystal Reports v10 - Dreamweaver MX -...

  ---

  More Oracle Designer R6 6i Training from 123-CBT Computer Based Training

  • Oracle Designer 6i Curriculum
  • Oracle Designer 6i First Class Analysis
  • Oracle Designer 6i First Class Design Generation
  • SQL and PL SQL Basic SELECT
  • SQL and PL SQL Data Retrieval Techniques
  • SQL and PL SQL PL SQL Basics

  ---

  Click here for more information or to take this course

  ---