Unix/Linux Essentials

Objectives

  • Manage files and directories from the command line

  • Learn to use the vim editing tool.

  • Perform remote connections and file transfer.

  • Customize the user environment

  • Use advanced shell features in shell scripts.

  • Archive and compress files and directories.

  • Understand and manage process control.

  • View and modify file and directory permissions

Benefits

  • Work effectively with UNIX environments and master the fundamental administrative tasks using this operating system.

  • Gain mastery of Unix basic commands to effectively manage files and folders.

  • Use the Lab environment to demonstrate competence in creating and modifying script files.

Oracle Database: Introduction to SQL

Objectives

  • Understand the basic concepts of relational databases ensure refined code by developers.

  • Create reports of sorted and restricted data.

  • Run data manipulation statements (DML).

  • Control database access to specific objects.

  • Manage schema objects.

  • Manage objects with data dictionary views.

  • Retrieve row and column data from tables.

  • Control privileges at the object and system level.

Benefits

  • Demonstrate excellent Knowledge of Structured Query Language (SQL)

  • Use SQL statements to create tables, retrieve, update and delete records from an existing table.

  • Demonstrate excellent knowledge of how to customize reports.

  • Use Grant and Revoke commands ito restrict access to data.

Oracle Database 19c: Administration

Objectives

  • Describe Oracle Database architecture.

  • Describe Oracle Database Cloud Service (DBCS) architecture and features.

  • Create and manage DBCS database deployments.

  • Configure the database to support your applications.

  • Manage database security and implement auditing.

  • Implement basic backup and recovery procedures.

  • Move data between databases and files.

  • Employ basic monitoring procedures and manage performance.

Benefits

  • Demonstrate excellent understanding of database administration tasks proficiently.

  • Gain good understanding of the Oracle Database and be able to utilize different tools to configure and secure an enterprise database.