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.
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
- 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-009
Lewis | Honolulu Community College | $845
No meeting on February 18. In-person meetings on February 7 and 26. This is a hybrid course with 2 in-person meetings which can be accessed remotely if you prefer. Lectures are delivered via the web and are archived for registered participants to view asynchronously.
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.