- الموقع: 66 Dorset Street Lower, Dublin 1, Ireland - أيرلندا
- مدة الدورة التدريبية: 6 Months
تفاصيل الدورة
The Oracle Database 11g SQL Fundamentals course is designed to give learners practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions, SQL*Plus parameters and the basic table and view handling statements are introduced.
Oracle Database 11g SQL Fundamentals I candidates are expected to demonstrate proficiency in concepts of relational databases and the powerful SQL programming language. The certification is targeted at developers and database administrators who want to design, develop, and manage SQL based applications with the Oracle database.
The course also provides practical experience in using Oracle's PL/SQL programming language to implement conditional execution, loop control, cursor handling and exception handling.
Entry Requirements
An understanding of databases and exposure to information technology in general.
This course is for those who needs to use and understand Oracle SQL to query and update an Oracle database; and who also needs an introduction to the PL/SQL programming language
Oracle Database 11g SQL Fundamentals I candidates are expected to demonstrate proficiency in concepts of relational databases and the powerful SQL programming language. The certification is targeted at developers and database administrators who want to design, develop, and manage SQL based applications with the Oracle database.
Unit 1: Introducing SQL
Unit 2: Using Single-Row Functions
Unit 3: Using Group Functions
Unit 4: Using Joins and Subqueries
Unit 5: Manipulating Data
Unit 6: Creating Tables and Constraints
Unit 7: Creating Schema Objects
Assessment & Award
The course includes practice test designed to test your knowledge under real exam conditions. Each course has number of test sets consisting of hundreds of items to ensure you are 100% prepared before taking your certification exam.
Award
1Z0-051: Oracle Database 11g: SQL Fundamentals
تحديث بتاريخ 08 November, 2015نبذة عن معهد Dorset College
Dorset College has been an established provider of Academic, Professional and Career focused cThierses for over 30 years. They have a long standing reputation for excellence in Education, based on over thirty years experience providing programmes with clearly defined career paths and excellent academic progression. Thier graduates work in many of the leading industries in Ireland and abroad.
At Dorset College They offer a student centred learning experience and take pride in the successes of Thier Graduates. They offer a wide range of full and part-time programmes to meet the needs of learners at all stages in their lives and career. They are committed to ensuring that Thier learners are afforded the opportunity to develop their full potential in a professional and supportive environment.
“They provide you with the opportunity to build yThier qualifications through a career path that meets yThier interests and aspirations in yThier chosen profession”
Programmes are delivered in a dynamic environment by a highly qualified and experienced team of professionals. They have a strong focus on the provision of industry accredited programmes with good career and job prospects as Theyll as offering the ideal platform for academic progression. They provide excellent facilities and support to learners to enable them to achieve their goals. They focus on small class sizes and quality of education.
They constantly consult with Industry experts to ensure Thier cThierses meet and exceed market requirements, giving Thier learners the edge in today’s competitive job market. They regularly invite industry leader guest speakers to give talks in Thier cThierses so that Thier learners get to meet the best of their profession.
If you require further information, please do not hesitate to contact us or drop in and They will be very pleased to discuss the various options available to you. They look forward to meeting and Theylcoming you to Dorset College.
عرض الجميع دورات Dorset College- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Programming and Database Alpha Academy28 EUR
921 EURمدة الدورة التدريبية: Upto 26 Hours - Become An ORACLE Developer eduCBA25 EUR
113 EURمدة الدورة التدريبية: 181 ساعة
