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 am writing this letter to express my sincere gratitude for the expertise shared throughout my studies in Global Information Technology, a superior training institute. I am thankful to all of the hardworking individuals at Global Information Technology especially to my instructors and career advisor. I had Oracle 10g Database Administrator and ASP .Net courses [...] Read more
Jawahar Babu
I have always prided myself in further educating myself. I have a bachelors, and during that time while working, I got my MBA. Throughout my career, I was lead to believe that loyalty and education will keep you ahead of the game and employed. One day, after 18 years of service at my job, I [...] Read more
Isaac Hatcher
I got an Associate degree In Electronics Engineering Technology in 1996. The results I got from getting that degree were good; however, I had been laid off several times within a time frame of 14 years. The last time I got laid off, I thought about my continued interest in computer technology and the lack [...] Read more
Mister Jackson
It is with great enthusiasm that I write a recommendation for Global Information Technology for the MCTS 70-431- SQL Server 2005 course. In that time, I have had the opportunity to receive a thorough understanding of writing SQL statements, stored procedures, triggers, functions and views. Other topics that were very helpful were database design, replication, [...] Read more
Larry Broaddus
I was a Computer Technician with a major Corporation for 33 years when organization downsizing impacted my career. After 33 years, it was hard to fathom unemployment not to mention what to do next. I was angry, frustrated, and upset! After a few calming days of contemplation and a few weeks of unsuccessful job searches, [...] Read more
David Gough