Facebook Instagram Linkedin Trustpilot
Online IT Training Courses through IT Academy UK CompTIA | Microsoft | Cisco | AWS | PMI | ITIL | ISTQB | Google | EC-Council | Linux | Prince2 | Oracle | ISACA | HRCI Free Course Demo
Online IT Training Courses through IT Academy UK CompTIA | Microsoft | Cisco | AWS | PMI | ITIL | ISTQB | Google | EC-Council | Linux | Prince2 | Oracle | ISACA | HRCI Free Course Demo

Meet your Instructor:

Aaron Sampson
Instructor: Technology and Development

Meet your Mentor:

Carl Mullin
Mentor: Business/Technology and Developer

Oracle (OCA) Database 12c R2: SQL Fundamentals (1Z0-071)

The 1Z0-071 course is targeted at IT professionals who are working towards becoming an Oracle Database 12c SQL Certified Associate.

Using Structured Query Language (SQL)

Data Manipulation Language and Transaction Control Language

Using Basic SELECT statements Conversion Functions and Conditional Expressions

Displaying Data from Multiple Tables

Using the Set Operators

Managing Objects with Data Dictionary Views

Managing Schema Objects

Data Definition Language (DDL)

SQL*Plus

Restricting and Sorting Data

Using Single-Row Functions to Customize Output

Reporting Aggregated Data Using the Group Functions

Using Subqueries to Solve Queries

Creating Other Schema Objects

Controlling User Access

Manipulating Data Using Advanced Queries

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

3-6 Month Payment Plan available.

Career Ready Education. Register Now for our award winning Cloud based training courses led by Industry Experts. 24/7 Access, Mobile Compatible, Student Support - 99% success rate!

Your Quick Course Guide

Certification: Oracle Database 12c: R2: SQL Fundamentals

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: None

Assessment: 1Z0-071

Resources: Laptop, Tablet or Smartphone & Internet Connection

Expertise Level: Intermediate

Register

Anytime – 24/7 Access

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 info@it-academy.uk

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: