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

CompuEase Logo

SQL Training

Compuease offers SQL Training at its Ottawa training centre. Our SQL classes are led by trainers with practical experience using language in all sorts of business and government environments. Their friendly and approachable style will help you get comfortable speaking this new language.

by CompuEase [Claim Listing ]
Chinook Learning Services Logo

Oracle SQL Training

Mastering Oracle SQL is one of today's most marketable programming skills for end-to-end developers.

by Chinook Learning Services [Claim Listing ]
Roicians Logo

Oracle Admin I Training

This course is designed for OCA(Oracle Certified Associate) , Oracle Certification Preparation. We will cover complete industry practical scenarios in this course. Also this course is meant to prepare one for Oracle Jobs. We prepare students for Interviews and DBA Jobs.

by Roicians [Claim Listing ]
ExitCertified Logo

MySQL Fundamentals Ed 1

The MySQL Fundamentals training is the first step in mastering MySQL, the world's most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.

by ExitCertified [Claim Listing ]
Knowledge Hut Logo

MySQL

This course is designed to help beginners as well as experienced professionals with a range of topics such as uploading files to servers, handling exceptions, working with functions and form data, manipulating system files, and more.

by Knowledge Hut [Claim Listing ]
  • Price
  • Start Date
  • Duration

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