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!
Global Information Technology: To whom it may concern: I was looking around for a training institution that offered Oracle 10g DBA program. I found only one school that offered this program at the best price and the right fit for me. The school name is Global Information Technology (Global I.T.). I still remember that moment [...] Read more
Vijaykumar Patel
I am writing this letter today in recommendation of Global Information Technology (GIT). In the spring of 2008 I learned that my employment position was being off-shored. Of course this was devastating news. Even though I possess a bachelor’s degree in Information Systems, I realized I did not specialize in any specific IT area and [...] Read more
Lynda Wilson
I was an out of work Engineering Technologist from ford motor. With a strong background in Electrical, Electronics and Mechanical. But no jobs. In this bad economy I was quite depressed and decided to do something about it. When your school was recommended I decided to go there and take a look. I liked what [...] Read more
Heather Berry
I am currently attending classes at Global Information Technology in the Enhanced Oracle Certified Professional DBA program funded by the State of Michigan “No Worker Left Behind” grant. I have attended the 10G Oracle Certified Professional (OCP DBA) classes in the October 2009- March 2010 period. This coursework is compatible with my data engineering background [...] Read more
Sid Stoffer
I want to take this opportunity to tell how pleased I am with having selected Global Information Technology for my training. About six months ago I requested information from several schools in the Detroit area. After speaking with each of them I chose Global Information Technology. I found your staff very friendly and professional. Your [...] Read more
Mike McCain
866-GO-GIT-GO