AMFASOFT CORPORATION (2) - Laserfiche WebLink

Home Browse Search

Oracle SQL 12c Program Description This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. Course Objectives • Understand the basic concepts of relational databases ensure refined Code by developers. • Create reports of sorted and restricted data. • Run data manipulation statements (DML). • Control database access to specific objects. • Manage schema objects. • Manage objects with data dictionary views. • Retrieve row and column data from tables Course Delivery Option: Classroom, Online/Distance Learning Sequence and frequency of class sessions: Every 6 weeks Related Job Titles/Occupations Software Developers and Programmers SOC Code 15-1130 Computer Operators SOC Code 15-1100 Database Administrator SOC Code 15-1140 Instruction Details Oracle SQL - This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date -time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction. Program In Duration: Course Name Oracle SQL 12c Clock Hours Duration Maximum Completion Time 160 hours 8 weeks 12 weeks Pre -requisite: Basic computer knowledge Instructional Material: Oracle University eBook Total Charges For Period of Attendance & Estimated charges for entire program:$2575.00 Tuition Fee: $2300; Registration Fee: (Non —Refundable): $75; Book: $200 Requirement for completing the program: Students should complete the program at Arnfasoft — Oracle Authorized Education Center. Student required completing the program and may take the following exams Oracle SQL: Exam 1ZO-051 116