Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 21 Minute(s)
Language
English
Taught by
Bluelime Learning Solutions
Rating
Course Overview
Learn the essential tools you will need to function effectively as an Oracle DBA
Oracle Database Administrator's are in constant demand in the IT industry.
The rapid growth of data has fuelled the demand for database administrator's in general. We are more than before reliant on data in our everyday life either through the use of social media with applications like Facebook,Instagram Whatsapp ,Twitter and may more data rich applications.
This course is designed for beginners who are considering a career as a database administrator. It will guide you
through some of the tasks that an Oracle database administrator has to perform.
Oracle DBA Responsibilities includes:
Installing new versions of the Oracle database and its tools
Installing tools required to access the Oracle database.
Shutting down and Starting the database
Backing up and Recovering Data
Exporting and Importing Data
Managing Users
Managing security of the database
Monitoring the database
Creating database objects like databases, tables and views
Create new database users as required.
Upgrading the database
Plans and implements backup and recovery of the Oracle database.
Assists with impact analysis of any changes made to the database objects.
Provides technical support to application development teams
Enforces and maintains database constraints to ensure integrity of the database.
Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
Troubleshooting problems regarding the databases, applications and development tools.
This course is a practical hands-on workshop that will guide you through performing some of the task an oracle database
administrator performs. By the end of this course you will gain some useful skills that will give you enough confidence
to progress your journey towards becoming a database administrator.
Looking forward to welcoming you to the course.
Course Content
- 9 section(s)
- 73 lecture(s)
- Section 1 Installing your Oracle Software and Tools Used to Administer an Oracle Database
- Section 2 Monitoring a Database
- Section 3 Exporting and Importing Metadata and Data
- Section 4 Managing Oracle Database Accounts
- Section 5 Analytic Functions
- Section 6 Backing Up and Recovering Data
- Section 7 Managing the Oracle Database Instance
- Section 8 Managing Users and Securing the Database
- Section 9 Managing UNDO Data
What You’ll Learn
- Start and Shut down a database, Backup and Recover Data, Create database objects like database,schema and tables, Monitor the database, Export and Import Metadata and Data, View database version and globalization , Identify database software release number, Manage database users, Manage security of the database
Skills covered in this course
Reviews
-
MMd. Danish khan
THERE ARE NO UPDATES TO THE COURSE BASED ON THE LATEST VERSIONS OF ORACLE AND SQL DEVELOPER. THE DATABASE IS NOW ROOT AND PDB WHICH I CAME TO KNOW THROUGH ONLINE SERACH BEACUSE I COULD NOT UNLOCK MY HR SCHEMA. THE CONCEPTS ARE GOOD THOUGH.
-
MMizuho Okimoto
The version of the Oracle Database is now 21c, windows version is 11 instead of 7. I wish the lectures were updated or insert additional videos. The way to add the HR Schema is different(I believe from v19), and I took so much time to figure it out. As a result, watching the YouTube video helped me. Now I wonder why I am paying for this course.
-
TTerence Kihato Mwangi
It is a good beginner's course. However, as a beginner to the DBA field, I do not believe that Section 5 belongs in a DBA course. It consists purely of development issues
-
WWalid Chakchouk
Its showing a lot of details sometimes not needed
