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!
Greetings! I am a currently a student taking courses at Global Information Technology, a company that offers a complete suite of modern, relevant computer software, network and personal computer hardware training. Class sizes are small with extensive hands-on instruction. The company provides instruction in the most up-to-date software and information technologies and teaches using the [...] Read more
Zsombor Zoltan
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
After many months of searching for training with all the criteria and professionalism that I was looking for, I was fortunate enough to have been recommended to Global Information Technology. I followed up on the recommendation given to me and went to speak to a representative, who gave me a tour of the facility and [...] Read more
Leslie McKenzie
I am a recent hire at CRC and subcontracted though the Department of Defense. This is the best job I have ever had my whole life thus far; and this is just the start of my Information Technology (IT) career. Previous to this I was a Sheet Metal fabricator at various sheet metal companies in [...] Read more
Jon Tarlo
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
866-GO-GIT-GO