DBA ORACLE - Fundamentals, SQL and Essential Practices

Goals

What will you learn in this course:

· What is the Oracle Database Management System.
· Core database files
· Types of environments.
· Main tools for local database administration.
· SQLplus, Rman and Database Control
· What are DCL/DML and DDL.
· Data Manipulation Language (DML)
· Data Definition Language (DDL)
. Data Control Language (DCL)
- Tablespaces
- UNDO
- TEMP
- Initialization file
- REDO
- Archives
· Information catalog for the DBA
· Create tables
· Views
· Procedures
. Triggers
. Constraints and their types.
. Indexes
. What are queries?
· UNION and UNION ALL clause
. Main functions.
· JOIN clause
· Data entry
· UPDATE statement
· Delete statement
· Instruction for creating, cleaning and maintaining tables.
· User creation
. Profile creation
· Grants
. Roles
. Schemas
. Launch instance
. Download instance
. Viewing the error file.
. Changing parameters

Prerequisites

What are the prerequisites for this course?

If you are attending college and intend to pursue a career as a DBA, or Solution Developer, if you are already a DBA of another technology and intend to become increasingly heterogeneous, or you are a systems analyst and intend to better understand the Oracle DATABASE product, to deal better with your team.