Oracle Database (Suite 1)

To effectively and efficiently manage today’s business-critical information, organizations depend on database systems that are flexible, reliable, and scalable and on experienced professionals to handle them.

In this course, attendees will gain a solid foundation of database concepts, SQL and PL/SQL to take advantage of Oracle Database 12c features for developing robust databases.

Course Content:

Oracle Database 12c Technology

• Concepts of Relational database
• Data modelling techniques
• Defining entities, attributes and relationships
• Understanding Oracle database tools: SQL Developer and SQL*Plus

Configuring the Database Environment

• Assessing memory structures, processes and files
• Analyzing the Oracle database architecture
• Establishing a storage hierarchy

Maintaining Oracle database components

• Reviewing the Oracle Database 12c installation
• Generating DBA scripts with the data dictionary
• Working with Oracle SQL Developer

Retrieving and Controlling Data

• Selecting, filtering and ordering results
• Implementing queries with SQL Developer
• Avoiding pitfalls in null values
• Deploying built-in SQL functions
• Comparing CASE and DECODE functions