Oracle Database (Suite 1)

by OCMT (Ontario College of Management & Technology) Claim Listing

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.

$1999

Contact the Institutes

Fill this form

Advertisement

OCMT (Ontario College of Management & Technology) Logo

img Duration

Please Enquire

Course Details

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
  • Toronto Branch

    2901 Lawrence Avenue East, Toronto

Check out more Oracle courses in Canada

Le Wagon Logo

SQL

Learn how to manage large datasets and analyze real data using the standard data management language.

by Le Wagon [Claim Listing ]
(BTT) Business And Technical Training College Logo

Database Analysis

The course introduces students to Excel features and commands that are needed to analyze large datasets in order to make informed business decisions. It teaches how to gather and organize data for operational analysis. And, learn various analysis terminologies for effective communications.

by (BTT) Business And Technical Training College
Concordia University Logo

Intro to SQL

his course serves as the foundation for further studies in programming. And if you're reading this on the web, someone, maybe someone like you, took a course just like this and now has a pretty cool job.

by Concordia University [Claim Listing ]
Formation SETC Logo

PLSQL Training

Our training covers basic and advanced PLSQL, PLSQL programming, triggers, cursors, sequences, packages, stored procedures and functions, date and time management, string manipulation and more Again. 

by Formation SETC [Claim Listing ]
Doussou Formation Logo

Oracle SQLTuning Training

Oracle is a relational database management system that optimizes the management and security of data sets by creating structured database schemas that are accessible only to administrators with permissions.

by Doussou Formation [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy