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!
While serving in the military I often found myself interested in pursuing a career within IT. Shortly after exiting the military, I started my journey and landed a position as an apprentice with a global consulting firm. I was quickly able to recognize that I was going to need more knowledge than just a web [...] Read more
Brian Cancel
I am writing this letter to inform you of my learning experience at Global Information Technology. I enrolled into your Network +, Security +, Linux +, SQL, Oracle 12C Database Administrator, MCSA 2012, CCNA, Web Pro, and Microsoft Office 2013 classes from March 2015 through June 2016. Immediately, I was impressed with the learning environment, [...] Read more
Keith Campbell
To the Global Information Technology Team, I would like to take this opportunity to thank your entire team for the excellent IT training that I have received. The hands on training and superb instructing have been invaluable. The staff at GIT has been extremely helpful in all manners. When I joined GIobal IT as a [...] Read more
Steve Hughes
I want to thank Global Information Technology for assisting with my job search and training needs. With the help of Michigan Works I was able to attend the Network Engineering Professional training class, consisting of CompTIA A+ and Network+, Microsoft desktop and server operating systems, Linux and Cisco CCNA. I am very impressed with all my teachers, [...] Read more
Weston Tatem
8/10/2017. My experience Global Information Technology was something I wouldn’t trade for the world. When I went there looking for A+ Training, I had been jobless for eight months. I was desperate to find something, anything that would change my life. Global Information Technology did just that. After completing the training program there, I actually [...] Read more
Wesley Cicotte
866-GO-GIT-GO