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 letter is recognition of Global Information Technology for their outstanding computer training courses. I have been attending courses at GIobal IT and have recently completed my course work for Microsoft Office Professional. I found the experience to be both enriching and gratifying. The instruction was easy to follow and very thorough. I highly recommend [...] Read more
David Taylor
While serving in the military I often found myself interested in pursuing a career within IT. Shortly after exiting the military, I started my journey and landed a position as an apprentice with a global consulting firm. I was quickly able to recognize that I was going to need more knowledge than just a web [...] Read more
Brian Cancel
Dear Manish: I wanted to also take this opportunity to thank you, and the Staff at Global IT. You and your staff all really changed my life. I know you all know my story and where I came from and where I am now. If it were not for how you conduct classes, and the [...] Read more
Bradley Freeland
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
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