RelationalDBDesignRelationalDBDesign





Managing Users  «Prev  Next»
Lesson 1

Introduction to Managing Database Users

Welcome to Managing Users and Connectivity. This course is the second of five in the Oracle Database Administration Certification Series. Taken together, these five courses teach you how to create and manage an Oracle database.

Course goals

Part 1 of this series focused on architecture[1], database creation, and the basics of interacting with an Oracle database. Part 2, the part that you are about to take, deals with managing users and their access to the database. Part 2 also teaches you about SQL*Plus and Enterprise Manager, two important tools that you will use in your day-to-day management of an Oracle database. When you have completed this course, you will be able to do the following:
  1. Process architecture refers to the various processes that run to make an Oracle database work, and file architecture, which refers to the way in which Oracle uses files.
  2. Configure Oracle Net Services on client PCs so they can access Oracle on the server
  3. Effectively use SQL*Plus to run scripts, execute SQL statements, and generate reports
  4. Start the various Enterprise Manager applications, and navigate through them to display information about your database
  5. Create and manage database users
  6. Manage security, both for DBAs and for normal users


Oracle Certification

This course, together with Oracle Database Administration parts 1, 3, 4 and 5, helps prepare you for the following Oracle certification exam:
Pass one SQL Exam:
  1. Oracle Database 12c SQL 1Z0-071 or
  2. Oracle Database 12c: SQL Fundamentals 1Z0-061 or
  3. Oracle Database 11g: SQL Fundamentals I 1Z0-051 or
  4. Oracle Database SQL Expert 1Z0-047


In the next lesson, the database will be discussed.

Exams 1Z0-071, 1Z0-061, 1Z0-051, 1Z0-047


[1]architecture: In the context of Oracle’s database, the term architecture refers to the overall design of the product, especially with reference to how the various individual components interact with each other. With Oracle, there is memory architecture, which refers to how Oracle uses memory.