Oracle Database 12c: Installation and Administration

Oracle Database 12c: Installation and Administration

This course is a must have course for everyone who is or intending to go into a field that uses data. It is the foundation, whether you want to go into business intelligence or learn learn Oracle SQL, go into data warehousing or becoming an ETL developer or architecture. It gives you the installation of a database on your platform. You do not need any prior experience. I have structured the course in steps that everyone from beginner to expert level, should be able to follow. The modules are in the following order.

What you’ll learn

create an Oracle account.
use different ways to download software from an Oracle website.
create folders.
uncompress files and to extract files.
edit environment variables.
install an Oracle Database.
verify installation of an Oracle database.
start and stop Oracle services.
identify Oracle database home path and TNSNAMES path.
log into database using SQL PLUS.
create database users.
unlock a database user.
give privileges to users.
install SQL Developer.
create connections in SQL Developer.

Course Outline:

Oracle Database 12c – Administration: Database Architecture and Management Tools
Oracle Database 12c – Administration: Manage the Database Instance
Oracle Database 12c – Administration: The Network Environment and User Security
Oracle Database 12c – Administration: Storage structures and Undo Data
Oracle Database 12c – Administration: Data Concurrency and Auditing
Oracle Database 12c – Administration: Backup, Recover, and Move Data
Oracle Database 12c – Administration: Maintenance and Performance Tuning
Oracle Database 12c – Administration: Resource Manager, Scheduler, and Support

Requirements

We will go through how to get everything that you need to use in this course. No prior skills are needed, you will receive all the necessary training in this course.