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 am writing you this letting in praise of GIT, its wonderful staff and the learning experience I had in my time there. I have been an IT professional for 10+ years but never took the time to obtain any credentials or certifications along the way. When I finally decided it was time to do [...] Read more
De McCadney
I worked 17 yrs in manufacturing as a Hilo driver, a material processor and 9 yrs as a Quality assurance technician and was let go due to the economy in February 2007. During that time I’d always had a passion for the computing arena so after weighing my options and overcoming the fear that can [...] Read more
Ralph Cook
My name is Cedric Porties, and I am currently employed as a systems administrator for Electronic data Systems. I was made aware of Global Information Technology from a local computer magazine. After much speculation due to a situation from another private school I previously attended, I decided to go in and speak with a representative. [...] Read more
Cedric Porties
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 am writing to thank all of the hardworking individuals at Global IT. Without your support, it would not have been possible for me to make such a smooth career transition. After being laid off from the tool making industry, I had the opportunity to enroll in the program at GIT. With a family to [...] Read more
Stewart Sykes