0121-oracle-database-11g-sql-fundamentals-course.pdf

(2174 KB) Pobierz
Oracle Database 11g: SQL
Fundamentals I
Electronic Presentation
D49996GC11
Edition 1.1
April 2009
Authors
Puja Singh
Brian Pottle
Copyright © 2009, Oracle. All rights reserved.
Disclaimer
This document contains proprietary information and is protected by copyright and other intellectual
property laws. You may copy and print this document solely for your own use in an Oracle training
course. The document may not be modified or altered in any way. Except where your use constitutes
"fair use" under copyright law, you may not use, share, download, upload, copy, print, display,
perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part
without the express authorization of Oracle.
The information contained in this document is subject to change without notice. If you find any
problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway,
Redwood Shores, California 94065 USA. This document is not warranted to be error-free.
Restricted Rights Notice
If this documentation is delivered to the United States Government or anyone using the
documentation on behalf of the United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS
The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these
training materials are restricted by the terms of the applicable Oracle license agreement and/or the
applicable U.S. Government contract.
Trademark Notice
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be
trademarks of their respective owners.
Technical Contributors
and Reviewers
Claire Bennett
Tom Best
Purjanti Chang
Ken Cooper
László Czinkóczki
Burt Demchick
Mark Fleming
Gerlinde Frenzen
Nancy Greenberg
Chaitanya Koratamaddi
Wendy Lo
Timothy Mcglue
Alan Paulson
Bryan Roberts
Abhishek Singh
Lori Tritz
Michael Versaci
Lex van der Werff
Editors
Amitha Narayan
Vijayalakshmi Narasimhan
Raj Kumar
Graphic Designer
Satish Bettegowda
Publishers
Sujatha Nagendra
Syed Ali
Introduction
Copyright © 2009, Oracle. All rights reserved.
Lesson Objectives
After completing this lesson, you should be able to do the
following:
Understand the goals of the course
List the features of Oracle Database 11g
Discuss the theoretical and physical aspects of a relational
database
Describe Oracle server’s implementation of RDBMS and
object relational database management system
(ORDBMS)
Identify the development environments that can be used
for this course
Describe the database and schema used in this course
I-2
Copyright © 2009, Oracle. All rights reserved.
Lesson Agenda
Course objectives, agenda, and appendixes used in the
course
Overview of Oracle Database 11g and related products
Overview of relational database management concepts
and terminologies
Introduction to SQL and its development environments
The HR schema and the tables used in this course
Oracle Database 11g documentation and additional
resources
I-3
Copyright © 2009, Oracle. All rights reserved.
Zgłoś jeśli naruszono regulamin