AMFASOFT CORPORATION - Laserfiche WebLink

Home Browse Search

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 to 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 Leaning 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 regular expression support in SQL through expert instruction. Program In Duration: Course Name Clock Hours Duration Maximum Completion Time Oracle SQL 12c 160 hours 8 weeks 12 weeks Pre -requisite: Basic computer knowledge Instructional Material: Oracle University eBook Total Charles For Period of Attendance & Estimated charges for entire proaram:$3,075.00 Tuition Fee: $2300; Registration Fee: (Non —Refundable): $75; Book: $200; Equipment: $500 Requirement for completing the program: Students should complete the program at Amfasoft— Oracle Authorized Education Center. Student required completing the program and may take the following exams Oracle SQL: Exam 1ZO-051 122