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!
This is just a note of thanks to you and your staff to express how pleased I am with the education I am receiving from Global Information Technology. In March, 2007 I was without employment for the second time within four months. Even though I had a Master of Arts Degree in Education, the lack [...] Read more
Debbie Leveski
I am writing this letter with the utmost sincerest appreciation, respect and regard for the staff and faculty at Global Information Technology. Words cannot express the gratitude I have for everything you have done for me. When I began at GIT, I was unsure about a few things: the means to reach my goal and [...] Read more
William Dicks
I am writing this letter to express my sincere gratitude for the expertise shared throughout my studies in Global Information Technology, a superior training institute. I am thankful to all of the hardworking individuals at Global Information Technology especially to my instructors and career advisor. I had Oracle 10g Database Administrator and ASP .Net courses [...] Read more
Jawahar Babu
I spent years working as an electrical technician for a tier one automotive supplier. Recently with the down turn with the big 3, my job like many others became very unstable and I spent a lot of time laid off or underemployed. After filing for unemployment for the third time that year I spoke with [...] Read more
Anthony Castleberry
Before Global IT I was a landscaper working hard manual labor. As much as I enjoyed landscaping I knew that I didn’t want to do this forever. So, I decided to start my journey into the IT world. Global IT has helped me so much navigating this career. From their outstanding classes with teachers who [...] Read more
Joseph Galindo