Title: Orientation Video
Course: Oracle Database Administration I (27684) > Section: Course Orientation

Click and download video transcript.

Welcome to ITSE2356, the interesting thing about this course is that it requires a significant paradigm shift. I say this because the shift is away from the concept of programming and a move towards management functionality and  the understanding of environmental factors such as organizational and business rules.  In support of the shift to management, five main premises will be followed though the semester.

I. You must stop thinking as a "Programmer" and now think as a "Manager" with your employees to be managed being the native Oracle programs that will assist you in managing the idea of a database along with the subcontractor(s) any third party programs you or your employeer have bought or downloaded for managerial use.

II. Now this is where it gets interesting, this is the crux of the concept. Oracle considers everything a consumer of resources to be managed. Oracle considers the programming language of "SQL" a consumer of resources to be managed, now stop and consider this premise, every time a query is executed --   permission and access to programs and data must be granted, remembering that the CPU will be needed or accessed (a resource), memory will be required (a resource) ... and on it goes.

III. As a manager, there are various issues you must come to terms with, such as: first, the separation of "Production" and "Development" environments. Second, you must think in terms of budgeting resources, understanding you have fixed resources, as such you must balance and prioritize your resources. Third, you must rely on your assistant managers, the native Oracle management programs, such as control logs.

IV. The four major items, categories and resources that will be managed are: 1) Hardware, 2) Software, 3) Personnel and 4) Organizational Policies/Procedures

V. A correlation process, practice quizzes are used which simulate or align with parts of the Oracle DBA certification process.

Now also consider this, as a manager, your responsibility is to assure the success and survival  of the organization - and not any specific member or element in the organization which in many cases may result in some uncomfortable situations.  Such is the role of a manager.