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!
Thank you for changing my life. Before I started Global Information Technology (GIT), I felt like I’d be selling shoes for $7.50 an hour for the rest of my life. My lack of self esteem made me miss out on great opportunities. Your wonderful Network Engineering Professional program and extremely helpful staff helped me to [...] Read more
Adeel Irfan
I was hired into Global I.T. late May, coming from three separate jobs that I had been working simultaneously. Manish gave me the chance to start with Global IT to pursue Office Assistant and also suggested that I take the MS Office Suites class that they offered. I was constantly surrounded by people that encouraged [...] Read more
Mieh Khatib
I began taking the Windows 2000 MCSE track in June of 2001. I decided to check out GIT after hearing an ad on the radio, and after viewing the facilities I signed up immediately. I attended classes on Tuesdays and Thursdays until the class ended in February 2002. I chose the MCSE course because I [...] Read more
David Warner
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
June 2, 2020. Before Global Information Technology I found myself in a “great job market” with no callbacks on the dozens of applications I submitted to companies all over metro Detroit. I was in a particular bind because I had work experience AND a graduate degree, but all of the offers I received were well [...] Read more
Stephanie Holley
866-GO-GIT-GO