1 / 10

Oracle Database Basics Course: Learn Administration and SQL

Learn Oracle Database 10g Enterprise Edition essentials, SQL basics, and Administrator tasks. Gain hands-on experience with installing, configuring, and maintaining an Oracle database. Understand relational database concepts and core tasks of a Database Administrator.

davisjoseph
Download Presentation

Oracle Database Basics Course: Learn Administration and SQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction

  2. Objectives • After completing this lesson, you should be able to do the following: • Explain the course objectives • Identify the Oracle product line • Describe the basic concepts of a relational database • List the core database administrator tasks

  3. Course Objectives • In this course, you will gain hands-on experience with: • Installing, creating, and administering an Oracle Database 10g Enterprise Edition database • Configuring the database for an application • Implementing a backup and recovery strategy • Employing basic monitoring procedures

  4. Oracle Products • Oracle Database • Oracle Application Server • Oracle Applications • Oracle Collaboration Suite • Oracle Development Suite • Oracle Services

  5. Relational Database Systems • Table • Row • Field or cell • Column

  6. How the Data Is Organized • EMPLOYEES • DEPARTMENTS

  7. Integrity Constraints

  8. Structured Query Language • Structured query language (SQL): A standard interactive and programming language for getting information from and updating information in a database • SQL provides statements for a variety of tasks, including: • Querying data • Inserting, updating, and deleting rows in a table • Creating, replacing, altering, and dropping objects • Controlling access to the database and its objects • Guaranteeing database consistency and integrity

  9. Tasks of an Oracle Database Administrator • Prioritized approach for designing, implementing, and maintaining an Oracle database: 1. Evaluate the database server hardware. 2. Install the Oracle software. 3. Plan the database. 4. Create and open the database. 5. Back up the database. 6. Enroll system users. 7. Implement the database design. 8. Recover from database failure. 9. Monitor database performance.

  10. Summary • In this lesson, you should have learned how to: • Explain the course objectives • Describe the Oracle product line • Identify the basic concepts of a relational database • List the core Database Administrator tasks

More Related