Oracle Database

What You Will Learn This course is designed to give you a firm foundation in basic database administration. Lesson topics are reinforced with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam. Learn To: Install Oracle Grid Infrastructure. Create and manage users. Install and configure an Oracle Database. Create and

read more

What you will learn This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. Learn To: Diagnose and repair data failures with Flashback

read more

COURSE DESCRIPTION : In this course, students learn the basic concepts of a data warehouse and study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn to improve performance or manageability in a data warehouse using various Oracle Database features. COURSE MODULES : Introduction Data Warehousing, Business Intelligence,

read more

COURSE DESCRIPTION : Participants learn about Oracle’s Database partitioning architecture and how to identify the benefits of partitioning in addition to using parallel operations to reduce response time for data-intensive operations. Participants extract, transform, and load data into an Oracle database warehouse. Participants also use materialized views to improve the data warehouse performance and learn

read more

WHAT YOU WILL LEARN Understand the basic concepts of relational databases ensure refined code by developers. Create reports of sorted and restricted data. Run data manipulation statements (DML). Control database access to specific objects. Manage schema objects. Manage objects with data dictionary views. Retrieve row and column data from tables. Control privileges at the object

read more

COURSE DESCRIPTION : This course provides step-by-step instructions for creating Oracle BI analyses and dashboards in business intelligence applications. You’ll begin by building basic analyses to include in dashboards, with more complexity as the course progresses. COURSE OBJECTIVES : COURSE TIME Combine analysis criteria across multiple subject areas and execute direct database queries Perform pre-

read more