Oracle: Administration Workshop II

We bring you this wonderful course on DBA II - Oracle Database Administration II. This detailed course will help you understand all the important concepts and topics of DBA II - Oracle Database Administration II.

305

 11h 37m | 76 Videos | 75571 Views |   Intermediate

What is Data Administration?

Data administration is a process whereby data resources are arranged and monitored in the field of information systems and computer science. This is done through a database management system (DBMS).

What are the advantages of Data Administration?

Data Administration through using DBMS has a wide range of features. These are as follows,

1. Controlling Data Redundancy
2. Data Consistency
3. Data Sharing
4. Data Integration
5. Data Security
6. Development of an Application
7. Creating Forms
8. Control over Concurrency
9. Backup and Recover Options
10. Data Independency
11. Advanced Capabilities
12. Report Writers

1. Controlling Data Redundancy

When working in a traditional system (non-database), multiple files of the same data can get created at many places. However Database Administration ensures that all the files are integrated into only one database. This makes sure that the same files are not copied more than once.

2. Data Consistency

Checking Data Redundancy also ensures Data Consistency. If an item only appears one, any update required on its value is performed only once and the update is made available to all users.

3. Data Sharing

Data Administration allows sharing of data easier among authorised users of the said data management system.

4. Data Integration

In a database management system, data on a database is saved in the form of tables. A system has multiple tables which can allow relationships to be drawn and retrieve data.

5. Data Security

Data security involves protecting the data of a system from non-authorised users. Data administration ensures that this security is maintained.

6. Development of an Application

The database management system provides tools that can be used to develop an application programs. Hence, this reduces cost and time required to develop an application.

7. Creating Forms

Forms are a user-friendly, simple way of entering data that can be retrieved and used later. One of the important functions of a database management system is forms. The system allows for creation of forms and administering it can ensure that the information entered is monitored regularly.

8. Control over Concurrency

In a traditional system, there is a high probability of data being overwritten if two users are accessing the same data simultaneously. However, a database management system ensures that such concurrency is kept in check and prevents such glitches from affecting data.

9. Backup and Recovery Options

In a database management system, sub-systems like backup and recovery are automatically provided to protect data from being lost. In a traditional computer-file system this is a highly time consuming process (especially if the data is large) where the user has to constantly create backup systems to protect data.

10. Data Independence

In a database management system, the database and application are separated-a process that is referred to as data independence. The advantage of this is that database can be modified without modifying the application itself.

11. Advanced Capabilities

A database management system provides features like reporting data through the internet and accessing files online.

12. Report Writers

A database management system allows for reports to be created easily through providing report writing tools. These can be edited and modified easily. It is saved along with the database and behaves like a constituent of the software.

What is the role and responsibility of a Data Administrator?

Database, irrespective of its size, requires at least of Database Administrator, also known as DBA. An Oracle Database may have many users and hence, can be very large in size. It is therefore clear that database administration is often not job for only one person to handle but involves work that need to be shared among a group of responsible DBAs.

According to a manual on Oracle Database Administration, a database administrator’s responsibilities can cover the following responsibilities,

• Installing and upgrading the Oracle Database server and application tools
• Allocating system storage and planning future storage requirements for the database system
• Creating primary database storage structures (tablespaces) after application developers have designed an application
• Creating primary objects (tables, views, indexes) once application developers have designed an application
• Modifying the database structure, as necessary, from information given by application developers
• Enrolling users and maintaining system security
• Ensuring compliance with Oracle license agreements
• Controlling and monitoring user access to the database
• Monitoring and optimizing the performance of the database
• Planning for backup and recovery of database information
• Maintaining archived data on tape
• Backing up and restoring the database
• Contacting Oracle for technical support

What is the Database Administration Training?

The course on Data Administration discusses core concepts, with an in-depth engagement with the basic components of Data Administration and the way to use it in a real world situation.

Some of the concepts that are going to be in the course include

• RMAN Configuration
• Creating Backup with RMAN
• Flashback Technologies
• Managing Memory of Database
• Managing Database Performance

What are the prerequisites for this Database Administration Training?

The basic requirement for this course is a computer with a working internet.

A previous experience in programming is also highly desirous.

Who is this Database Administration Training designed for?

The course is especially suited for the following categories of people

• Database Administrators
• Technical Consultants
• System Analysts
• Portal Developers
• Application developers
• People who wish to know about Data Administration.

Testimonials

• “First of all, this course was very insightful! As more and more businesses upscale and start employing new age technology in the various processes of their work and work management, knowing more about data administration and engaging more with data management becomes absolutely crucial. Thankfully, various techniques and processes of data administration make it fairly easy for people to secure and manage valuable data of the company. However, due to lack of enough knowledge and expertise on this subject, a lot of people are not able to develop the skill set required to become a Database Administrator (DBA) or even know a bit about Data Administration as such. This course was thus highly useful as it deals with many niche but extremely practical and useful concepts. The modules were crisp and to the point and I strongly feel that the training I received from this course will help me a lot to manage my data effectively.”

• “Data Administration is a wonderful and effective way to keep a track of your valuable information. Where this course proves to be helpful is that it brings a lot of elements, basic and intermediary, of database administration together than helps to solidify the base of our knowledge system with respect to a fairly new concept like Data Administration. Earlier of course, I too like most was sceptical about the effectiveness of the taught material. However, I soon realised that this course is a course designed for the future. Data is the all-powerful tool when it comes to business and hence keeping a track of data of various kinds in the organisation is something one cannot avoid. We must thus adapt and embrace newer ways of running a business, like Database Administration. However, there is a dearth of people who are trained in the intricacies of database management and this course exactly fills that gap. I am extremely happy and satisfied. ”

Back to top ^