Enquire Now
Menu

Oracle Database 12c - SQL Fundamentals Live Practice Lab

4.6( 81 REVIEWS )
255 STUDENTS
Add To Cart
£279 £89 (inc. VAT)
Buy Now
  • 365 Days
  • ,
  • Course Certificate
  • Awarded by 'Oracle'
  • 10Guided Learning Hours
  • Course Material
  • 10 Number of Modules
  • Official Exam

What Will I Learn?

Learn to become an expert user of Oracle Database, the number one database in the world
Understand the structure of SQL and learn to create objects in the database
Learn the diverse object privileges, multi-row functions, and conversion functions
Understand multitenant architecture and Cloud provisioning using an Oracle Database
Ability to effectively learn the features of oracle database 12c
Learn about the process involved in retrieving data using SQL statements

Overview

Would you like to achieve an excellent online accredited UK qualification, which will demonstrate a high level of skill and knowledge? Look no further than this fantastic Oracle Database 12c – SQL Fundamentals course.

The Oracle-1Z0-061 Practice Lab will provide you with the necessary platform to gain hands-on skills in Oracle. By completing the lab tasks you will improve your practical skills in Retrieving Data, Restricting and Sorting Data, Using Single-Row Functions to Customize Output, Using Conversion Functions and Conditional Expressions, Reporting Aggregated Data Using the Group Functions, Displaying Data from Multiple Tables Using Joins, Using Subqueries to Solve Queries and Managing Tables using DML Statements. These same tasks will help you understand the objectives and competencies required by the Oracle 1Z0-061 certification exam.

Why study at Global Edulink?

Global Edulink offers the most convenient path to gain recognised skills and training that will give you the opportunity to put into practice your knowledge and expertise in an IT or corporate environment. You can study at your own pace at Global Edulink and you will be provided with all the necessary material, tutorials, qualified course instructor, narrated e-learning modules and free resources which include Free CV writing pack, free career support and course demo to make your learning experience more enriching and rewarding.

  • Course Objectives
  • Course Benefits
  • Course Units
  • Course Description
  • Method of Assessment
  • Certification
  • Awarding Body
  • Entry Requirements
  • Career Path and Progression
  • Become an expert user of Oracle Database, which is the number one database in the world
  • Understand the structure of SQL, learn to create objects in the database
  • Understand object privileges, multi-row functions, and conversion functions
  • Understand multitenant architecture and Cloud provisioning using an Oracle Database
  • Gain an accredited Oracle qualification
  • Access to excellent quality video tutorials
  • Learners will be eligible for a TOTUM Discount Card
  • One year's access to the course
  • Support by phone, live chat, and email
  • Join a friendly online learning platform
  • Module 01: Features of Oracle Database 12c
  • Module 02: Retrieving Data Using SQL Statements
  • Module 03: Restricting and Sorting Data
  • Module 04: Using Single Row Functions to Customize Output
  • Module 05: Conversion Functions and Conditional Expressions
  • Module 06: Reporting Aggregated Data Using Group Function
  • Module 07: Displaying Data from Multiple Tables using JOIN
  • Module 08: Using Subqueries
  • Module 09: Managing Tables using DML Statements
  • Module 10: Introduction to DDL Language
This online training course is comprehensive and designed to cover the topics listed under the curriculum. Oracle has announced the withdrawal of this exam on the November 30th, 2019. Therefore, now is the right time for you take this exam to add it to your resume.
Exam Details: Duration: 120 minutes Number of Questions: 75 Passing Score: 65% Format: Multiple choicesIf you would like to gain an official certificate, you will need to purchase and sit the official exam separately. You can purchase the official exam here: https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-061.
Successful learners will be awarded an Oracle Database 12c - SQL Fundamentals certificate.
Oracle certifications focus on IT training and certification for Oracle Technology, so they are the perfect qualifications for all IT professionals, and will help you to gain high-level employment. With 430,000 customers in 175 countries, Oracle provides leading-edge capabilities in software as a service, platform as a service, infrastructure as a service, and data as a service.
Learners should be age 16 or over and must have a basic understanding of Maths, English, and ICT.
Upon successfully completing this Oracle Database 12c - SQL Fundamentals course, you could go on to the higher level of the subject, and may wish to take another Oracle course to further your knowledge. In addition, you could begin working as any of the following:
  • Database Administrator (average UK yearly salary according to payscale.com: £29,779)
  • Oracle Database Engineer (average UK yearly salary according to payscale.com: £41,726)
  • Senior Database Administrator (average UK yearly salary according to payscale.com: £45,729)
  • Database Analyst (average UK yearly salary according to payscale.com: £26,661)

Key Features

Gain an Accredited UK Qualification

Access to Excellent Quality Study Materials

Learners will be Eligible for TOTUM Discount Card

Personalized Learning Experience

UK Register of Learning Providers Reg No : 10053842

Support by Phone, Live Chat, and Email

Course Curriculum

1: Features of Oracle Database 12c
2: Retrieving Data Using SQL Statements
3: Restricting and Sorting Data
4: Using Single Row Functions to Customize Output
5: Conversion Functions and Conditional Expressions
6: Reporting Aggregated Data Using Group Function
7: Displaying Data From Multiple Tables Using JOIN
8: Using Subqueries
9: Managing Tables Using DML Statements
10: Introduction to DDL Language

Students feedback

4.6

Avarage rating (81)
4.6
5 Star
4 Star
3 Star
2 Star
1 Star

No Reviews found for this course.

Add To Cart
£279 £89 (inc. VAT)
Buy Now
  • 365 Days
  • ,
  • Course Certificate
  • Awarded by 'Oracle'
  • 10Guided Learning Hours
  • Course Material
  • 10 Number of Modules
  • Official Exam
WhatsApp chat