Oracle PL/SQL Fundamentals vol. I & II

Oracle PL/SQL Fundamentals vol. I & II

 

Oracle PL/SQL Fundamentals vol. I & II



  • Oracle PL/SQL Fundamentals vol. I & II - Database Administration for Junior DBA -  A complete introduction to PL/SQL database programming language.


 Created byIntellezy Trainers
 Name Oracle 
 Hours  11 hours on-demand video
 Access Full lifetime access


  • About Oracle PL/SQL Fundamentals vol. I & II


If you want to end up an Oracle Database Administrator(Oracle DBA), this course is right for you!!!!

'Oracle 11g/12c DBA' direction follows a little by little technique in introducing principles and Demo's to the scholars so we can learn comfortably.

Almost in each enterprise, you'll find Database Administrator's (DBA's) to preserve the organisation's database. Becoming an excellent DBA relies upon at the information you have within the usual structure of Oracle Database.

In this direction, I have covered both Oracle Database 11g and Oracle Database 12c so that you get to realize the differences and may work in companies, who're nevertheless in 11g.
  • Learn the fundamentals of database to set the stage for Oracle Architecture
  • Understand the Process and Memory Architecture (This is important as understanding this will help you solve lot of critical performance issues).
  •  Install Oracle Database 11g & 12c (Manual method and using DBCA)
  • Tablespace management to manage space to store the data.
  • UNDO Tablespace management to manage undo space.
  • REDO Log file management to manage redo space.
  • Manage users and security
  • Networking (Configuring Listeners and TNS entries)
  • Understand various Data dictionary tables/views
  • Diagnose issues using Diagnose data and generate packages for Oracle Support.
  • Backup and Recovery (User Managed)
  • Backup and Recovery (RMAN)
  • Materialized Views
  • Table Partitioning
  • Project Work

  • What will you learn 


✔  Final Goal: Get a job as an Oracle Database Administrator (Oracle DBA)
✔  As a Oracle Database Administrator (Oracle DBA), you would be able understand the Database ✔  Architecture, which will help you to perform your DBA duties with better understanding.
✔  As a Oracle Database Administrator (Oracle DBA), you would be able to Install the necessary Oracle Software/Database
✔  As a Oracle Database Administrator (Oracle DBA), you would be able to Administer User accounts in the Database
✔  As a Oracle Database Administrator (Oracle DBA), you would be able to Manage Tablespace's to provide required space for the data
✔  As a Oracle Database Administrator (Oracle DBA), you would be able perform Backup and Recovery as needed.
✔  As a Oracle Database Administrator (Oracle DBA), you would be able to diagnose the problems and if required will be able to work with Oracle Support
✔  As a Oracle Database Administrator (Oracle DBA), you would be able to configure the Listeners for users to communicate

  • Requirements 

  • Students should have basic SQL Knowledge
  • Students should know the basic UNIX/LINUX commands
  • An open mind to understand Architecture, before jumping into demo's

  • Course content 
17 sections • 129 lectures • 10h 59m total length
Oracle DBA 11g/12c - Database Administration for Junior DBA