skip to Main Content

Database Technologies

Oracle Workforce Development Program at PCATT

The Oracle Workforce Development Program at PCATT is one of the data technology programs which provides training in Oracle’s Database 12c technology and its relational database concepts. There are many compelling new features and improvements in 12c. Most important are:

  • Multitenant and pluggable database
  • Automatic data optimization
  • In-Memory caching, compression, and column store

Take advantage of these training opportunities to learn important and relevant data management skills through the Oracle Workforce Development Program.

Database Technologies

Basics of Microsoft Power Business Intelligence (BI)

Visualizing data and sharing it among the consumers inside your organization has more value than having data in database servers. Although the availability of data is important, to be able to visualize all aspects of the data serves the bottom line of an organization is more important.


PowerBI makes it possible to not only visualize data but helps you make quick decisions. PowerBI allows you to connect to data from a wide variety of data sources, both traditional database servers but also from online data; it creates a model and then you start exploring data in a variety of ways, producing a wide array of graphs and presentation which you can publish, share or collaborate.


PowerBI targets naïve, intermediate and advanced users. PowerBI has capabilities built to accommodate all experience levels.


This course however, is aimed at beginner users with limited data experience enabling you to adhoc-visualize data and generate reports. Specifically, you will have an introduction to PowerBI Desktop, one of the PowerBI products, and see how to access data and visualize it from a couple of sources. Although the course is partly hands-on, it is meant to provide an introduction to the topic.

Section - COM2131-002

Section - COM2131-003

Database Analytics: Big Data and NoSQL

This course, while presenting a contemporary Information Technology Database Technology, introduces students to basic technology (algorithms, architectures, systems) in connection with large-scale data management and information extraction techniques for big data. The course will start by introducing Big Data models, databases and query languages, cover modern distributed database systems and algorithms, and Big Data systems adopted in industry and science applications. Implementation of a data analysis engine on a standalone machine will be covered and students will learn how to build their own database engine for Big Data. The course will also cover critical topics in mining and knowledge discovery of big data, with applications in social analytics, cyber security, and information networks.

Section - COM3054-001

Internet of Things (IOT)

This course presents contemporary Information Technology topics on the Internet of Things. The purpose of this course is to maintain currency with rapidly changing technologies throughout the world, with an emphasis in Hawai‘i’s business industry. The Internet of Things is an emerging and rapidly growing area within IT. This course will be primarily organized around group projects using technologies associated with the Internet of Things.

Section - COM3050-001

Introduction to Data Analysis

Introduction to Data Analysis sets a foundation for those interested in pursuing more advanced topics in data analysis.

Becoming a data analyst requires proficiency in several areas:

  • Data wrangling
  • Programming
  • Statistical methods
  • Machine learning
  • Data visualization

There is truly a vast amount of open data available to anyone who knows where to find it, but data is often found in a form that does not lend itself to analysis.

Data wrangling is the use of tools and techniques to transform unstructured data into structured data from which descriptive, predictive, and prescriptive analytics can be derived. Business leaders depend on high-quality, real-time analytics to make informed business decisions. This "business intelligence" enables a company to differentiate itself from its competition, but high-quality, real-time analytics is the end game. One has to walk before they can run. Data analysts often point out that roughly 70% of their work involves data wrangling.

This course sets you on a successful path in data analysis by building a solid foundation. A course will follow that introduces learners to machine learning via Microsoft Azure Machine Learning Studio.

Recommended preparation: Algebra and basic statistics. No programming experience is required - the necessary R programming will be learned in the context of working with data sets.

Section - COM2082-012

Introduction to Structured Query Language (SQL)

Databases, organized repositories of information, have become indispensable in today's world. In this introductory course you will learn about relational databases and the basics of Structured Query Language (SQL) including sorting; grouping result sets; using DDL, DML, DCL, and TCL. All SQL statements will initially be written for one table. Most practical, modern and relational databases will include a large number of tables and SQL queries have to access information from several tables. This course will introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database.

This is a hands-on course which will take you from installing SQL Server 2016 to learning the ins and outs of SQL Server Management Studio and of course a full dose of SQL. The course covers most of the requirements to take Microsoft's certification (98-364), the Microsoft Technology Associate. During each meeting, you will be assessed for your knowledge, competency and proficiency in SQL.

Section - COM2037-017

Oracle Database 12c R2: Administration Workshop Ed 3

The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this hands-on course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. Learn to:

• Manage an Oracle Database instance

• Configure the Oracle Network environment

• Create and manage storage structures

• Manage and move data • Create and manage users

• Monitor the database and manage performance

• Create and manage Database as a Cloud Service database deployments

Benefits to you: You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

Section - COM2130-002

Section - COM2130-003

Oracle Database 12c: SQL I - Introduction

This course is an introduction to SQL. It teaches you how to query or update data in a relational database management system (RDBMS). In this class, you learn the concepts of relational databases and the powerful SQL programming language, all in a practical and hands-on environment. Learn to:

• Run complex queries to retrieve data from multiple tables

• Run data manipulation language (DML) statements to update data in a database

• Run data definition language (DDL) statements to create and manage schema objects

• Identify the major components of Oracle Database and MySQL database

• Retrieve row and column data from tables with the SELECT statement

• Create reports of sorted and restricted data

• Employ SQL functions to generate and retrieve customized data

Benefits to you: This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. You can use SQL Developer to access an Oracle database or MySQL Workbench to access a MySQL database. You can also experience using SQL*Plus to access an Oracle database or MySQL command-line client to access a MySQL database. You will see SQL statements that are identical in both Oracle database and MySQL database, and also see the variations in output or syntax between the databases in some statements.

Section - COM2128-004

Oracle Database 12c: SQL II – Intermediate

The Oracle Database: SQL Workshop II Ed 2 course will help you enhance your skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. You also learn to write more efficient queries using the functions supporting the timezone and regular expressions.

Learn to:

• Grant and revoke privileges and roles

• Manage schema objects and data dictionary views

• Write efficient and complex subqueries

• Use the in-built functions supporting the usage of regular expressions and time zone

Benefits to you:

This course is designed for application developers with basic SQL language skills. You learn how to use the advanced features of SQL in order to query and manipulate data within the database. You will also learn how to control privileges at the object and system level. Advanced querying and reporting techniques are explained. You will learn to use the regular expression support in SQL. You benefit by using Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is introduced as an optional tool. Demonstrations and hands-on practice reinforce the concepts.

Section - COM2129-002

Section - COM2129-003

Programming Database Driven Websites

The purpose of this course is to maintain currency with rapidly changing website technologies throughout the world, with an emphasis in Hawai‘i’s business industry. Websites have become the standard medium for exchanging data between users and organizations, as well as between users. Websites interface user client-side browsers to organizational databases. This course is a project-based course where students can expand upon their knowledge using the most common client-side programming languages as well as the most common server-side scripting language and database technology in use by organizations today. Projects will include writing client-side programs in HTML, JavaScript, jQuery and Angular JS, as well as server-side programs written in PHP interfacing to SQL databases. Students also learn how to configure WordPress websites interfacing server-side SQL databases.

Section - COM3001-001

Follow PCATT on Social Media

Back To Top