Pre-Requisites: Familiarity with data processing concepts and techniques Data processing.
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.
Real testimonials from our Students!
“This was, by far, the best class experience I have had since high school. I took the COMPTA+ and Networking+ classes at Global Information Technology, and within a few months of completing these classes, I had a Level II Technical support position. The instructors were fantastic and really cared about my learning. If I had [...] Read more
Jonathan Nimene
I’d just like to thank Global IT for getting my career back on track. Before joining your school I was at a major crossroads in my life; I had depleted my unemployment benefits and was deciding on which direction to take my career. The economy was making companies close their doors and companies which did [...] Read more
Daniel Vitale
I would like to take this opportunity to thank the entire team for providing the training and resources needed to get my career in Information Technology (IT) off to a great start. Having experienced a variety of jobs previously – including a stint as a Mortgage Officer for a large local Bank, and my prior [...] Read more
Garrett Mason
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
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
Brandon Mytty
866-GO-GIT-GO