This course is a comprehensive, hands-on guide to using Oracle Database, a popular relational database management system. You will learn how to install, configure, use and optimize Oracle Database, using different tools and languages. You will receive a certificate of completion and access to a network of Oracle Database experts. You will learn to:
- Install and configure Oracle Database on your system, using tools such as Oracle Universal Installer, Oracle Net Configuration Assistant, and Oracle Database Configuration Assistant
- Use basic Oracle Database concepts and components, such as schemas, tables, indexes, views, sequences, synonyms, and triggers
- Use Structured Query Language (SQL) to perform various operations on data, such as query, insert, update, delete, and join
- Use procedural language/structured query language (PL/SQL) to create and execute stored procedures, functions, packages, and triggers
- Use Oracle database tools and utilities, such as SQL Developer, SQL*Plus, Data Pump, Export/Import, and Recovery Manager
- Optimize the performance and security of your Oracle database, using tools such as Automatic Workload Repository, Automatic Database Diagnostic Monitor, Oracle Enterprise Manager and Oracle Data Guard.
At the end of the training you will be able to manage a modern and highly efficient data center, identity management, systems management, virtualization, storage and networking. You will also receive a certificate of completion and access to a network of Oracle Database experts for guidance and support.
Course Features
- Lectures 0
- Quizzes 0
- Duration Lifetime access
- Skill level All levels
- Language English
- Students 32
- Assessments Yes
