Oracle Sql
Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is the world’s most popular database for running online transaction processing, data warehousing and mixed database workloads.
Introduction to Databases
CODD'S Rules
Datatypes and Creating Tables
Oracle SQL SELECT Statement
Formatting Output in SQL * Plus
UNION, INTERSECT, MINUS Operators and Sorting Query Result
Oracle SQL Functions
Oracle Join Queries, (Inner Join, Outer Join, Self Join)
GROUP BY Queries, SUB Queries
CUBE, ROLLUP Functions, WITH, CASE Operators
Oracle Data Manipulation Language (INSERT, UPDATE, DELETE, INSERT ALL, MERGE)
Oracle Data Definition Language (CREATE, ALTER, DROP, TRUNCATE, RENAME)
Oracle Transaction Control Language (COMMIT, ROLLBACK,SAVEPOINT)
Data Control Language (GRANT, REVOKE)
Oracle Transaction Control Language (COMMIT, ROLLBACK,SAVEPOINT)
Data Control Language (GRANT, REVOKE)
Oracle Integrity Constraints (PRIMARY KEY, NOT NULL, CHECK, FOREIGN KEY, UNIQUE)
Oracle Date Operators, Functions
Managing Oracle Views
Managing Oracle Sequences
Managing Oracle Synonyms
Managing Indexes and Clusters
Oracle Table Partitioning and Creating Partitioned Tables
Oracle Objects and Object Types
Rolla Academy Dubai
Al Tawhidi Building II - 201 - 2 Al Mankhool Road - دبي
-
I'm happy with the training which I received from Rolla Institute Dubai. The trainer Lagiru good with the subject and the manager is very helpful. I recommend … More Rolla for everyone.
-
Rolla Academy is the best platform to prepare IELTS in the entire Dubai Area.
Specially, Dear Surjit Singh Sir, Thank you for refilling my confidence in me. You … More are a wonderful tutor and i always appreciate your guidance and encouragement . -
My experience at Rolla Academy Dubai was very good as I took up few IELTS classes by Mr. Surjith Sir who taught me everything from the start. He made the learning … More experience easy and quick by providing materials and earphones to listen to the audios during listening test. Overall it was a very good experience as I got to work on my mistakes and learn more
-
First of i would like to thanks Mr Surjit sir for extra ordinary teaching support, guidance, easy IELTS trics and the way of teaching style is awesome. Becouse of … More this great teaching style finally i
achieved my Academic IELTS result with good score. Rolla academy staff is very friendly and helpful. Once again thanks to Professor Surjit Sir IELTS tutor and Mr Suddam ( Rolla academy) and all faculty professiors. -
From the beginning I wasn’t sure if I can actually learn digital marketing until Rolla Academy assigned Abishek as my trainer this young man is full of knowledge. … More
The school manager has the best personality I have seen for a very long time
He handle every complain with respect ✊
I will really recommend this school for any of your learning specially digital related
Thank Rolla academy -
Am happy and so blessed for having discovered Rolla Academy Dubai,great thanks to my teacher Mr.Mohamed Irfan,what sets him apart is his unwavering dedication to … More us the student success.Throughout the course, he fostered a supportive, inclusive learning environment where by questions from me as a student were not only welcomed but he encouraged them,Mr.Irfan took the time to address each inquirythoroughly ensuring that am not left behind at any topic in miscrosoft,He was so kind,gentle,polite,patient with me because the fact I joined his classes when am so ignorant about computer and all the basics but he helped me to Excel.I am so thankful to Mr.Irfan for his attentiveness in every interaction making for a truly enriching learning experience. Thanks alot to Mr.Irfan and to Rolla Academy to help me Excel in fact am looking forward to enroll with Rolla to an Advanced level.
-
I recently completed the MS Office Basic course at Rolla Academy Dubai, and I must express my gratitude to Surjit Sir and the entire academy team! The course was … More comprehensive, well-structured, and Surjit Sir's teaching style made complex concepts easy to understand.
The practical insights and hands-on experience gained during the sessions were invaluable. Surjit Sir's dedication to ensuring each student's understanding is commendable. Thank you for making learning MS Office a seamless and enjoyable experience.
I highly recommend Rolla Academy Dubai for anyone looking to enhance their skills. Thank you, Surjit Sir, and thank you, Rolla Academy Dubai!
More Courses You Might Like
Oracle E-business Suite Financials R12 (end-user)
END USER LEVEL COURSE: 1. Accounts Receivable (05 Hours) Invoice Process Flow • Invoice creation process • Revenue Recognition • Credit memo creation process • Invoice conversion, Multi Org • Receipts • Lock box for receipts • Reports 2. General Ledger (05 Hours) • Create a Chart Of Accounts • Define the Accounting Calendar •
Oracle Purchasing Course
Duration: 25 Hours Oracle Procurement – EBS R12 Overview of Oracle Purchasing Supplier Management Supplier Modification Item Attributes and Setup RFQ & Quotations Approved Suppliers & Sourcing Rules Purchase Requisitioning Processing Purchase order Processing Purchase order Receipt Processing Integration with other Modules Enterprise Structure overview Raising I-procurement Requisitions Receipting PO in I-Procurement Non-Catalog Requests Purchasing
Oracle Finance
Oracle Corporation groups these applications into “suites”, which it defines as sets of common, integrated applications designed to execute specific business processes.
