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

Ontario College of Technology Logo

Data Analyst and Database Administrator

Data analytics and database management design, develop, and administer data management solutions, as well as develop and implement data administration policies, standards, and models.

by Ontario College of Technology [Claim Listing ]
OptionTrain College Of Management & Technology Logo

Microsoft SQL Server 2012 Querying for Analyst

This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012.

by OptionTrain College Of Management & Technology [Claim Listing ]
Thinkcloudly Learning Institute Logo

Oracle Certification (Oracle Database Administration (1Z0-082))

Thinkcloudly provides the most comprehensive and one of the best Oracle database administration trainings. Learn the intricacies of Oracle certification in our comprehensive course.

by Thinkcloudly Learning Institute [Claim Listing ]
OptionTrain College of Management and Technology Logo

Oracle Database 11G (Introduction To SQL)

This course helps you write subqueries, combine multiple queries into a single query using SET operators, and report aggregated data using group functions. Learn this and more through hands-on exercises.

by OptionTrain College of Management and Technology [Claim Listing ]
Seneca College Logo

Database Fundamentals

Organizations today require a stable and secure database for their business solutions. This program is targeted to individuals with basic operating system knowledge seeking to build their skill set in the areas of database design and development, support and testing, and troubleshooting.

by Seneca College [Claim Listing ]

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