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!
Global Information Technology: To whom it may concern: I was looking around for a training institution that offered Oracle 10g DBA program. I found only one school that offered this program at the best price and the right fit for me. The school name is Global Information Technology (Global I.T.). I still remember that moment [...] Read more
Vijaykumar Patel
I’d like to take my time to thank you and GIT for your wonderful assistance with getting me into a successful IT Career. You and your staff demonstrated great care in ensuring that I was able to be placed in a great job after completing my classes at the school, offering help with resume creation [...] Read more
Christopher Leimback
I started attending GIT in January, 2008. Prior to this decision I researched several schools, and found that GIT offers so much more in class opportunities and is the most economical. I must be honest, I was quite apprehensive about going back to school; it had been along time since I attended any classes. However [...] Read more
Katrina Larmon
I joined Global IT’s Software QA & Testing, Oracle 12c SQL, and Oracle JAVA SE 8 programming from February 2018 to June 23, 2018. The Director at Global Information Technology tailored my courses to fit my career path and goals. The QA Testing course was perfect timing for me as well as relevant to the [...] Read more
Gilbert Lopez
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
866-GO-GIT-GO