Pre-Requisites: Familiarity with data processing concepts and techniques Data processing.
Create reports of sorted and restricted dataRun data manipulation statements (DML) to update dataControl database access to specific objectsManage schema 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 12c: SQL Fundamentals I and Oracle Database 12c: 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 12c Administrator Certification. Only instructor-led inclass 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!
After suffering through unemployment for over a year with a bleak outlook for future employment opportunities in the Criminal Justice field that offered no upward mobility, I made the decision to return to school for some needed updated IT skills and current certifications. I selected Global Information Technology for my updated training. I started my [...] Read more
Randy Schales
Thank you for changing my life. Before I started Global Information Technology (GIT), I felt like I’d be selling shoes for $7.50 an hour for the rest of my life. My lack of self esteem made me miss out on great opportunities. Your wonderful Network Engineering Professional program and extremely helpful staff helped me to [...] Read more
Adeel Irfan
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 would like to express why I would recommend Global Information Technology (Global-itech) to anyone who wishes to further their career in the Information Technology. I have been in the IT field for over twenty years. In July of 2010, HP made the decision to reduce their staff and subsequently gave me only two months [...] Read more
Timothy Hughes
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
866-GO-GIT-GO