Course Topics |
- Course Overview;
- Core Concepts and Architecture of Oracle Database;
- Common DBA Tasks & Tools;
- Installing Database Software and creating database, Configuring Network Environment;
- Oracle SQL – Basics of SQL statements, Restricting and sorting data, Single row functions, Aggregating Group functions, Displaying data from multiple table, Sub-queries, Manipulating data, Creating and managing tables, etc.; Oracle PL/SQL – PL/SQL blocks, logic statements, If-Else, Loop, Exception Handing, Input/Output Statements, Procedures, Functions, and Triggers; Administering User Account and Security – Create and Manage User Accounts, Grant and Revoke Privileges, Create and Manage Roles, Create and Manage Profiles;
- Data Dictionary Views – Using Data Dictionary, Types of Views and Querying the Data Dictionary View Information, Using the Dynamic Performance Views;
- Managing Schema Objects – Tables, Index, Views etc.;
- Performing Backups & Recovery – Managing Backups and the Flash Recovery Area, Concepts of Hot and Cold Backups, Consistent and Inconsistent Backups, Backing up Control files, Datafiles, Using Archived Log Techniques, Using the RMAN Command Line, Recovering from a Lost Control File, Recovering Non-Critical and Critical Data Files;
- Monitoring and tuning Database.
|