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!
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
September 28, 2021 The skills I obtained from the Project Management Professional and the Business Analyst class from GIT were phenomenal. After over a year off due to COVID pandemic, I was able to further my education with these two wonderful classes, which were cross functional for me as what I learned in the one [...] Read more
Annie M. Sadecki
9/30/2020 G.I.T, Global Information Technology, one the “stomping grounds”, for me to get a head-start in my career in IT was very foundational. Coming from where I did-nonetheless, how I did, this school was ‘almost’ like a sanctuary for me to tune in, stay focused, and connect with individuals from all walks of life pursuing [...] Read more
William Jones
I am writing this letter to inform you of my satisfaction with my son’s ( John Parkinson II) learning experience at Global Information Technology. He enrolled in your A+ , MCSE 2003 and CCNA programs in August 2007. The training provided by Global Information Technology became the foundation for his now growing IT career. After [...] Read more
John Parkinson II
In the beginning of this year I lost my job as a landscaping and gardening supply store operations manager when the store, Detroit Farm and Garden, went out of business. After reviewing the Web site and visiting a few of the institutions, I decided to enroll at Global Information Technology. I was impressed with this [...] Read more
Zackery Finn
866-GO-GIT-GO