Create reports of sorted and restricted data Run data manipulation statements (DML) to update dataControl database access to specific objects Manageschema 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 18c: SQL Fundamentals I and Oracle Database 18c: 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 18c Administrator Certification. Only instructor-led in class 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.
Course Number : ORCL-7-0121
Duration : 40 hours
Real testimonials from our Students!
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
I am writing this letter with extreme gratitude and appreciation. In the early spring of 2006 I decided to embark on a journey of your Network Engineering program. I knew the program would take much time and effort on both my part and yours. Before I started this program I wanted to make sure that [...] Read more
After being laid-off and getting frustrated looking for work in the current market with outdated AS/400 and Mainframe skills, I decided to visit a few training providers to investigate some tech training to upgrade my skills set. The third one I visited was Global Information Technology. My first impression was very positive. The representative’s passionate [...] Read more
I am writing this letter to inform you of my satisfaction with my son’s ( John Parkinson II) learning experience at Global Information Technology. He enrolled in your A+ , MCSE 2003 and CCNA programs in August 2007. The training provided by Global Information Technology became the foundation for his now growing IT career. After [...] Read more
John Parkinson II
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