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!
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
I’d just like to thank you and Global Information Technology for getting my career back on the right track. I had been unemployed for nearly 2 years after being laid off from ACCESS and I have been trying to find the right job. Couple months after applying to the unemployment, Michigan Works office approved me [...] Read more
Racha Ramdan
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 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
It gives me immense pleasure to recommend Global Technology Information (GIT) to any technical inclined person who is seeking to become a top-notch Information Technology Technician (ITT). GIT is a unique technology school that I had the pleasure of attending. It is true that it is dedicated to providing high quality and cost effective training [...] Read more
Eddie Henderson
866-GO-GIT-GO