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!
In the beginning of this year I lost my job as a landscaping and gardening supply store operations manager when the store, Detroit Farm and Garden, went out of business. After reviewing the Web site and visiting a few of the institutions, I decided to enroll at Global Information Technology. I was impressed with this [...] Read more
Zackery Finn
I cannot begin to tell you how fortunate I am to have found Global Information Technology (GIT). I had been laid off in the spring and was looking for a new job. The Web Program sparked my interest. I have degrees in Advertising and Graphic Design but learning to design web sites was something I [...] Read more
Jennifer Dudek
My name is Lesley Goodwin and I work in financial services industry as a Marketing and Communication Manager. Over the past two years, I have exchanged emails with GIT while researching several training options. GIT continued to keep me informed of their class outline and when I learned they could coordinate a class around my [...] Read more
Lesley Goodwin
As a United States Army veteran, I participated in four (4) combat tours and a tour of duty to South Korea. I am a three (3) time veteran of Iraq, serving in various capacities in Operation Iraqi Freedom (OIF) I, III and Operation New Dawn (OND) which ended the war in Iraq in December 2011. [...] Read more
Christopher B. Amara, Jr.
US Army Veteran
I was a Computer Technician with a major Corporation for 33 years when organization downsizing impacted my career. After 33 years, it was hard to fathom unemployment not to mention what to do next. I was angry, frustrated, and upset! After a few calming days of contemplation and a few weeks of unsuccessful job searches, [...] Read more
David Gough
866-GO-GIT-GO