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 - دبي
-
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! -
I had a fantastic experience with my design teacher. His passion for the subject was evident in every class, and his guidance greatly improved my skills. The constructive … More feedback and creative approach to teaching made the learning process enjoyable. I highly recommend this teacher for anyone interested in design.
Mr.Bineesh.... Many thanks! -
Thanks so kindly to the Rolla academy family for the good cooperation and support towards my MS Office academy experience. I am so grateful and delighted and satisfied … More with the MS Office experience that I undertake with you people. I must admit I had no idea on MS Office, But with you people I able to proper my own word document, PowerPointing Excel, and outlook email. This appreciation goes mostly to Mr Irfan. You are a good instructor. I really admired your good teaching experience.
Sincerely yours:
Abraham V Sheriff -
Hi I would like to appreciate Mr Muhammad Irfan, for teaching me well my MS Office Basic, he was very patient with me, he couldn't get tired to repeat for … More me as many times until I understood everything, he is the best teacher so far I have ever met... the school great, the lady at the reception 👏 👌, the hospitality from everyone is welcoming plus its very affordable. I will greatly recommend Rolla Academy to everyone who wants to enroll computer classes plus other courses, it's really nice.
-
The coaching was excellent. My Trainer, Mr. Irfan is explaining the classes very well. Honestly, I'm very much satisfied and confident after this class. Thank … More you very much for your patience in teaching me.
-
I enjoyed learning the graphic designing course in rolla academy mainly due to the fact of the support received for the teacher MR. Bineesh he was really great at … More explaining the basics and more advance techniques of the three softwares that were used and also answered any questions that I had so it was an enjoyable experience learning at rolla academy.Thank you
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.
