What I've learn and do during this training?

" There's a  3 month course to get Oracle certificate and its FREE!"

Why not, right? From programming to Oracle. Coding to the database. Web to Architecture. Seem new things for me. From 28 august to 25 October 2016. 3-challenging-month to get a certificate and learn a new thing. So wow !

There have two sessions regarding this course which is first month are classroom training about oracle. In the first month of this program, participants have attended classroom training conducted by VTC’s Oracle certified trainer, Mr. Goh and Mr. Leong.

" They are very expert "

In classroom training, our syllabus has been divided for 4 weeks and 4 different new things. Oracle Virtualization, Oracle Linux, Oracle Database, Oracle SQL and Oracle Business Intelligence Enterprise Edition (OBIEE) are syllabus that participant need to complete. Basically, in Oracle Virtualization and Oracle Linux we learn about how to setup our own virtual machine using facilities that Universiti Teknologi Malaysia provided. Actually, we learn about the Database and architecture of Oracle using Oracle Database.

In addition, they also introduced us concept of data model and data warehouse that are strictly important because of industry demanding.  The participant needs to build a report from Oracle Business Intelligence Enterprise Edition (OBIEE). Personally, this knowledge are very important to our industry nowadays in condition of fresh graduated. For their schedule that VTC prepared for us are very amazing within 4 days are theory class and every Friday we have a presentation such as prepared our own database in term of Oracle Edition.

 In every theory classroom training, we need to follow by their note and syllabus. In every of class session the prepared many tutorial and individual assignments about every syllabus and chapter. As a participant, this such idea is very important for students to understand about Oracle and more comfortable in an enterprise environment.

After finishing on classroom training, for the next 2 months, all participants need to attend on-the-job-training on VTC office itself in Medini 6, Iskandar Puteri, Johor Bahru. For sure this agenda is to expose all participants in real work life with real project. Seem scary right? From our trainer, firstly the trained us with real environment database but not in real project. After than that, they will give all participants with real project. Before than that, VTC gave us on 5 team,which is Technical Architect, OBIEE team, Java team, SQL team.

Basically i'm in Technical Architecture team. The job are very challenging from my expectation. Installing, migrating and troubleshooting are our main objective or scope for TA. This job are guide by Mr.Goh that really cool and very experience.

Ye ! ini adalah aku. Amali Mohd Shukor, anak jati Negeri Sembilan dan baru menghabiskan Ijazah sarjana Muda dalam bidang komputer perniagaan di UiTM Dungun, Terengganu. Dalam kursus seramai 40 orang dalam pelbagai university dan negeri dan kami terpaksa melalui persaingan sihat antara kami sendiri untuk memenuhi piawaian yg telah VTC tetapkan.

Sebagai pelajar Komputer perniagaan, Oracle adalah satu cabang yang baru dan agak sukar untuk kami. Dengan bantuan pengajar yang professional dari VTC, kursus yang sukar menjadi agak mudah dengan suasana kerja yang selesa. Dengan persaingan yang agak ramai membuatkan kursus Oracle ini adalah salah satu kursus yang agk penting untuk seorang pelajar IT dalam menghadapi suasana kerja.

Thousand thanks to Global Business Services, i2m, Universiti Teknologi Malaysia (UTM) Johor Bahru and Vision Technology Consultant :)


Any question about this course?

www.vtcholding.com

Vision Technology Consulting Sdn Bhd (Malaysia - Klang Valley)
Suite 3-1, 3rd Floor,
Block 4800, CBD Perdana,
Off Persiaran Multimedia,
63000 Cyberjaya,
Selangor, Malaysia
Office: +603 8322 0127   Fax:+603 8319 4510
 

What is OBIEE?

What is OBIEE? OBIEE are short form to Oracle Business Intelligence Enterprise Edition 11g and it is a comprehensive business intelligence platform that delivers a full range of analytic and reporting capabilities. This Application provide interactive dashboard, ad hoc queries, mobile analytics, notifications and alerts, enterprise and financial reporting, scorecard and strategy management.

There have 4 architecture components:

1.       Presentation Services (Analysis Editor and Dashboard)

2.       Oracle Presentation Server (Presentation Catalogue)

3.       Oracle BI Server (Repository)

4.       Data Sources 

For one day we learned how to install all Oracle Business Intelligence products intended for Weblogic. Basically, Weblogic domain must be installed configure at the same time. All the installation must be followed the method and procedure. All the installation basically are provided by Oracle and the trainer.

The lesson also stress about what is Repository Creation Utility (RCU) and it act as graphical tool for creating and managing Oracle Fusion Middleware Database Schemas in the database. How to start Oracle Database?

