Pre-Requisites: Familiarity with data processing concepts and techniques Data processing.
Create reports of sorted and restricted dataRun data manipulation statements (DML) to update dataControl database access to specific objectsManage schema objectsManage objects with data dictionary views Retrieve row and column data from tables.
In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level.
This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course discusses how to use the regular expression support in SQL.
This course is a combination of Oracle Database 12c: SQL Fundamentals I and Oracle Database 12c: SQL In this course, students use Oracle SQL Developer as the main development tool. SQL*Plus is introduced as an optional development tool.
This course counts towards the Hands-on course requirement for the Oracle Database 12c Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement. This is appropriate for a 10g audience too.
Real testimonials from our Students!
I would like to thank you for the great experience I had with the “Java Professional” course taught by our knowledgeable instructor. He was very patient with us when explaining programming concepts that are new to the Java Language. He pointed out topics that will be covered in the Certification exam that will help prepare [...] Read more
Sandy Skrbina
First of all I would like to start out by saying a big  thank you to Global Information Technology who not only provided me with my CompTIA A+ and Network+ training, however they helped me to get full time employment with benefits. The Director at Global Information Technology requested, I try and get some funding [...] Read more
Haitham Muhsin
I was hired into Global I.T. late May, coming from three separate jobs that I had been working simultaneously. Manish gave me the chance to start with Global IT to pursue Office Assistant and also suggested that I take the MS Office Suites class that they offered. I was constantly surrounded by people that encouraged [...] Read more
Mieh Khatib
I wanted to take an opportunity to provide an update on my career since deciding to take classes with Global Information Technology. As you know, after nearly 15 years with a major player in the field of IT solutions, I was laid off from my job in December of 2008. After taking stock of what [...] Read more
Robert Franklin
1/9/2025. The Business Data Analytics (BDA) course at Global Information Technology (GIT) was a game-changer for my career. The course provided me with in-depth knowledge of key technologies such as Power BI, SQL, and Advanced Excel, along with hands-on experience through real-world projects. The expert instructors and their practical approach helped me develop the skills [...] Read more
Tejaswini Mokashi
866-GO-GIT-GO