Oracle 10g SQL Fundamentals

This course offers students an introduction to Oracle Database 10g database technology. In this class, students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.
Nội dung trích xuất từ tài liệu:
Oracle 10g SQL Fundamentals Oracle Database 10g: SQL Fundamentals I Electronic PresentationD17108GC11Production 1.1August 2004D39769 ®Author Copyright © 2004, Oracle. All rights reserved.Nancy Greenberg This documentation contains proprietary information of Oracle Corporation. It is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited. If this documentation is delivered to a U.S.Technical Contributors Government Agency of the Department of Defense, then it is delivered with Restricted Rights and theand Reviewers following legend is applicable:Wayne Abbott Restricted Rights LegendChristian BauwensPerry Benson Use, duplication or disclosure by the Government is subject to restrictions for commercial computer software and shall be deemed to be Restricted Rights software under Federal law, as set forth inBrian Boxx subparagraph (c)(1)(ii) of DFARS 252.227-7013, Rights in Technical Data and Computer SoftwareZarko Cesljas (October 1988).Dairy ChanLaszlo Czinkoczki This material or any portion of it may not be copied in any form or by any means without the expressMarjolein Dekkers prior written permission of Oracle Corporation. Any other copying is a violation of copyright law andMatthew Gregory may result in civil and/or criminal penalties.Stefan Grenstad If this documentation is delivered to a U.S. Government Agency not within the Department ofJoel Goodman Defense, then it is delivered with “Restricted Rights,” as defined in FAR 52.227-14, Rights in Data-Rosita Hanoman General, including Alternate III (June 1987).Sushma JagannathAngelika Krupp The information in this document is subject to change without notice. If you find any problems in theChristopher Lawless documentation, please report them in writing to Education Products, Oracle Corporation, 500 OracleMarcelo Manzano Parkway, Box SB-6, Redwood Shores, CA 94065. Oracle Corporation does not warrant that thisIsabelle Marchand document is error-free.Malika Marghadi Oracle and all references to Oracle products are trademarks or registered trademarks of OracleValli Pataballa Corporation.Elspeth PayneLigia Jasmin Robayo All other products or company names are used for identification purposes only, and may beBryan Roberts trademarks of their respective owners.Helen RobertsonLata ShivaprasadJohn SoltaniPriya VennapusaKen WoolfePublisherJobi Varghese IntroductionCopyright © 2004, Oracle. All rights reserved. Lesson ObjectivesAfter completing this lesson, you should be able to dothe following: • List the features of Oracle10g • Discuss the theoretical and physical aspects of a relational database • Describe the Oracle implementation of the RDBMS and ORDBMS • Understand the goals of the course Copyright © 2004, Oracle. All rights reserved. Goals of the CourseAfter completing this course, you should be able to dothe following: • Identify the major structural components of Oracle Database 10g • Retrieve row and column data from tables with the SELECT statement• Create reports of sorted and restricted data• Employ SQL functions to generate and retrieve customized data• Run data manipulation language (DML) statements to update data in Oracle Database 10g• Obtain metadata by querying the dictionary views Copyright © 2004, Oracle. All rights reserved. Oracle10g OneScalability vendor Unified Reliability management Single Common development skill sets model Copyright © 2004, Oracle. All rights reserved. Oracle10gCopyright © 2004, Oracle. All rights reserved.Oracle Database 10g Object relational data Documents Multimedia Messages Copyright © 2004, Oracle. All rights reserved.Oracle Application Server 10g PortalsTransactional applications Business intelligence Integration Application Application development server framework Copyright © 2004, Oracle. All rights reserved. Oracle Enterprise Manager 10g Grid Control• Software provisioning• Application service level monitoring Copyright © 2004, Oracle. All rights reserved. Relational and Object Relational Database Management Systems• Relational model and object relational model• User-defined data types and objects• Fully compatible with relational database• Support of multimedia and large objects• High-quality database server features Copyright © 2004, Oracle. All rights reserved. Oracle Internet Platform Clients Any Any Any browser mail client FTP client ...