How to start OBIEE? There have 4 way to start the OBIEE. Firstly,  we need to start weblogic by enter the directories of the weblogic (cd /home/oracle/bi11g/user_projects/domains/bifoundation_domain/bin) and type  ./startWeblogic.sh. secondly, we need to start the Node Manager by enter the directories and type ./startNodeManager.sh. Thirdly, we need to start Managed Server using same method but with localchost and followed with port number.

Lastly, we need to start all Oracle Process Manager and Notification Server (OPMN) . There have several tutorial that trainer gave to us including how to do report from Oracle about business intelligence. All the tutorial are mainly from limiting and grouping data, view and graph in analysis. For Limit data, we are using Filters.

          1. Only those results that match criteria are incuded

          2. Filters are applied before the query is aggregated.

Another methods on limit data are using Selection and creating groups. All the methods are basically using same database and same tutorial but different team. Pivot table? The function of pivot table are customize the overall appearance of a pivot table by applying green-bar styling and formatting

In last day of OBIEE lessons are Graph Formatiing. The only method for showing a graph on report are Graph Properties. Ther have several elements in graph formatting and there are :

         1. General

         2. Style

         3. Scale

         4. Title and Labels

That's all for today! Any question?

www.vtcholding.com

Vision Technology Consulting Sdn Bhd (Malaysia - Klang Valley)
Suite 3-1, 3rd Floor,
Block 4800, CBD Perdana,
Off Persiaran Multimedia,
63000 Cyberjaya,
Selangor, Malaysia
Office: +603 8322 0127   Fax:+603 8319 4510

What is Oracle Database?

Part 1

" Oracle Database (Commonly referred to as Oracle RDBMS or simply as Oracle) is an object relational database management system produces and marketed by Oracle Corporation. Larry Ellison and his two friends and former co-workers, Bob Miner and Ed Oates, started a consultancy called Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle Software. The name Oracle  comes from the code-name of a CIA-funded project Ellison had worked on while formerly employed by Ampex " - Wikipedia

There are three major structure in Oracle Database server Architecture :
          
             1. Memory structure
             2. Process Structure
             3.  Storage Structure

A basic Oracle Database system of an Oracle database and a database instance. The instance is consists of :

             1. Memory structure
             2. Background Process

Memory are called System Global Area (SGA) and contains :

            1.Java pool
            2. Buffer cache
            3. Redo buffer
            4. Shared pool
           5. Streams pool
           6.  Large pool

Outside from SGA are Process Global Area (PGA) that connected to System Global Area.

System Global Area

Memory districts that contain information and control data for a server or foundation process. A PGA is non-shared memory made by Oracle Database when a server or foundation procedure is begun. Access to the PGA is selective to the server procedure. Every server procedure and foundation process has its own PGA. When a table is created, a segment is created to hold its data. A tablespace contains a collection of segments. Logically, a table contains rows of column values. A row is ultimately stored in a database block in the form of a row piece. Content of Database block are  Block Header, free spaces (Growth) and Row data.

Instance for database also we learned on classroom training. The database instances and database go through stages as the database is made for access by the user. " Each instance each database". This function for any valid user can connect connect to the database and perform typical data access operations. There also several type we shutdown the instance shutdown abort, immediate, transactional and normal.

Listener? What is listener? listener or Oracle Net Listener is the gateway to the oracle instance for all nonlocal user connections. As for me, listener are interpreter between user to system. " Bridge ! bridge is a thing that connect between town and island, so that's mean if the bridge are destroyed and other car from town cannot go through to the island and its act as listener." Basically one database can have many listener and default port are 1521.

listener

Also security are one of important element  in Oracle Database. To access the database, a user must be specify a valid database user account and successfully authenticate as require by that user account. each user account has unique username, authentication method, default tablespace, temporary tablespace, user profile, initial consumer group and account status. There has several element on this Oracle Database need to stress it.

 With Oracle database, space is automatically managed by the server. In Oracle database, the features include managed files, free-space management with bitmaps, proactive space management, space reclamation and capacity planning. Segment is a set of extents allocated for a certain logical structure and another types of segments table and cluster segments, index segment, undo segment and temporary segment.

Tablespace

That's all for today! Any question?

www.vtcholding.com

Vision Technology Consulting Sdn Bhd (Malaysia - Klang Valley)
Suite 3-1, 3rd Floor,
Block 4800, CBD Perdana,
Off Persiaran Multimedia,
63000 Cyberjaya,
Selangor, Malaysia
Office: +603 8322 0127   Fax:+603 8319 4510