The Complete Oracle SQL Bootcamp (2021)

The Complete Oracle SQL Bootcamp (2021)

Oracle

Admin Piano Book

September 04, 2021

 

• The Complete Oracle SQL Bootcamp (2021) -  Become an In-demand SQL Professional & Pass Oracle SQL 1Z0-071 (OCA) Certification Exam Confidently!

Created by	Code Star Academy
Name	The Complete Oracle SQL Bootcamp
Hours	10 hours on-demand video
Access	Full lifetime access

• The Complete Oracle SQL Bootcamp (2021)

If {you want to|you wish to|you intend to} {end up|wind up|find yourself} an Oracle Database Administrator(Oracle DBA), this course is right {for you|for you personally}!!!!

'Oracle 11g/12c DBA' direction follows a {little by little|over time} technique in introducing principles and Demo's to the scholars so {we can|we are able to|we could} learn comfortably.

Almost in each enterprise, you'll find Database Administrator's (DBA's) to preserve the organisation's database. Becoming {an excellent|a great|a fantastic} DBA relies upon at {the information|the info|the data} {you have|you've} within {the usual|the typical|the most common} structure of Oracle Database.

In this direction, {I have|I've} covered both Oracle Database 11g and Oracle Database 12c {so that|to ensure that|in order that} {you get to|you can|you're able to} realize the differences and may work in companies, who're nevertheless in 11g.

• Learn the fundamentals of database {to set|to create|setting} the stage for Oracle Architecture
• Understand the Process and Memory Architecture (This {is important|is essential|is very important} as understanding this {will help you|can help you|will allow you to} solve {lot of|large amount of} critical performance issues).
•  Install Oracle Database 11g & 12c (Manual method and using DBCA)
• Tablespace management {to manage|to handle|to control} space to store the data.
• UNDO Tablespace management {to manage|to handle|to control} undo space.
• REDO Log file management {to manage|to handle|to control} 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

• GO TO COURSES

Admin Piano Book September 04, 2021