Facebook Instagram Linkedin Trustpilot

ORACLE PL/SQL 12C: SQL DATABASE FUNDAMENTALS (1Z0-061)

This course will teach you about data models, the Entity Relationship Model, the Oracle (HR) sample schema, and the features of SQL Developer – Oracles free integration development environment. This course covers the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of the Oracle Certified Associate certification.

Introduction to SQL: Relational Database and SQL Developer

Introduction to SQL: SQL*Plus and SELECT Statement

Introduction to SQL: Restrict, Sort, and Customize Output

Introduction to SQL: Data Conversion and Aggregating Data

Introduction to SQL: Working with Joins and Subqueries

Introduction to SQL: Data Manipulation Language

Introduction to SQL: Working with SET Operators and DDL

Course Fee: £169 / €169 Incl. VAT

You will receive immediate access to your courses upon registration and course purchase. Our on-demand cloud based training courses are accessible on a computer, laptop, tablet/smartphone for a period of 12 months. You will need to obtain 70% and above to receive your Certificate. Assessments may be retaken at no additional cost. 

Meet your Instructor:

Tracy Odendaal
Instructor: Technology and Development

Meet your Mentor:

Carl Mullin
Mentor: Business/Technology and Developer

  • 24/7 Access, 365 Days
  • Mobile Compatible
  • 1:1 Mentor Certification exams
  • Labs - CompTIA, Cisco, CEH, CodeX
  • 3-6 Months Payment Plan
  • Excellent Student Support
  • Award Winning Training
  • 100% Pass/Course Mastery Certificate
  • Discounted CompTIA Exam Vouchers
  • 12 Months Subscription
  • Free Official Exam Preps

Quick View Of Our Platform:

OR

GET STARTED FROM £49.00 PER MONTH - UNLIMITED ACCESS TO FULL IT LIBRARY

Choose a plan. Complete the 3 step enrolment process, start training today!

GET STARTED FROM £49.00 PER MONTH - UNLIMITED ACCESS TO FULL IT LIBRARY

Choose a plan. Complete the 3 step enrolment process, start training today!

Unlimited access to all courses£49

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

Unlimited access to all courses£65

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

Unlimited access to all courses£79

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

REQUEST A FREE 5 DAY TRIAL, NO CREDIT CARD REQUIRED!

This course will teach you about data models, the Entity Relationship Model, the Oracle (HR) sample schema, and the features of SQL Developer – Oracles free integration development environment. This course covers the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of the Oracle Certified Associate certification.

Introduction to SQL: Relational Database and SQL Developer

Introduction to SQL: SQL*Plus and SELECT Statement

Introduction to SQL: Restrict, Sort, and Customize Output

Introduction to SQL: Data Conversion and Aggregating Data

Introduction to SQL: Working with Joins and Subqueries

Introduction to SQL: Data Manipulation Language

Introduction to SQL: Working with SET Operators and DDL

Course Fee: £169 / €169 Incl. VAT

You will receive immediate access to your courses upon registration and course purchase. Our on-demand cloud based training courses are accessible on a computer, laptop, tablet/smartphone for a period of 12 months. You will need to obtain 70% and above to receive your Certificate. Assessments may be retaken at no additional cost. 

  • 24/7 Access, 365 Days
  • Mobile Compatible
  • 1:1 Mentor Certification exams
  • Labs - CompTIA, Cisco, CEH, CodeX
  • 3-6 Months Payment Plan
  • Excellent Student Support
  • Award Winning Training
  • 100% Pass/Course Mastery Certificate
  • Discounted CompTIA Exam Vouchers
  • 12 Months Subscription
  • Free Official Exam Preps

Quick View Of Our Platform:

OR

GET STARTED FROM £49.00 PER MONTH - UNLIMITED ACCESS TO FULL IT LIBRARY

Choose a plan. Complete the 3 step enrolment process, start training today!

GET STARTED FROM £49.00 PER MONTH - UNLIMITED ACCESS TO FULL IT LIBRARY

Choose a plan. Complete the 3 step enrolment process, start training today!

Unlimited access to all courses£49

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

Unlimited access to all courses£65

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

Unlimited access to all courses£79

FULL IT SKILLS LIBRARY

ONE-ON-ONE MENTOR

PRACTICE LABS

E-BOOKS

MOBILE COMPATIBLE

CERTIFICATE

BUY NOW

REQUEST A FREE 5 DAY TRIAL, NO CREDIT CARD REQUIRED!

Your Quick Course Guide

Certification: Oracle Database: PL/SQL Database Developer 12c

Study Time: 12 Months to complete 30 hours eg study 1 hour per day to complete your course in 1 month |study Full Time or Part Time

Vendor: Oracle

Provider: IT Academy

Student support: One-on-One Mentoring

Pre-requisite: 1Z0-060

Assessment: 1Z0-061

Resources: Laptop, Tablet or Smartphone & Internet Connection

Expertise Level: Intermediate

Salary Indicator

SALARY PROJECTION

Average
salary after
completing

Junior
£37k
Average Salary
You can earn
£50k
Senior
£66k

High

Source: Payscale

£50k

You can earn an average
of £50,000 a year

What’s Included

Replace-trainer-img
  • 24/7 Access, 365 Days
  • Mobile Compatible
  • 1:1 Mentor Certification exams
  • Labs - CompTIA, Cisco, CEH, CodeX
  • 3-6 Months Payment Plan
  • Excellent Student Support
  • Award Winning Training
  • 100% Pass/Course Mastery Certificate
  • Discounted CompTIA Exam Vouchers
  • 12 Months Subscription
  • Free Official Exam Preps

Reviews:

STARTING AN IT CAREER OR UPSKILLING?

Click here to view All Courses or call a Career Consultant on 020 7770 6431 or e-mail [email protected]

Click here to request a free 5 day Trial Course or proceed to STEP 3

Select your course here and click BUY NOW to proceed to checkout 

Register your details and arrange payment via EFT/Credit Card or PayPal

Receive your login details and start immediately

WHAT SETS US APART:

  • Official Partnerships

Partners with IT certification vendors CompTIA, Microsoft & Skillsoft who are the global leaders in online learning

  • We are IT Experts

With over 13 years experience, we have 13 000+ students graduate through IT Academy

  • Award Winning

Latest-in-Market Online Cloud Based Courses delivered via Video, Quizzes, Virtual labs & Mentoring

  • Virtual Practice Labs

Learn, Practice writing Code with instant feedback in a Live Environment

  • Live Mentoring

Free One-on-One Live Mentoring with Certified Industry Experts

  • Practice Tests

Take Practice Tests designed to mimic the actual exam

Accredited by and Partnered with: