30-days Money-Back Guarantee
Learning basic Oracle from A to Z, here we will learn, in addition to queries, various administrative tasks of the DBA
Updated on Sep, 2026
Language - Portuguese
Office Productivity, Oracle, PL/SQL
Duration - 2.5 hours
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
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.
· 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
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.
Check out the detailed breakdown of what’s inside the course
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.
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.