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

RRC Polytech Logo

SQL (Structured Query Language)

You will learn the fundamentals of SQL syntax to query, add data to, build, and protect databases. You will also learn about the development and use of SQL, about relational databases and relational database design in general, and about current topics in relational database management.

by RRC Polytech [Claim Listing ]
  • Price
  • Start Date
  • Duration
Training Hub Logo

Microsoft SQL Developer Course

During this course of SQL Server Training for Development, you will be able to learn about SQL architecture, server/client relations, stored procedures, functions, SELECT statements, data types, and views.

by Training Hub [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 ]
The Data Steps Logo

SQL Programming

SQL is the most sought-after skill for data analysis roles in all companies. So, whether you want to start a career as a data scientist or just grow your data analysis skills, this course will cover everything you need to know.

by The Data Steps [Claim Listing ]
Web Age Solutions team Logo

Querying Data with Microsoft Transact-SQL Training

This course will teach the basics of Microsoft's dialect of the standard SQL language, Transact-SQL.

by Web Age Solutions team [Claim Listing ]

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