DBA ORACLE - Fundamentals, SQL and Essential Practices
Learning basic Oracle from A to Z, here we will learn, in addition to queries, various administrative tasks of the DBA
Updated on Jun, 2025
Language - Portuguese
Office Productivity,Oracle,PL/SQL
Lectures -11
Resources -4
Duration -2.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
In this course, you will obtain all the knowledge necessary to start managing the database, developing queries, views, and tables, managing users, keeping services up and running, detecting problems, and much more, as all content is prepared in detail to provide you with what is essential to start working with Oracle and understanding the product.
Goals
· 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
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 if you are a systems analyst and intend to better understand the Oracle DATABASE product, to deal better with your team.
Curriculum
Check out the detailed breakdown of what’s inside the course
Conceitas básicos e iniciação no SGBD Oracle
2 Lectures
-
Intro e O que é um SGBD Oracle
11:38
11:38
-
Arquivos Principais
04:05
04:05
Tipos de banco de dados e tablespaces.
2 Lectures
Arquitetura, tabelas e visões
2 Lectures
Criando e manipulando objetos
2 Lectures
Consultas SQL, exercícios e arquivos úteis
1 Lectures
Segurança - Administrando usuários, grants e roles
1 Lectures
Administrando Instância Oracle
1 Lectures
Instructor Details
Daniel Mello Vidal
DBA de missão crítica desde 2006, especialista em tecnologias como ORACLE RAC, EXADATA, responsável por implantar e gerenciar base de dados Oracle em diversas grandes empresas nacionais e internacionais, e apaixonado por novas tecnologias e passagem de conhecimento, pois acredito que esse é nosso principal legado para sociedade.
Com experiência anteriores em treinamentos e consultoria online disponibilizar na udemy o inicio de um legado positivo para profissionais de tecnologia da informação, espero que este seja o primeiro de muitos cursos a presentear os alunos.
Participei dos maiores projetos de migração de base de dados da America Latina e estarei disposto e ajuda-lo a enfrentar seus pequenos e grandes desafios.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now